SSMS: Activity Monitor does not show %Processor Time for servers registered by FQDN. - by Robert_Mason

Status : 

 


5
0
Sign in
to vote
ID 426097 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 3/23/2009 2:09:28 PM
Access Restriction Public

Description

Activity monitor does not show % Processor Time if the SQL Server is registered using a Fully Qualified Domain Name.  If I add the server's NetBIOS name to my hosts file and register using just the the NetBIOS name, activity monitor will show % Processor Time for the same server.
Sign in to post a comment.
Posted by Peter Wretmo on 5/18/2014 at 11:56 PM
Adding the NETBIOS name to my hosts file does not solve the issue, however there is a difference in that it takes about 20 seconds before the CPU graph is greyed out. Otherwise it is greyed out immediately.
Posted by Peter Wretmo on 5/18/2014 at 11:54 PM
I have this issue when connecting from SSMS 2012 on Win2012 to a clustered SQL2008R2 instance on Win2008R2 in another domain. Firewall open for 135 and DCOM configured ports 5000-5015 to the cluster group's network name.
Posted by Robert_Mason on 5/13/2011 at 11:44 AM
Unable to recreate in SQL Server 2008 R2 SP1. This issue appears to be resolved.
Posted by Microsoft on 5/13/2011 at 7:46 AM
Hi,

We took a look at this bug along with several others recently. We are not able to reproduce this bug internally. Please try this in the next available public release of SQL 11, and if you are still facing any issue, do let us know. Please provide your environment details as it may be in an issue with particular environment.

Thanks for writing in to Microsoft.

Regards,
Alok
Posted by Microsoft on 3/26/2009 at 8:07 AM
Hi MMason,
    Thank you for your feedback regarding AM's failure to retrieve perf counters when using a fully qualified name for the server connection. We will look into this for a future release of SQL Server. For now, you'll need to go with the workaround.
Thany you,
Bill Ramos