4
Monitor and optimize operational resources in SQL Server
source link: https://docs.microsoft.com/en-us/learn/paths/monitor-optimize-operational-resources-sql-server/?WT_mc_id=modinfra-11462-thmaure
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
4000 XP
Monitor and optimize operational resources in SQL Server
- 3 hr 10 min
- Learning Path
- 5 Modules
Intermediate
Administrator
Azure
Configure hardware and server resources for optimum performance after establishing a baseline. Identify sources of performance problems. Troubleshoot using Azure SQL Intelligent Insights.
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
- Experience using Windows Performance Monitor to monitor system components such as CPU, I/O, network traffic
- Knowledge of purpose of SQL Server system databases: master, tempdb, msdb
- Basic understanding of SQL Server file storage
- Basic understanding of structure and usage of SQL Server indexes
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK