CODEWITHSUNDEEP
sql-server
Konstantin Knyazev
Konstantin Knyazev

Reputation: 73

What does DB: waitresource means in sys.sysprocesses?

I'm monitoring SQL server's health by querying sys.sysprocesses View. There is waitresource column and there is a lot information about PAG:,TAB:,KEY:,RID: resources, but I can not find any information about DB: resource like DB: 17:67. 17 is database_id, but what means second number, 67?

Upvotes: 1

Views: 2867

Answers (1)

userfl89
userfl89

Reputation: 4800

This is probably either DatabaseID:ObjectID:IndexID if the resource in question is a table or DatabaseID:FileID:PageID if a page is the resource. See the documentation below for specifics on this. I'd also recommend using the current DMVs and a list mapping older system objects to the corresponding current ones can be found here.

MSDN SQL Server Blocking

Upvotes: 1

Related Questions