July 26, 2012 at 6:18 am
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
October 10, 2012 at 6:54 pm
Good question. The old version returned data straight away
November 12, 2012 at 9:03 am
Did anyone find out the answer to this? It is really slow and not good when you need to find out information quickly.
November 12, 2012 at 1:36 pm
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.
November 13, 2012 at 7:35 am
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.
November 13, 2012 at 7:40 am
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/
November 13, 2012 at 7:58 am
thanks buddy! 🙂
November 14, 2012 at 9:02 am
If you open it on your PC it is quite slow, yes. If you open it on the live server it is pretty quick.
November 14, 2012 at 9:13 am
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.
November 14, 2012 at 12:57 pm
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.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply