How to generate Monthly statistical reports for SQL server databas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kumar - 26 Mar 2008 20:09 GMT

HI Folks,

My management asking generate monthly reports on all produciton sql server
databases with different statistics.

How can I generate them?

Is there any system tables that store historical statistical data?
Is there any software does that kind of monthly reports?

Our Oracle DBA provides the following statistical data to mangement. I want
to generate similar for all sql server databases.
But I don't know how to achive that? Please help me.
--Kumar

● Report Summary
● Wait Events Statistics
● SQL Statistics
● Instance Activity Statistics
● IO Stats
● Buffer Pool Statistics
● Advisory Statistics
● Wait Statistics
● Undo Statistics
● Latch Statistics
● Segment Statistics
● Dictionary Cache Statistics
● Library Cache Statistics
● SGA Statistics
● Resource Limit Statistics
● init.ora Parameters

Back to Top
Wait Events Statistics
● Wait Events
● Background Wait Events
● Time Model Statistics
● Operating System Statistics
● Service Statistics
● Service Wait Class Stats

Reply to this Message

Tibor Karaszi - 26 Mar 2008 20:57 GMT

You can't expect a report to look the same way, since Oracle isn't the same thing as SQL Server. But
you can get to similar type of information (in SQL Server 2005) using "Dynamic Management Views and
Functions". Check it out (Books Online) and you will find a plethora of information!

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> HI Folks,
>
[quoted text clipped - 36 lines]
> ● Service Statistics
> ● Service Wait Class Stats

Reply to this Message

Kumar - 26 Mar 2008 22:33 GMT

Thanks Tibor. I will look into those .

> You can't expect a report to look the same way, since Oracle isn't the same thing as SQL Server. But
> you can get to similar type of information (in SQL Server 2005) using "Dynamic Management Views and
[quoted text clipped - 40 lines]
> > ● Service Statistics
> > ● Service Wait Class Stats

Reply to this Message

Ben Nevarez - 27 Mar 2008 01:19 GMT

And by the way, keep in mind that these DMVs usually do not show historical
information, they show the current system information or data accumulated
since the instance started. So if you want historical information you may
need to create some scheduled jobs to store this information on a database.

Great changes on this area will be available in SQL Server 2008.

Hope this helps,

Ben Nevarez

> Thanks Tibor. I will look into those .
>
[quoted text clipped - 42 lines]
> > > ● Service Statistics
> > > ● Service Wait Class Stats

Reply to this Message