June 20, 2005 at 10:29 am
HI. in my enterprise manager, i'm seeing in the WAIT TYPE column: pageiolatch_ex and in the WAIT RESOURCE: 21:1:63933?
Can someone explain what this means? or direct me to a document that explains this?
Juanita
June 20, 2005 at 11:02 am
Check out Books Online for an article entitled "Displaying Locking Information"
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 20, 2005 at 11:03 am
Juanita,
Wait Type is a type of lock, please see
http://www.sqldev.net/articles/wait_types.htm
In your case this article says:
| PAGEIOLATCH_EX | 0x424 | Exclusive buffer page I/O latch |
Wait resource is a resource that is affected. BOL in the topic Sysprocesses Table says: "Textual representation of a lock resource."
Regards,Yelena Varsha
June 20, 2005 at 11:07 am
Thank you so much for the replies... I'm reading about them now.
Juanita
June 20, 2005 at 11:07 am
Specifically, a Latch is a lightweight lock, used by SQL Server as pages are read from disk into memory.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply