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

Content with tag Waits and Queues Rss

   Items 1 to 3 of 3   
 

A first look at SQL Server 2012 Availability Group Wait Statistics

If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to many of the causes of problems. Although several wait types are documented, there is nothing like practical experiment to familiarize yourself with new wait stats, and Joe Sack demonstrates a way of testing the sort of waits generated by an availability group under various circumstances.  Read more...
By Additional Articles 2012/06/12 | Source: SimpleTalk | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,878 reads

Wait statistics, or please tell me where it hurts

How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?   Read more...
By Paul Randal 2010/12/16 | Source: SQLskills | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,636 reads

Signal Waits and Resource Waits...a clarification

  Signal Waits vs. Resource Waits During my presentation at SQLSaturday#59, I spoke about the categories of wait types, such as...  Read more...
By Robert Pearl 2010/12/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,628 reads
   Items 1 to 3 of 3   
 
Tags
alwayson (1)    
availability groups (1)    
blogs (1)    
performance tuning (1)    
resource waits (1)    
signal waits (1)    
sqlsaturday (1)