What tools? What are you thinking of?

The Management Data Warehouse will do this, but it's a lot of admin, IMHO.

Extended Events or Trace can help, but they are a little...

Vila Restal (12/21/2012)

---

Lastly, this method of collecting a poll isn't very efficient for you or the contributors.

Does this blog not have a survey facility or at least a thread...

We use it here at SQLServerCentral. We expose the data at monitor.red-gate.com. It's delayed slightly and replicated to another server for the public side, but you can play with lots...

Nope, it's fine with me. If you like it,...

Did the world end and SQLServerCentral make it to heaven? All you here with me?

Vila Restal (12/21/2012)

---

"I was taking to someone recently and this person had a large transaction load on their SQL Server."

Is that a euphemism and is that why you took to...

Don't shrink your databases regularly. If you need to do this, it's a rare, one-time event as Sean mentioned.

I checked the SQL Servers, but everything seemed to be in order there. I suspect the mail servers had some issue.

Looks like they're working as I just got about 150...

The index stats are cleared out when the server is restarted, so if you have done that, this isn't accurate.

The index stats are a good place to start, however. What...

Arrgggg, my image didn't post.

Trying again

Chris Metzger (12/19/2012)

---

You know I wish more managers\executives thought this way. It makes no sense to emphasize the cert but not the real-world experience - sometimes some of us...

You don't want alerts when CPU > 80%. This happens all the time in a normal SQL Server and it's not a problem. What you want to be concerned about...

In addition to Gus' question, are you going to manually look through this data every two hours? Or are you storing it somewhere? If it's the former, I think you're...

No worries, another one for...

I would tend to agree with Sean. Likely this could be rewritten to function much better and quicker.