Search
InstantDoc ID
GO

Browse By: Author | Issue

June 22, 2004 09:22 PM

Pageiolatch Values in Sysprocesses

Rating: (0)
Brian Moran
SQL Server Magazine
InstantDoc ID #42902

I'm seeing pageiolatch_sh values in the master..sysprocesses table's lastwaittype column. Many sysprocesses rows that have a pageiolatch lastwaittype also have nonzero values for waittime, so I know that the server process IDs (SPIDs) are waiting. What do the pageiolatch values mean?

...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

The comment reference to DBCC Page with PageResults was especially helpful. It hadn't occurred to me to try page results. Bravo!

Larry4/21/2005 9:16:46 AM

best

GREGORY2/16/2005 11:23:07 AM

good

Anonymous User 2/14/2005 9:37:20 AM

Good stuff

Anonymous User 1/3/2005 11:05:45 AM

Great article.

Anonymous User 12/29/2004 11:51:33 AM

It solved my problem , great stuff

Anonymous User 11/24/2004 3:11:01 AM

Excellent article. Thank you

Anonymous User 11/23/2004 4:00:35 PM

And even more useful is :
DBCC PAGE (9,1,91713,0) WITH TABLERESULTS

Which turns output to a table, that you can use therafter in some smart scripts...


erbellico9/21/2004 7:11:31 AM

GREAT STUFF

Ali baba_SQL8/27/2004 9:28:11 AM

Excellent document on pageiolatch_sh

Olu8/22/2004 4:38:44 PM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.