|
I need to see memory usage, how much processor time was taken to run a job. I am using SQL server 2005. Thank you.
(comments are locked)
|
|
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.
(comments are locked)
|
