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.
| Author |
Topic |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2014-01-19 : 11:08:08
|
| good morningneed your helpin order to check out our database health in sql servers log, i found every second sql server registers this message as follow:Login succeeded for user 'TRAFICO\produccion'. Connection made using Windows authentication. [CLIENT: 192.168.2.31]Because every second that sql server registers this message to the logs, it's quite difficult to find a real message alarm.so ive got 2 questions:1. is there any way to get rid of this message2. if sql server logs is getting larger enough for this message it could impact sql server performance ?2.1 if so is there any way to debug these sqlserver logs ?Thanks in advanced |
|
|
nagino
Yak Posting Veteran
75 Posts |
Posted - 2014-01-20 : 02:43:46
|
| Turn off the Audit Setting of the SQL Server Properties.You may be need to restart the SQL Server to take affect.See alsohttp://technet.microsoft.com/en-us/library/ms175850(v=sql.100).aspx-------------------------------------From JapanSorry, my English ability is limited. |
 |
|
|
|
|
|
sql server logs message getting larger