Post reply

Finding which table is on a page

  • September 29, 2006 at 12:07 pm

    #114597

    Hello,

    I'm currently investigating some deadlocks.

    How can I find out which table is on 8:1:123456 ?

    (8=db,1=primary filegroup)

  • October 2, 2006 at 2:03 am

    #663538

    think you'll find the number is the object id ?   ( but i'm not 100% ) I always use server trace flags to resolve deadlocks - creates enormous logs but gets you all the data you'll ever need!  dbcc page checks pages.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • October 2, 2006 at 4:49 am

    #663546

    You can find ObjId in the page header when running DBCC PAGE.

    Kindest Regards,

    Roi Assa

  • October 2, 2006 at 7:37 am

    #663576

    Thanks, I'll have a look into DBCC PAGE

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply