InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 07:32:11 GMT20http://www.sqlservercentral.com/Forums/Topic1335748-391-1.aspxShouldn'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.Wed, 14 Nov 2012 12:57:27 GMTBobby Gloverhttp://www.sqlservercentral.com/Forums/Topic1335748-391-1.aspxIt'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.Wed, 14 Nov 2012 09:13:03 GMTPatti Johnsonhttp://www.sqlservercentral.com/Forums/Topic1335748-391-1.aspxIf you open it on your PC it is quite slow, yes. If you open it on the live server it is pretty quick.Wed, 14 Nov 2012 09:02:57 GMTMarkushttp://www.sqlservercentral.com/Forums/Topic1335748-391-1.aspxthanks buddy! :-)Tue, 13 Nov 2012 07:58:13 GMTPatti Johnsonhttp://www.sqlservercentral.com/Forums/Topic1335748-391-1.aspx[quote][b]Patti Johnson (11/13/2012)[/b][hr]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.[/quote]THis is a good starting block on DMV useage for performance metrics[url]http://www.bradmcgehee.com/2010/07/free-sql-server-dmv-starter-pack/[/url]Tue, 13 Nov 2012 07:40:44 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1335748-391-1.aspxOkay. 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.Tue, 13 Nov 2012 07:34:59 GMTPatti Johnsonhttp://www.sqlservercentral.com/Forums/Topic1335748-391-1.aspxPersonnaly 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.Mon, 12 Nov 2012 13:36:22 GMTBobby Gloverhttp://www.sqlservercentral.com/Forums/Topic1335748-391-1.aspxDid anyone find out the answer to this? It is really slow and not good when you need to find out information quickly.Mon, 12 Nov 2012 09:03:05 GMTPatti Johnsonhttp://www.sqlservercentral.com/Forums/Topic1335748-391-1.aspxGood question. The old version returned data straight awayWed, 10 Oct 2012 18:54:15 GMTJohn Hunter-389450http://www.sqlservercentral.com/Forums/Topic1335748-391-1.aspxHi,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? VeraThu, 26 Jul 2012 06:18:40 GMTVera-428803