I'd suggest using the scripting wizard or right-clicking on individual objects as well. That generates the script you need and then you can run them on multiple different machines.

But, if...

Since you're running SQL Server 2008, you can get the deadlock information out of the system_health extended event session without ever setting a traceflag. Here's an introduction to the system_health...

You can contact support. But for premier level support, it's as we've both said. You have it through your MSDN license or you pay for it. That's just how it...

You can contact support. But for premier level support, it's as we've both said. You have it through your MSDN license or you pay for it. That's just how it...

Looking at os_wait_stats is looking at waits aggregated. There's no way to know if those waits correspond to problems during your restore. That's why I suggested looking at sys.dm_exec_requests. That...

rodjkidd (4/5/2013)

---

Steve Jones - SSC Editor (4/5/2013)

---

Cadavre (4/5/2013)

---

I'm in Castle Marina...

ChrisM@Work (4/5/2013)

---

Grant Fritchey (4/5/2013)

---

ChrisM@Work (4/5/2013)

---

Not sure how it will pan out yet. With a couple of good mates in the immediate area and a nearby pub boasting 180 different whiskies[/url],...

ChrisM@Work (4/5/2013)

---

Not sure how it will pan out yet. With a couple of good mates in the immediate area and a nearby pub boasting 180 different whiskies[/url], it's a tough...

To get to premier support, yeah, you've got to cough up cash. If you have a very well documented bug, you can try posting it to the Connect web site....

Also look at sys.dm_os_wait_stats. That's going to tell you specifically what is causing things to slow down on the server. It won't narrow it down to particular processes or anything,...

Yeah, it does sound like contention. Since it's a restore, the most likely place is IO, but it's also going to affect CPU, memory, etc. I would look at sys.dm_exec_requests...

This is seriously fascinating stuff. You have to know that as more and more data about all of us becomes publicly available that it will impact employment. I suspect, based...

If you get desperate, and I've been there, you can issue a CHECKPOINT command, backup the log, issue another CHECKPOINT, and backup the log again. That frequently clears the tail...

If you have lots of ad hoc queries, it's not a surprise that your procedure cache hit rate is low. As a matter of fact, that would be normal. Optimize...

There are actually a number of companies that have gone out of business or suffered major losses due to database issues. I wrote an article about them and published it...