reporting and monitoring

redwood739


Hey all
I am new here and fairly new to SQL server. And yes i have a question, that maybe dumb.
My boss wants me to reporting to him the health of the DB each week. So here are a few questions.
1. What really defines the "health" of a DB What elements should I be reporting to him
2. Is there any utilities out there that would be helpful or can SQL provide enough info
3. I am using 2005 standard, so I have the shipped reports in summary page. But is this enough and can I customize them
Sorry I am having a hard time even asking the questions cause I am not really sure what to ask. Any help or pointing down t he correct path
would be greatly appreciated.
Thanks,
jason

and what about 3rd party utilities such as this>>>>

Buck Woody - MSFT

Jason - there are no dumb questions. Everyone in this forum is new to SQL Server, so it's OK not to know something.

I've done a series of articles on this topic that might help, and I've included links at the bottom of each that will reference other sites. Start with this topic and then use the links on the left of the page to move around, or click the "Next Section" link at the bottom of each. This site also has some other practical articles that might help you out if you're new to SQL Server.

http://www.informit.com/guides/content.asp g=sqlserver&seqNum=195&rl=1

(If this answers your question, make sure you mark it as answered so that others can find it)

redwood739

Hey thanks buck! the article looks great, I'll have to go over it in more detail this weekend, just skimmed through a few minutes ago.