VIVEKANANDHAN_PERIASAMY
asked on
What is spt_fallback_usg- SQL SERVER
DBCC page (8, 1, 223093)
and got the meta data object id : 149575571 which was having waittime 498758494
And I ran below query to get theobject name
select OBJECT_NAME(149575571)
which gave me the output as spt_fallback_usg
What does this mean?
and got the meta data object id : 149575571 which was having waittime 498758494
And I ran below query to get theobject name
select OBJECT_NAME(149575571)
which gave me the output as spt_fallback_usg
What does this mean?
Matt Bowler
spt_fallback_usg is one of the tables in the master database. Where are you seeing the wait time? It's not returned from DBCC PAGE.
ASKER
when i ran the dm_trans_lock, i got the resource is waiting for the page 8, 1, 223093.
Then ran the dbcc page to get the metadata objectid. From that,ran object_name to get the resource information.
What is the use of this table?
Then ran the dbcc page to get the metadata objectid. From that,ran object_name to get the resource information.
What is the use of this table?
Something doesn't add up here. spt_fallback_usg is a table in the master database. The locks you are seeing are some process trying to lock the pages of a user database - whatever gets returned from: select db_name(8).
Can you please make sure you are in the database from above context when you check the object. ...
use <your database>
select * from sys.objects where [object_id] = <the metadata id from dbcc page>
Can you please make sure you are in the database from above context when you check the object. ...
use <your database>
select * from sys.objects where [object_id] = <the metadata id from dbcc page>
ASKER
Great!!! I think I have made the mistake in changing the database context. But I'd like to know the purpose of this spt_fallback_usg table.I tried searching in the net but couldn't find the information.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.