Error[36, 17, 145] occurred while attempting to drop allocation unit

_{Wednesday, September 26, 2012 9:49 PM}

The following error message has been logging in SQL log 2-3 times during production hours  in last 3 weeks .

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

I have been monitoring Database to find out if any queires ,reports and stored procedure might be throwing this error in SQL log but I could not identify it .

Would you please help me How do I start investigation ?

What would be impact on database perfomance when this error is occured ?

Thanks

Daizy

_{Friday, September 28, 2012 3:10 AM ✅Answered}

Hi Daizy,

Error [%d, %d, %d] occurred while attempting to drop allocation unit ID[] belonging to worktable with partition ID [], please try to install the latest SP(Services Pack) and Cumulative update to see if the problem goes away.

The case is similar to you, please refer to: http://social.msdn.microsoft.com/Forums/is/sqldatabaseengine/thread/3c405637-5453-46ea-9e45-83da4055fe50
Please refer to: http://support.microsoft.com/kb/916086 .
 

Regards,
Amy Peng

Amy Peng

TechNet Community Support

_{Friday, September 28, 2012 4:54 AM ✅Answered}

Hi,

What is the version and build of SQL instance? Are there temporary tables being used? Base don the error message, you may want to find out the object which throws this error. Following query should help you in finding the object ID unless that belongs to a temp object in tempdb (Since dbid is not known from the error message, you may have to run this query in all the databases)

select OBJECT_NAME(object_id),* from sys.partitions where partition_id  = <partiotin ID in the number above> 

If above doesn't return any rows, and issue occurs at a particular time, you may want to runs server side travce to figure out the query throwing this error.

This posting is provided “AS IS” with no warranties, and confers no rights.

If this reply answers your question, please mark it as Answered for others to find it easily.
If this reply help you resolving the problem, please vote the post as Helpful.