Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL Server 2008 R2 Activity Monitor
Add to briefcase
13 posts, Page 1 of 2
12»»

SQL Server 2008 R2 Activity Monitor Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Harold Buckner
Posted Tuesday, July 27, 2010 2:10 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, January 25, 2013 11:27 AM
Points: 307, Visits: 383
Have other people experience how slow the activity monitor is to populate. At times it is so slow I give up at use SP_who2 but would rather use the activity monitor. Have other got fustraded with the slowness? Just wondering if it is just me or that the way it is now.

Thanks
Post #959683
hemakumar_p
Posted Tuesday, July 27, 2010 5:25 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 15, 2011 10:34 AM
Points: 37, Visits: 173
It works fine for me and Loads in a fraction of seconds.

Regards

Regards
Hema.,
Post #959784
Ratheesh.K.Nair
Posted Thursday, July 29, 2010 7:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:21 AM
Points: 2,415, Visits: 3,370
Is that the same when u try to expand databasess in SSMS??
Post #960716
Harold Buckner
Posted Thursday, July 29, 2010 8:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, January 25, 2013 11:27 AM
Points: 307, Visits: 383
No everything else in SSMS works fine. But when I click on the activity monitor it just takes forever for the details to come back. It is slow at times with one instance with 1 or two user databses as it is wit a instance with 15 user databases. The data is just slow getting back to me.
Post #960736
Richard Gibbins
Posted Monday, July 18, 2011 5:01 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: 2 days ago @ 1:07 PM
Points: 145, Visits: 163
Yes! It has been this way since we installed. It refreshes quickly enough; it's just the initial data load that's slow. We run a cluster and I was wondering whether that was a factor.
Post #1143811
Jannie-186227
Posted Wednesday, July 20, 2011 9:49 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 9:12 PM
Points: 162, Visits: 107
Hi


Afaik I know the MGMT studio is sluggish on x64 as it's 32 bit.
This might have the same issue for your machine.

Also if you are on the server it will use shared memory.

Try see if there is a difference from a remote machine which will most likely use tcip.

Cheers
Jannie
Post #1145590
opc.three
Posted Thursday, July 21, 2011 9:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:27 PM
Points: 6,695, Visits: 11,711
Jannie-186227 (7/20/2011)
Hi

Afaik I know the MGMT studio is sluggish on x64 as it's 32 bit.
This might have the same issue for your machine.

That's a good lead. I am curious about these details. Do you have an article that references these issues, or maybe how to mitigate them?

Also if you are on the server it will use shared memory.

I am able to force the use of TCP/IP on my local server by providing the IP address or the specific Port number when connecting.

IP_ADDRESS\INSTANCE_NAME = TCP
IP_ADDRESS,PORT_NUMBER = TCP

.\INSTANCE_NAME = Shared Memory
.,PORT_NUMBER = TCP

SERVER_NAME\INSTANCE_NAME = Shared Memory
SERVER_NAME,PORT_NUMBER = TCP

(local)\INSTANCE = Shared Memory
(local),PORT_NUMBER = TCP

Note: my client protocol priority was not changed from the default order -> Shared Memory first, TCP/IP second, Named Pipes third

You can check your transport with this query after connecting:

SELECT  net_transport,
        endpoint_id,
        connect_time,
        client_net_address
FROM    sys.dm_exec_connections
WHERE   session_id = @@spid ;

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1145993
Richard Gibbins
Posted Thursday, July 21, 2011 9:30 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: 2 days ago @ 1:07 PM
Points: 145, Visits: 163
I can't say I have noticed any sluggish behaviour; SSMS behaves just fine for the most part, it's just the initial load of data by the activity monitor that takes "forever" -- 3 min 45 sec just now.

Unfortunately, I haven't noticed any difference between my current 64-bit and previous 32-bit desktop. Nor does it seem to make any difference whether I am logged into the server or my desktop. Come to think of it, as I always remote desktop into the server, that last may not be true.

Richard
Post #1146030
Markus
Posted Friday, July 22, 2011 6:22 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:37 AM
Points: 1,046, Visits: 2,208
It loads quite slow for me as well, kind of frustrating I agree.


Post #1146581
Harold Buckner
Posted Friday, July 22, 2011 6:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, January 25, 2013 11:27 AM
Points: 307, Visits: 383
Yep the activity monitor load is slow as all get out if you server is the slightest busy. It does not matter if it is a cluster or stand alone, it is slow.

If you having a block or other issue going on and want to see an overall real fast, better use something like sp_who2 for faster response.
Post #1146591
« Prev Topic | Next Topic »

Add to briefcase
13 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.