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: Tuesday, May 19, 2015 9:08 AM
Points: 317, Visits: 284
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: Tuesday, June 30, 2015 12:17 PM
Points: 31, Visits: 226
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