Monitoring compilations and recompilations at instance level using Reliability and Performance Monitor
Imagine that you have set up your production SQL server that is hosting several databases used by different applications. Initially your SQL server responds smoothly, but as the number of query requests increases, becoming larger day by day, and when it reaches several hundred per second, you notice that queries take a little longer to execute and your SQL server CPU usage is higher than what you expected.
As you may know, there can be a number of reasons for SQL server to respond poorly, such as:
- Your physical database design and database file placement is not optimized
- Databases are missing proper indexes
- Queries are not optimized and are poorly ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
