Please enable JavaScript.
Coggle requires JavaScript to display documents.
Monitor and Optimize Operational Resources in SQL Server - Coggle Diagram
Monitor and Optimize Operational Resources in SQL Server
Performance monitoring
Performance Monitor with SQL Server on an Azure Virtual Machine
Critical performance metrics
Review of Azure metrics
Create metric alerts
Review older performance data
SQL Server metrics that matter
Establish baseline metrics
Correlating SQL Server and operating system performance
Wait statistics
Azure Intelligent Insights
Intelligent Insights storage options
SQL Insights in Azure Log Analytics
Identify problematic queries
Causes of performance issues
SQL Server Query Store
Query Store reports
Performance overhead of the Query Store
Plan forcing in the Query Store
Blocking and locking in SQL Server
Isolation levels
Monitoring for blocking problems
Data file fragmentation
SQL Server resources for optimal performance
Optimize Azure storage for SQL Server virtual machines
Azure managed disks
Striping disks for maximum throughput
Azure Virtual Machine resource provider
Virtual machine resizing
Using constrained cores
Using general purpose virtual machines
Resizing virtual machines
Optimize database storage
Proportional fill
Tempdb configuration in SQL Server
Control SQL Server resources
Resource pools
Workload group
Classifier function
Resource Governor Use cases
Configure databases for performance
Database scoped configuration options
Database compatibility level
Intelligent query processing
Adaptive query processing
Table variable deferred compilation
Batch mode on row store
Scalar user-defined function inlining
Approximate count distinct
Query store in Azure Database for MySQL and PostgreSQL
Query Store in Azure Database for MySQL
Query Store in Azure Database for PostgreSQL
Performance-related maintenance tasks in SQL Server
Maintain indexes
Rebuild and reorganize
SQL Server on an Azure Virtual Machine
Azure SQL Database
Azure SQL managed instance
Maintain statistics
Automatic tuning
Automatic tuning features
Automatic plan correction
Automatic index management