Home > IT Answers > SQL Server > SQL Server 2005 System Report
RonitReno
25 pts.
 SQL Server 2005 System Report
SQL Server 2005 administration, SQL Server 2005 Analysis Services, SQL Server 2005 Reporting Services
I need some ideas of how to create a SQL Server System Report, i.e. how much memory has been consumed, how much time was taken in a job run? Can some one provide me an example, please? Thanx.

Software/Hardware used:
SQL Server 2005
ASKED: April 22, 2010  4:40 PM
UPDATED: May 15, 2010  2:18 PM
RELATED QUESTIONS
Answer Wiki:
You can query the sys.dm_os_performance_counters DMV to see a breakdown of where the memory is being used. <pre>select * from sys.dm_os_performance_counters where object_name = 'SQLServer:Memory Manager'</pre> You can use the stored procedure sp_help_jobhistory in the msdb database to view the job history. <pre>EXEC sp_help_jobhistory @job_name='syspolicy_purge_history'</pre>
Last Wiki Answer Submitted:  April 22, 2010  6:19 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanx for the help MrDenny.

RonitReno
 25 pts.
 

There’s a really good one available here:

http://www.sqlservercentral.com/scripts/Administration/70243/

SQLGuy99
 10 pts.