SQL Server 2005 System Report

25 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • RonitReno
    Thanx for the help MrDenny.
    25 pointsBadges:
    report
  • SQLGuy99
    There's a really good one available here: http://www.sqlservercentral.com/scripts/Administration/70243/
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following