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 recompilations using SQL Server Profiler

If you notice a large number of recompilations in the Reliability and Performance Monitor tool and suspect that your database server is facing a recompilation issue, you would want to confirm it by investigating the issue further, to identify which queries of which databases are causing the recompilation issues.

To investigate the root cause of the recompilation issue, we will use SQL Server Profiler. In this recipe, we will learn how we can trace recompilation events occurring on SQL server for individual SQL statements and stored procedures as well. With the help of SQL Server Profiler, we can identify the databases where recompilations occur and can identify queries and stored procedures that ...

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