O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required