SQL Server Performance

Allocation Error on SQL 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by Raulie, Feb 16, 2007.

  1. Raulie New Member

    Hi all

    I am getting this error message on one of my servers. Has anyone encountered this before?
    I got this error message last night and night before around the same time.

    Message
    Error [36, 17, 145] occurred while attempting to drop allocation unit ID 463195007221760 belonging to worktable with partition ID 463195007221760.

    Raulie



  2. MohammedU New Member

    What is your build and SP?
    Check the following

    FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005
    http://support.microsoft.com/kb/916086/en-us


    MohammedU.
    Moderator
    SQL-Server-Performance.com
  3. satya Moderator

    When was the last time the DBCC DBREINDEX & CHECKDB has been scheduled or executed?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  4. Raulie New Member

    Mohammad - It is Build 3790: Service Pack 1 none of the errors in the KBA article have been found an my error logs.

    Satya - There is a maintenance job that runs every Sunday. I have not seen any allocation errors reported. I ran DBCC CHECKDB WITH ALL_ERRORMSGS last Friday and did not find any errors.

    Raulie



  5. MohammedU New Member

    Are you still experiencing this error? If yes, run the sql trace with error and warning events and see what SPID is causing this and what is the sql statement/procedure it is executing...

    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page