S.K. (12/15/2009)

---

I apologize if I missed some of the information posted earlier, but as a general practice when upgrading, we do the following at my company:

1. DBCC CHECKDB([dbname]) with data_purity

2....

Thanks, but again - please, no more suggestions about how to optimize this particular query. I don't want to go down that road.

I am going to try Steve's suggestion...

Thanks, guys! I'll try checkdb, updateusage, and updatestatistics again. I already did that, but I did it using a maintenance plan in SSMS, so maybe doing it this...

Thanks for the replies!

Here are my responses:

RichB: I did try running UpdateUsage and it finished fairly quickly, but didn't solve my problem.

Muthukumaran: You asked that I attach the full execution...

Hey, everyone. Thanks for all the replies!

Ok, first of all, sorry for the lack of details. I was hoping for some general known issues in upgrading from 00...

notified in real time when a lock is still locking. Maybe I can't use the alerter after all. Rats.

No, sorry - you're right. I didn't create a deadlock. I want to monitor locks, not deadlocks. I've tried various locking counters and the last one I...

Thanks. I'll look into that.

I found another way that seems to be the easies - what about setting up an alert in the SQLServer:Locks object? Are you familiar...