So anyone else have experienced an actual DR? I would like to here more from them. What did they learn? That doesn't mean just like a Sandy situation but also...

DR + BCP = Success 🙂

Hello Everyone,

I have just updated the script to have the 7) and 8) comments reversed. Sorry about that and the delays to get it corrected. The update should be on...

Hello Everyone,

Here are several observations I have notice over a period of 10+ years working on disaster recovery.

1) Most people have no idea of how their SQL production servers...

I agree, the newer code is displaying the data much better than my code did. My apologies.

Hats off to you all!!! 🙂

Thanks,

Rudy

Thanks again to everyone for the improvements 🙂

Rudy

Excellent Tony. Thanks for the information.

Rudy

nickm_GR (11/27/2012)

---

I'm trying to understand the first two sets of results and where they come from in the code. You'll notice I get three result sets back, where do the...

Thanks Greg for the updated code. As we all know there are more than one way to skin SQL server 😀

Rudy

The temp tables are used to add the possible issues to the results. 🙂

ahperez (11/26/2012)

---

Thanks for taking the time to post this script. I find the "Possible Issues" column very useful. Spurred me to take the time to find updated firmware for my...

Hi Tony,

I haven't seen Glenn's code so I can't comment on it. My code reads from sys.dm_os_wait_stats and then produces a report from the top 10 in descending order.

As...

Hi Tony,

The code you are showing will produce percentages. My code shows information directly from SQL server along with the comments.

I didn't change the numbers to percentage yet but could...

Tony Trus (11/22/2012)

---

Thanks for the script. I had been using Glenn Berry's one from a year ago and I like how this one does some nice data manipulation so its...

Caruncles (11/22/2012)

---

I'm not in the same league with you guys as far as what this all means. I apologize for any dumb questions, but is this reporting CURRENT activities...