Software to monitor DB usage

• Carl Rimmer

  SSCarpal Tunnel

  Points: 4068

  More actions

  October 5, 2005 at 3:38 am

  #95367

  Does anybody know of a piece of software that can monitor the amount of the RAM and CPU that each database on SQL Server is using?

  I have perfmon logs currently running but these figures are based on RAM and CPU usage by SQL Server itself and doesn't break these figures down by database.

  Any help would be appreciated.

   

  Regards

   

  Carl

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  October 5, 2005 at 5:45 am

  #595095

  IDERA Diagnostic SQL Manager is a good tool

  http://www.idera.com/Products/SQLdm/

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Jason Hall

  Hall of Fame

  Points: 3906

  More actions

  October 5, 2005 at 11:47 am

  #595212

  Quest Central for SQL Server from Quest Software has a component called Performance Analysis that does exactly this.