Error occurred while attempting to drop allocation unit ID

Anyone have any experience with this?  I'm on  64 bit Sql 2005 Standard SP3. 

These errors are showing up in my sql server logs and roughly correspond with periods of poor

db performance.

 

03/05/2011 16:02:18,spid431,Unknown,Error [36<c/> 17<c/> 145] occurred while attempting to drop allocation unit ID 438356380090368 belonging to worktable with partition ID 438356380090368.

03/07/2011 14:42:18,spid333,Unknown,Error [36<c/> 17<c/> 145] occurred while attempting to drop allocation unit ID 438859152752640 belonging to worktable with partition ID 438859152752640.

March 8th, 2011 8:22pm

Please post the results of SELECT @@VERSION.

I would suggest installing the latest SP and Cumulative update to see if the problem goes away.

 

See: http://www.sqlteam.com/article/sql-server-versions

Free Windows Admin Tool Kit Click here and download it now
March 9th, 2011 7:50pm

We had this exact problem when we were on SQL Server 2005 SP2 early builds when there was high tempdb activity + a mistimed job that updates statistics on a relatively large table in the middle of the day.

 

After talking to Bob Ward at MSFT, it was identified that a resource monitor was trying to free up a cached plan that has a cursor, where it was trying to deallocate a worktable but gets stuck on a latch for an IAM page in tempdb.

 

The solution that worked for us was to change the schedule for the update stats job + reduced the load on tempdb.

 

I would suggest you to look at the VirtualFileStats DMV and see the amount of IO you are doing against tempdb when compared to other databases. For us at the time of this issue, our tempdb IO activity was 90% of the total activity on the box. After few optimizations, we got it down to 50-60%.

 

I am NOT sure if this really helps you but wanted to share some notes.

March 9th, 2011 8:24pm

I am fencing problem in mssql 2012 with enterprise edition.Please any one having suggetion. Please.Please share
Free Windows Admin Tool Kit Click here and download it now
March 5th, 2015 6:59am

It does no good to post a followup question to a very old and answered thread, especially when you have a different environment. Start your own thread and post as much useful information about your environment as you can.  There are sticky posts at the top of the forum that provide suggestions.
March 5th, 2015 8:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics