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


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Cathan Kirkwood » How to Diagnose and Fix Wait Locks
Add to briefcase
12 posts, Page 1 of 2
12»»

How to Diagnose and Fix Wait Locks Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Scorpion_66
Posted Monday, November 18, 2002 12:00 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 10, 2012 6:37 AM
Points: 593, Visits: 25
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/ckirkwood/wait_types.asp


Post #8243
ckempste
Posted Thursday, November 21, 2002 2:56 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1
Fantastic article.. thanks for the insight into some of the lower level commands, most appreciated.


Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Post #46925
joachim.verhagen
Posted Thursday, November 21, 2002 4:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, May 03, 2013 7:26 AM
Points: 224, Visits: 118
Great article.
Can you tell what to do with the resultset of dbcc sqlperf(waitstats)
I saw that it is accumulative, so you have to take the up time into account.
But what is the unit of measurement and the difference between "wait time" and "signal wait time"?


Post #46926
Klaas-Jan
Posted Thursday, November 21, 2002 6:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 10, 2002 12:00 AM
Points: 135, Visits: 1
Good article , nice to have all waittypes described


Post #46927
skasarla
Posted Thursday, November 21, 2002 7:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 13, 2006 12:23 PM
Points: 193, Visits: 1
Great Article and very good insight into tackling the lock waits in a transactional system.


Post #46928
Scorpion_66
Posted Thursday, November 21, 2002 5:12 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 10, 2012 6:37 AM
Points: 593, Visits: 25
Yes, joachim.verhagen, it is cumulative. The measurement is in milliseconds. The difference between Wait time and Signal Wait time is basically the difference in waiting on something and communicating about waiting on something, to put it in simple terms.


Post #46929
ckempste
Posted Thursday, November 21, 2002 7:11 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1
Hi all

Some things to remember..

a) measures physical io, not logical, flush buffers when testing
b) force checkpoints when testing writes to force log flush

before trying it all on prod

Cheers

Ck


Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Post #46930
Prakash Heda
Posted Thursday, November 21, 2002 9:59 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, February 17, 2013 2:38 AM
Points: 369, Visits: 392
Best diagnone i have ever seen. No one can beet this..............
Thumbs up............Prakash

Prakash

Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
Post #46931
Scorpion_66
Posted Saturday, November 23, 2002 9:06 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 10, 2012 6:37 AM
Points: 593, Visits: 25
I'm blown away by the responses to my article, and very much appreciate the comments posted, but does anyone know anything about the waits I didn't talk about. I would very much like to "fill in the gaps" so to speak. What I have is simply what I've garnered over the years, and to date, I have been unsuccessful in ever finding any real documentation on any of the ones not in BOL.



Edited by - Scorpion_66 on 11/28/2002 9:44:59 PM


Post #46932
Yukas
Posted Saturday, April 12, 2003 7:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 11, 2005 5:16 AM
Points: 47, Visits: 1
This must be in BOL IMUO (In My UNHonest Opinion)


Post #46933
« Prev Topic | Next Topic »

Add to briefcase
12 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.