Post reply

SQL DB connections

  • May 4, 2011 at 8:50 pm

    #237657

    We are using SQL Server 2008.We want to enable both successful logins and attempted connections to Database. I have a question on DB connection.

    Does the application open connections to the db

    primarily at startup? Or does it open/close connections regularly as

    part of normal behavior. just want to know whether excessive log files

    could be generated.

    Thanks for you help.

  • May 4, 2011 at 9:33 pm

    #1320184

    Usually it's the latter, but opening connections doesn't affect the transaction log. If you have login auditing running, it will enter data in the SQL Server Error log and potentially the Windows Event log, but it usually isn't an amount to worry about.

Viewing 2 posts - 1 through 1 (of 1 total)

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