O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

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

Implementing the plan guide to enhance compile-time and run-time execution plans

SQL Server query optimizer is an efficient engine that plays an important role in producing an efficient query execution plan for a query. By default, the optimizer decides the eligibility for parallel operation by creating a parallel query plan. Many times, this may not be an efficient plan based on the optimization goals that are specific to an application; thus, using the plan guide process is a recommended method. In such cases, the query plan can be optimized or tailor-made based on the response time, disk IO, memory, and CPU.

The troubleshooting aspects of query performance involve the review of many areas such as design, table indexing, and query execution. ...

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