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 loads slow Expand / Collapse
Author
Message
Posted Thursday, July 26, 2012 6:18 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, October 13, 2014 12:45 AM
Points: 929, Visits: 376
Hi,

I have a very general question. Does anyone know why the activity monitor in SSMS 2008 and/or 2008R2 in a clustered environment loads so slow when you start it with the default settings. The default is that it refreshes every 10 seconds but the first time it seems to takes minutes.
Is there anything we can do about?

Vera

Post #1335748
Posted Wednesday, October 10, 2012 6:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 10:00 PM
Points: 5, Visits: 61
Good question. The old version returned data straight away
Post #1371170
Posted Monday, November 12, 2012 9:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 10:08 AM
Points: 229, Visits: 805
Did anyone find out the answer to this? It is really slow and not good when you need to find out information quickly.
Post #1383728
Posted Monday, November 12, 2012 1:36 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
Personnaly I hate AM in SQL2008. It is generally slow and painful to use. I rarely use it these days and do most thing via script. Querying DMVs can be more usefull.
Post #1383857
Posted Tuesday, November 13, 2012 7:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 10:08 AM
Points: 229, Visits: 805
Okay. Thanks for replying. Do you have any DMV scripts that you use that you wouldn't mind sharing with me? That would be most appreciated.
Post #1384097
Posted Tuesday, November 13, 2012 7:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:42 AM
Points: 5,216, Visits: 5,111
Patti Johnson (11/13/2012)
Okay. Thanks for replying. Do you have any DMV scripts that you use that you wouldn't mind sharing with me? That would be most appreciated.


THis is a good starting block on DMV useage for performance metrics
http://www.bradmcgehee.com/2010/07/free-sql-server-dmv-starter-pack/




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1384100
Posted Tuesday, November 13, 2012 7:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 10:08 AM
Points: 229, Visits: 805
thanks buddy!
Post #1384114
Posted Wednesday, November 14, 2012 9:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:02 PM
Points: 1,289, Visits: 2,842
If you open it on your PC it is quite slow, yes. If you open it on the live server it is pretty quick.


Post #1384702
Posted Wednesday, November 14, 2012 9:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 10:08 AM
Points: 229, Visits: 805
It's very slow for me when I login remotely to the server and start activity monitor. It takes forever to come up and display the info.
Post #1384711
Posted Wednesday, November 14, 2012 12:57 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
Shouldn't really be using SSMS on the Live server. It takes memory away from the system. SSMS should always be used remotely from your PC in my books. Especially when trying to find performance issues.
Post #1384821
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse