Click here to monitor SSC
SQLServerCentral is supported by Redgate
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,139 reads
   Items 1 to 1 of 1