Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Optimizer_WhatIF Rss

   Items 1 to 1 of 1   
 

Using Optimizer_WhatIF and StatsStream to Simulate a Production Environment

SQL Server's Query optimiser judges the best query plan from the data in the relevant tables and the server's hardware. How, then, can you investigate the query plans being generated for slow-running queries on a customer's production server when you can neither access the server, nor recreate the database from a backup?  Read more...
By Additional Articles 2013/03/21 | Source: SimpleTalk | Category: optimizer_whatif
Rating:  Rate this |   Briefcase | 2,002 reads
   Items 1 to 1 of 1