Click here to monitor SSC
SQLServerCentral is supported by Redgate
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 | 2,088 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,762 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: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,960 reads
   Items 1 to 3 of 3   
alwayson (1)    
availability groups (1)    
blogs (1)    
performance tuning (1)    
resource waits (1)    
signal waits (1)    
sqlsaturday (1)