Configure SQL Server resources for optimal performance
|
Choose the appropriate size and storage options for your Azure SQL databases. Configure server resources such as tempdb. Understand the usage of Resource Governor.
Understand your options for configuration of Azure storage, Learn how to configure TempDB data files in SQL Server, Learn how to choose the right type of VM for SQL Server workloads, Understand the use cases and configuration of Resource Governor in SQL Server
Prerequisites
Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
Experience creating and configuring resources using the Azure portal.
Knowledge of purpose of SQL Server system databases: master, tempdb, msdb
Basic understanding of SQL Server file storage.
User Reviews
Be the first to review “Configure SQL Server resources for optimal performance”
Related Products
Intro to Data Analysis
Understand the principles of data analysis, including techniques for data collection, cleaning, and interpretation.
Learn SQL
In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.
Visualize Data with Python
Learn to make effective data visualizations in Python with Matplotlib and Seaborn.
Statistics for Data Analysis
Learn statistical methods and techniques for analyzing and interpreting data.
Introduction to Data Analytics
Get introduced to data analytics methods for extracting insights from data.
Learn R
Learn how to code and clean and manipulate data for analysis and visualization with the R programming language.
There are no reviews yet.