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 12»»

SQL Server 2008 R2 Activity Monitor Expand / Collapse
Author
Message
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: Monday, August 05, 2013 9:59 AM
Points: 307, Visits: 385
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
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, November 12, 2013 3:15 PM
Points: 37, Visits: 179
It works fine for me and Loads in a fraction of seconds.

Regards


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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:50 AM
Points: 2,509, Visits: 3,649
Is that the same when u try to expand databasess in SSMS??
Post #960716
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: Monday, August 05, 2013 9:59 AM
Points: 307, Visits: 385
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
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: Wednesday, April 02, 2014 11:58 AM
Points: 145, Visits: 178
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
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: Sunday, March 23, 2014 1:38 AM
Points: 162, Visits: 116
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
Posted Thursday, July 21, 2011 9:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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
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: Wednesday, April 02, 2014 11:58 AM
Points: 145, Visits: 178
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
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: Monday, April 21, 2014 10:38 AM
Points: 1,202, Visits: 2,663
It loads quite slow for me as well, kind of frustrating I agree.


Post #1146581
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: Monday, August 05, 2013 9:59 AM
Points: 307, Visits: 385
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 12»»

Permissions Expand / Collapse