Stop Monitoring SQL Services for Registered Servers in SMSS -


Q: Is it possible to prevent SSMS from monitoring the service status of registered servers?

Description: SSMS 2008 monitors the service status of each registered server. In every minute I see every registered server to reach, so to check this situation, there are more than 100 servers in my case. This process has raised issues with our security and network departments. The network was initially identified due to the fact that due to the suspicious traffic it appeals as an unknown utility that was scanning the network for SQL Server. Security was concerned because security event logs on each server are being filled with the events of my logon.

I have looked completely for a setting but do not think that one or the other?

TIA, Brian

I finally got an answer !!

Checking the service status of registered servers is not possible to prevent SSMMS (at least I have come to know) It is possible to change the interval on which it checks.

(SQL Server 2008) HKLM \ Software \ Microsoft \ Microsoft SQL Server \ 100 \ Tool Shell | PollingInterval = 600 (Decimal)

(SQL Server 2005) HKLM Software \ Microsoft \ Microsoft SQL Server \ 90 \ Tools Shell | PollingInterval = 600 (Decimal)

With this SSMS will be automatically added to each minute instead of every few seconds.

See this for details.


Comments

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -