Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Thursday, September 29, 2016 1:03 AM
Points: 321, Visits: 296
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, December 8, 2016 12:33 PM
Points: 33, Visits: 253
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