Monthly reports (BSC)

[Rosko]

Hi,
Does anyone collect data from your SQL server and generate monthly reports on CPU usage, db growth and so on...

What do you use for a tool? Or did you generate reports yourself and how did you go about that?

How much performance degradation does continually polling generate?


THX in advance for sharing your experiences

Rosko

 

[SQLBill]

I do a daily report on the database growth. I use sp_spaceused to gather the data.

-SQLBill

Posting advice: FAQ481-4875

 

[Rosko]

Thanks SQLBill,
That's one way to go, but still not enough,
I have to have something that collects CPU usage as well without generating to much overhead.

Got any ideas?

Thanks


Rosko

 

[Catadmin]

CPU usage is best collected via Windows Performance Monitor. It may not give you just SQL usage, though.



Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"