Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag update statistics Rss

   Items 1 to 5 of 5   

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 plans
Rating: |  Discuss |   Briefcase | 7,091 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,948 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,091 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,658 reads

Update Statistics

By FOR SQLSERVER 2011/07/06 | Category: update statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 2,523 reads
   Items 1 to 5 of 5   
async (1)    
database maintenance (1)    
dtsx generate (1)    
execution plans (1)    
integration services (ssis) (1)    
internal activation (1)    
multi-threading (1)    
online re-indexing (1)    
parallel (1)    
parallel execution (1)    
performance tuning (1)    
service broker (1)    
sp_updatestats (1)