Activity monitor

• premkuttan

  SSCommitted

  Points: 1934

  More actions

  June 29, 2010 at 8:08 am

  #140889

  my cpu usage varies from 50 to 75%

  and i have 4 GB of RAM out of which 1.25 GB is used by sql server

  if i click on activity monitor it gives timeout expired issue

  can any one help me on this and the performance of ssms is also slow

• Slyfin

  SSC Enthusiast

  Points: 181

  More actions

  June 29, 2010 at 3:17 pm

  #1186731

  Running sp_who2 will show a slice of the activity monitor data as well.

  Sorry I have to ask but have you taken a look at your SQL Server Logs? (Windows Event viewer App-Log) if that's failing.