Post reply

waitresource

  • October 28, 2003 at 8:09 am

    #151961

    What does the following waitresources from sysprocesses mean:

    TAB: 29:219147826 [[COMPILE]]

    and

    29:1:326542

    ?

  • October 29, 2003 at 3:01 am

    #480041

    "TAB:" means this is waiting for a table, "29:" refers to Database id 29 in master..sysdatabases.dbid, ":1:" refers to file 1 in sysfiles and ":326542" refers to the page. Not sure what [[COMPILE]] refers to, probably something compiling which needs that tables structure and statistics in its' query plan.

    Keith Henry

    DBA/Developer/BI Manager




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

Viewing 2 posts - 1 through 1 (of 1 total)

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