Congratulations on your first article. Nice work.

For the future, a few suggestions that might help. Doing a how-to article like this is great. But you also need to include guidance...

Any of the Threadizens going to be in Vegas for SQL Intersection this week?

For larger data sets, I'd work on getting rid of that DISTINCT operator. It's going to lead to issues because of the aggregation. But, leaving everything roughly the same, I...

What kind of database server are you connecting to? If it's a 2000 box, or a database set to 2000 compatibility on a 2005 or 2008 box, then you won't...

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...