SSMS equivalent of "Poll server to find state" ?

Hot Topic

VSA vs. VB.NET
not sure if this is the right place. . .
index defrag problem
Using error handling techniques in cursor routine
Update Issue
Using the Local Service Account to run SQL Server 2005
Export Wizard generates errors
Export Schema and Data
Problems adding MS access datasource in VB studios 2005 enterprise
how to get the sum of a group and not the whole column?

SQL Server

OLAP performance
change distributor ?
Persistent BI Studio Crashes
Unable to create SQL Server Mobile Subscription
attempted to divide by zero
string to int????
Search no longer working in BOL
F I L T E R HELP!!! PLEASE!!!! THIS CAN'T BE THAT HARD
Database is read-only.
Query Returning to many results

SSMS equivalent of "Poll server to find state" ?

In SQL Management Studio, is there a way to turn off polling among the registered servers

I liked this feature in SQL 2000 because it caused less network traffic, and fewer entries in the target machine's Event Viewer.

Answer this question

SSMS equivalent of "Poll server to find state" ?

  • simkinnet

    More strange behavior... SSMS polls standalone default and named instances, but not cluster default and named instances.

    I would like a way to turn off polling, either an undocumented setting in the Registry or my local-profile RegSrvr.xml file Perhaps a service to disable

    I have found I can register a server name with a ",<port>" suffix to prevent polling (eg. "ServerName,1433"), but this is kinda clumsy, and most users won't buy into it.

    Thanks for any info.  With 500+ IT users, polling can cause a lot of extra network traffic.

  • jvinsky

    Since I wasn't familiar with the results, I did the reseach using SysInternal's RegMon utility.

    SSMS is looking at the key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell" for the data "PollingInterval" containg a string value of "0" .

    Which in .reg file notation looks like:

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell]
    "PollingInterval"="0"

    After adding, SSMS must be restarted.

    Now, the odd thing is that on SSMS starts, every datasource in your Registered Servers list gets polled once for its current status, and the corresponding green arrow or red square appears beside it. This really threw me off, because in SQL 2000 you never see the initial status.

    However, after this point, the status/icon never changes.

    Now, I also attempted removing the Registry key, but I also found a copy in the HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell area. Removing both entries, though, had no effect on removing this "after-effect" polling.

    My research ends here because I don't have a need to turn it back on.

  • W-i-s-e_G-u-y

    I've tried this with 0 as well as varying amounts, on both my desktop client and on our servers, and Management Studio continues polling every 2 to 3 minutes. I've got 220+ servers registered and we have 200+ developers that are going to start getting the client installed and servers registered soon. So I was wondering if anyone was still looking into this. I'd like to avoid all this traffic and logging if at all possible.

  • de Lira

    Still unknowledged, unanswered, and unresolved.

    Check out the dubiously obtuse reply from Mr Buck Woody

    http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=292598

    Maybe they're to busy implementing DRM checking in the SQL platform.


  • Luka79

    Still an issue, SP1 and registry hack had no effect.

    It would be nice it all developers would kindly remember that; their software is running on their customer's equipment, and some effort should be made not to whimsically waste resources, and if its whimsical nature is debatable, then at the very least give the customer the ability to make that decision for themselves.

  • appferreira

    There isn't any UI for this in SP1. 

    After you have installed SP1, you can adjust the polling interval in Management Studio by changing the registry value in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell\PollingInterval.  Setting the value to 0 means "never poll".

    Thanks,
    Steve



  • H.T.Chien

    We've installed SP1, made the registry changes and rebooted. The polling behavior hasn't changed in the least.

    If anyone has any other suggestions, it would be appreciated.


  • KoryS

    Thank you for sharing this information.

    However, I couldn't find this key/data/value in the Registry, even though I've installed SP1. I've tried adding various combinations of values and re-running SSMS.

    Could you export to a .reg file and add the contents to this thread I would like to duplicate the results. Thanks.

  • FirePhoenix

    MS is saying this feature is available in SP1... http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackid=bd1d54bd-560a-4e67-a665-295c7d0612d7

    However, amidst the problems I've having with the SP1-CTP (another thread), I didn't see this feature in the upgraded Management Studio.

  • radpin

    I have the same question, JFoushee. Event logs are filling quickly and I'd like a way to turn off the polling like we could in Enterprise Manager. Any answers

  • crabman27

    Update on this would be nice.   Kinda don't like filling up event logs with uncessary events :(
  • SSMS equivalent of "Poll server to find state" ?
Answer this question