Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Success Audits from SQL on DB Server

Author  Topic 

wisertime
Starting Member

28 Posts

Posted - 2008-07-02 : 10:53:55
I notice when I look in event viewer under security that there are about 50 or so logon/logoff events a second for all of our DBAs that are part of the local Admin group. Obviously we aren't all logging in that many times, so I was thinking that this is something sql does. We have a job that runs every minute to determine if the server is running or not, but not this much. This familiar to anyone?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-02 : 11:06:56
Any particular question?
Go to Top of Page

wisertime
Starting Member

28 Posts

Posted - 2008-07-02 : 11:10:28
Do you think that this is something configurable in SQL (perhaps limit connections from sql to the box). You can always limit the audits but the logins are still occurring. I was just wandering if anyone has seen this happen before.

quote:
Originally posted by sodeep

Any particular question?

Go to Top of Page

wisertime
Starting Member

28 Posts

Posted - 2008-07-02 : 11:46:36
Ahh. It is polling that is configurable inside EM. Its set to check every ten seconds, which will log every ten secongs when EM is open.

quote:
Originally posted by wisertime

Do you think that this is something configurable in SQL (perhaps limit connections from sql to the box). You can always limit the audits but the logins are still occurring. I was just wandering if anyone has seen this happen before.

quote:
Originally posted by sodeep

Any particular question?



Go to Top of Page
   

- Advertisement -