Me too. This place is excellent. Thanks Steve.

Jeffrey Williams (4/6/2009)

---

Not in v1 (AFAIK) - but, I hear that v2 not only has remoting capabilities but also the ability to create multiple threads (jobs).

I use powershell scripts to...

We've started using PowerShell more and more, but not so much for monitoring since we use Operations Manager for that. We've mainly been using it as a means for cleaning...

It is possible that checking the queries and getting a good index in place may help as well. I'm personally not a fan of the DTA, but it can help....

First, turn off 1204 when you're collecting the info with 1222. It'll cut down on the noise and make it a bit easier to read.

Second. You're getting lock escalation as...

All three queries are going after sgDataOPERATIONS. Is there a read statement prior to the delete statements that would cause lock escalation? What do the execution plans look like on...

1204 puts out a hard to use deadlock graph. If you can, can you recapture it using traceflag 1222? That one is much cleaner and easier to read.

Check the actual execution plan. In the properties of the various processes it will show you if you're using parallelism and how many threads were used by the process.

Excellent. Glad you tracked it down. Thanks for posting the solution here.

I'm really against a black list. I'm far too likely to end up on it one day. Plust I'm probably not going to consult it until I've already stepped into...

Assuming the...

Best wishes Roy.

There's no 100% sure way to verify that things are not used in your database. As others have outlined, it's possible to see whether or not things have been accessed...

Something is holding a lock on your system. It could be a long running process or an uncommitted or unrolledback transaction. Try looking at sys.dm_os_waiting_tasks or sys.dm_tran_locks to see what's...

Don't use auto shrink. That's a major performance hit in most circumstances. If you've had some kind of over-sized transaction or error with the log backups or something that caused...