Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Activity monitor Expand / Collapse
Author
Message
Posted Tuesday, June 29, 2010 8:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, October 28, 2013 3:12 PM
Points: 313, Visits: 253
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
Post #944686
Posted Tuesday, June 29, 2010 3:17 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 26, 2014 8:44 AM
Points: 28, Visits: 204
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.
Post #945065
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse