SQL Server Performance Forum – Threads Archive

Metrics reports

Oracle OEM has these fancy metrics reports which we could generate for management review’s. I was wondering, Is there a similar metrics on SQL server 2005, which we could generate? If yes, could somebody please share this? Many thanks,
Cali

I’m not aware of such reports for Oracle, but if you are looking similar then Performance dashboard will be handy in SQL
http://www.sql-server-performance.com/bm_performance_dashboard_2005.asp
http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc If this is not what you are looking please be specific about such report requirement. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Thank you Satya, I shall look into this. Thanks,

Out of the sql server 2005 has more than 10-15 reports…without installing even dashboard… Right click the database/Reports/Standard… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

.. most of them will work unless you have equipped with SP2 [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

MohammedU and Satya, I have SP2 installed for SQL 2005. I was wondering, how could i install the dash-board? With my first post, What i meant to say with Oracle metrics report was: With Oracle OEM (Oracle Enterprise manager) they are pre-template reports which are handy to run and see the events. Few events are CPU usage for a X time, Tablespaces capacity report and capacity planning report. Having said that, I was wondering, with SQL Server 2005 dash-board, will i be able to get these reports? The important data what i ideally like to see is, going back in time. Say i want to pull a report on last week CPU acticity OR run a performance metrics report for the resources on the system etc. is this possible? Appreciated if you could share this. Many thanks,
Cali

In this case you have to schedule a SYSMON (PERFMON) trace to get such historic information, for performance dashboard reviewhttp://www.sql-server-performance.com/bm_performance_dashboard_2005.asp link. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Thank you Satya for the info.

]]>