Thanks Lowell

This is very interesting. I am still getting no results returned. Executing this query via DAC

I downloaded the resource dbs, I will try again after I replace the resource...

Well, that's the problem. This didn't come from our source control. It was a rogue trigger added by our hosting provider and dropped when users started getting kicked out. I...

Thanks Gail.

Sorry, I forgot to mention. I restored the master backup and I am querying the DB but I cannot find it. I am running the below query

select * from...

I had a parallel post on MSDN social. Definitely recommend reading Jonathan Kehayias excellent write up with hotlinks

SQL2005 on VM

Strange assumption

Not really,...

SQLGuru, thanks for the advise. No offense to Bart, but those articles (all 3)...

Thanks Wayne, interesting query. I would just modify it to extract deadlock graph from the XDL file.

I have the details but confused why even with the triggers disabled keys are...

Leo,

The SQL is enclosed inside the graph. You can open the XDL file in text and you should the same and more details as the trace. Let me know if...

Monitored the VM host and have some additional details on the high signal times;

CXPACKET - due to shared processors between instance. My guess is OS is context switching between CPU...

Thanks Gail .. I missed the subqueries ... i feel stupid .. 🙂

I'm sorry may be I didn't state clearly. Size is not my concern just the # of reads against the log file. I've a different DB with XML data that...

Gail, Paul, thanks for sharing your knowledge and experience ...

The trend except for the # of reads on the log file hasn't changed for this app

Full backup -...

Thanks Paul; will give that a spin ...

I don't know if you had a chance to review the dmv stats I posted. In your SQL adventures, have you ever seen...

I can get the number of explicit rollbacks issued and the #bytes affected/ explicit rollback from sql traces. Is there a way to capture and account for implict rollbacks? same...

Thanks Paul; interesting ... is there a way to calibrate the # of rollbacks?