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
Data Analyst
Learn the skills to analyze, interpret, and present data for informed business decisions.
Business Analytics
Explore data analysis techniques to drive business performance and decision-making.
Master Statistics with Python
Learn the statistics behind data science, from summary statistics to regression models.
Intro to Data Analysis
Understand the principles of data analysis, including techniques for data collection, cleaning, and interpretation.
Learn Python 3
Learn the basics of Python 3.12, one of the most powerful, versatile, and in-demand programming languages today.
Introduction to Data
Learn the fundamentals of data collection, analysis, and interpretation.
There are no reviews yet.