Logging info to error log makes server hang

• Helen-84411

  Hall of Fame

  Points: 3320

  More actions

  September 22, 2005 at 7:40 am

  #110779

  Hi,

  I have a production box which is running 100 % CPU. If I look at the error log and event log it gives the following message 10 times for every 1 sec. I think this is causing the server to hang. Please tell me if there are any commands that writes login info to error log and how to get away with this. I have tried restarting SQL server service but no joy.

  Login succeeded for user 'KKKKK'. Connection: Non-Trusted.

  thanks in advance

  

   

  
  Helen
  --------------------------------
  Are you a born again. He is Jehova Jirah unto me

• peterhe

  SSChampion

  Points: 11469

  More actions

  September 23, 2005 at 7:00 am

  #592576

  You must have enabled security audit.

  Go to server property-->Security, see what security audit level you are. Change to None or Failure based on your reuqirement.