How do i turn off polling??

Question

How do i turn off polling??

MissPukeyCow

Ten Centuries

Points: 1146
More actions
July 21, 2006 at 2:24 pm

#115931

boys and girls -
I have SQL 2005 Management Studio installed (version 9.0.2047] and from this I have registered various databases. The servers that host the registered databases are showing frequent (~ every minute or more) entries in the Eventvwr | Security files. How do I turn off the polling [interval]?
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/4ffbbefa-77fb-442e-a77c-cb8c6cab9f3c.htm doesn’t help since when I right click on SQL Server Agent, there is no Multi Server Administration option.
Muchos Gracias in advance!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 1

I don't think the ref you mention has anything to do with what you're asking. My guess would be that you can only disable this by unregistering the servers. I guess there's probably a registry setting somewhere - what I don't understand is why you see this as a problem

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 2

C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\en\Microsoft.SqlServer.Smo.xml

This config file contains settings for the target servers (multi-server administration) if you are asking about enlisted servers. You have to search this doc for the keyword Poll and read entries where do they point. When you finish, tell us where exactly the poll interwal is changed. Registered servers poll in 2000 was I think under Tools->Options for SQL Server service.

Regards,Yelena Varsha

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 3

Hmmm .. should we be messing with the xml files do you think? I did have a quick look but couldn't see anything that seemed to match. I do think thta a lot of useful stuff seems much more "hidden" in sql 2005, maybe this is "dumbing down" the product?

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

MissPukeyCow Ten Centuries Points: 1146 More actions · Answer 4

Thank you all for your help. The networking team in charge of the servers that host the registered [database] servers complain that their security log files are being clogged up by too frequent security logon/logoff entries by SQL Server 2005 [pooling?]. If the pooling can be turned off in SQL 2000 I was hoping this is also possible in 2005 (without having to unregister the databases [defeats the purpose of registering them in the first place) so as it stands now it does seem to have been removed from the UI.

By the way, I’m all into editing the Microsoft.SqlServer.Smo.xml file since this is my local machine but I couldn’t find exactly where I could set values for this.