I need to see memory usage, how much processor time was taken to run a job. I am using SQL server 2005. Thank you.
asked May 06 '10 at 04:44 PM
To see which memory is used, type in the DMV sys.dm_os_performance_counters.
> 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.
answered May 06 '10 at 04:46 PM