| Janos Horanszky 2005-11-10, 8:23 pm |
| What WaitType 1028?
Where can I get a full list of values and explanations?
What I have so far is this:
Case WaitType
When 0x0 Then ' '
When 0x0005 Then 'Exclusive Page Lock'
When 0x0012 Then 'Table Lock'
When 0x0013 Then 'Exclusive Buffer Lock'
When 0x0020 Then 'Disk I/O'
When 0x0022 Then 'Buffer Being Dirtied'
When 0x13 Then 'Exclusive Buffer Lock'
When 0x23 Then 'Buffer Being Dump'
When 0x5 Then 'Exclusive Page Lock'
When 0x6 Then 'Shared Page Lock'
When 0x800 Then 'Network I/O'
When 0x8001 Then 'Exclusive Table Lock'
When 0x8003 Then 'Exclusive Intent Lock'
When 0x8004 Then 'Shared Intent Lock'
When 0x8005 Then 'Exclusive Page Lock'
When 0x8006 Then 'Shared Page Lock'
When 0x8007 Then 'Update Page Lock'
When 0x8011 Then 'Shared Buffer Lock'
When 0x81 Then 'Write Log'
Else 'Unknown'
End as 'WaitReason',
Thanks a bunch,
Janos
|