x
login register about faq

As a systems administrator, how do I create a SQL Server Systems Report?

I need to see memory usage, how much processor time was taken to run a job. I am using SQL server 2005. Thank you.

more ▼

asked May 06 '10 at 04:44 PM

bming1 gravatar image

bming1 ♦♦
1.2k 73 151 310

(comments are locked)
10|600 characters needed characters left

1 answer: sort voted first

To see which memory is used, type in the DMV sys.dm_os_performance_counters.

select *

> from sys.dm_os_performance_counters

> where object_name = 'SQLServer:Memory Manager'

This should give you a detailed list.

As for run time jobs try this command using the sp_help_jobhistory. It lists the job history in the msdb database.

EXEC sp_help_jobhistory @job_name='syspolicy_purge_history'

more ▼

answered May 06 '10 at 04:46 PM

bming1 gravatar image

bming1 ♦♦
1.2k 73 151 310

(comments are locked)
10|600 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.