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

Articles with tag update statistics Rss

Search for any content tagged update statistics

   Items 1 to 4 of 4   

A Spectacular Case of 100% CPU Caused by Online Reindexing

An investigation of a serious performance issue during online re-indexing on a production server leads us to interesting discoveries and solutions.  Read more...
By Viktor Gorodnichenko 2014/12/11 | Source: | Category: execution plan
Rating: |  Discuss |   Briefcase | 7,072 reads

SQL Server's Auto Update Statistics Async Option

I have been trying to tune my SQL Server and I noticed a few database settings for statistics. I also read the previous tip on automatic statistics updates. Could you please describe the Auto Create Statistics Async option? How is this configured and when should I use it and when should I avoid using it?  Read more...
By Additional Articles 2013/03/26 | Source: | Category: async
Rating: (not yet rated)  Rate this |   Briefcase | 3,858 reads

Update statistics in parallel

This articles shows a technique that generates and launches an SSIS package to update statistics in parallel.  Read more...
Rating: |  Discuss |   Briefcase | 5,061 reads

Turbocharge Your Database Maintenance With Service Broker: Part 1

Are your maintenance windows too wide? Find out how to shrink them with Service Broker.  Read more...
By Marios Philippopoulos 2012/07/09 | Source: | Category: service broker
Rating: |  Discuss |   Briefcase | 7,498 reads
   Items 1 to 4 of 4