CPU Usage, IO usage and memory usage for sql server 2005

• naveen.raj

  SSC Rookie

  Points: 47

  More actions

  October 7, 2012 at 11:23 am

  #262639

  Hi,

  Which DMV can be used or is there any query which can give me an exact data about the CPU Usage, Memory usage and I/O for SQL server 2005 ( no profiler) probably since last reboot

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  October 8, 2012 at 11:57 am

  #1546864

  Exact data relative to what? Are you just looking for a total number? How do you expect to use these numbers?

  CPU and I/O stats for queries [currently in the cache] can be found here in sys.dm_exec_query_stats.

  You can use this counter from SQL to watch the memory used by SQL Server:

  SELECT *

  FROM sys.dm_os_performance_counters

  WHERE object_name = 'SQLServer:Memory Manager'

  AND counter_name = 'Total Server Memory (KB)';

  Look into Performance Monitor (perfmon) to monitor 'server memory available' if you're worried about external memory pressure.

  Chapter 4: Troubleshooting SQL Server: A Guide for the Accidental DBA By Jonathan Kehayias and Ted Krueger

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato