Whisper9999 (5/12/2010)

---

Thx. I should have been a little more specific. What I mean is that we are seeing a "perfectly fine" query blocking, as in when you...

Server-side profiler trace is your best option to get all the data you want and not miss any logins.

Make sure to include the TextData field to get the procs and...

You are not off base. I/O is basically reads & writes to the hard drive. If your disk controller went whooey recently or if there's another problem bottlenecking your I/O,...

If I'm not mistaken, Data Mirroring uses the Service Broker to transmit data over to the mirror. So everything is queued up as messages that are read into the mirror....

Try this from different workstations and from the server directly. Do you still get the same error?

What edition & version (including service packs) of SQL Server are you using?

If someone asked me about the accuracy in an interview, my response would be "I don't know. I've never needed GetDate() or related functions to be that precise. If and...

GilaMonster (5/12/2010)

---

Same way you plan for any other scenario. Examine the risks, the chances of it happening, examine the...

Re-indexed as in recreated the ones that...

That seems to be an awfully low number of allocated pages. Did you run this after hours or during business hours?

Also, did you run it while the queries you...

If you haven't verified what, how do you know it's blocking at all? Are you getting a deadlock error? What messages are you seeing?

Sp_who2 shows blocking SPIDs and you can...

Actually, this other response brings up a good point. What exactly is the proc blocking? Or being blocked by?

It's not a bad idea, but the problem is, you lose all your history going forward from the point of backup.

A slightly better idea would be to export the TABLE...

Ah, I thought it was something specific to the code that you could point me to.

CirquedeSQLeil (5/7/2010)

---

It seems that this statement is causing a lot of page allocations due to the delete statement. I would certainly take it back to the vendor and ask...

Could you share so that future readers of this thread know what to look for?

You're quite welcome.