SQL Server Performance

SELECT OBJECT_NAME returns ALLOCATION

Discussion in 'Performance Tuning for DBAs' started by HarryArchibald, Feb 18, 2003.

  1. HarryArchibald New Member

    I am investigating the performance of a server running a third-party app. I was doing some ad-hoc monitoring when I noticed that 8 processes were waiting for the same object in tempdb.

    I used dbcc page to return the object id and object_name to return the object name which was ALLOCATION.

    My guess is that it would be something to do with memory but I can find no reference to ALLOCATION and have not come across it before.

    Has anyone else found similar errors?
  2. sqljunkie New Member

  3. HarryArchibald New Member

    Perfect.

    Cheers.

Share This Page