Memory usage per database

• tyang

  SSCrazy

  Points: 2231

  More actions

  October 30, 2003 at 1:05 pm

  #107186

  How to write the Stored Procedure to get the memory usage per database.

  Is there a tool to monitor the memory or CPU usage per database?

• November 3, 2003 at 8:00 am

  This was removed by the editor as SPAM

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  November 5, 2003 at 4:53 pm

  #481003

  you cannot see the memory and the cpu usage per database.

  it's only per server (or per instance)

  check the master..sysperfinfo table to see if there is something useful for you.

  Or there is a tricky way to see the cumulated cpu and memory usage from the sysprocesses table.

  To check the top 20 objects in the memory cache run the dbcc memusage command

  Or you can run the profiler and check for the CPU and DatabaseId columns

  Bye

  Gabor

  
  
  Bye
  Gabor