Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How can I audit SQL connections to the database from

  • Windows credential
  • Sql Users

Is there some built-in feature where I can determine number of:

  • all connection
  • active connection
  • unclosed connection
  • current status
  • historical prevue

I hope that I'm going right way. I have application that takes all RAM to the SQL Engine and transaction logs raising to the unbelievable size on HDD durring one-two days.

share|improve this question

1 Answer 1

up vote 4 down vote accepted

No, you're not going about this in the right way.

I have application that be able to take all RAM to the SQL Engine

SQL Server will use as much as it needs unless you limit it. Read Brent Ozar's A Sysadmin’s Guide to Microsoft SQL Server Memory.

transaction logs raising to the unbelievable size on HDD during one-two days

9 times out of 10 this is due to the database being in FULL recovery and no log backups being taken. See Paul Randall's article Running Out of Transaction Log Space.

If you want to monitor the items you listed:

share|improve this answer
    
+1 1) engine has already limit in 2.5Gb from available 8Gb, 2) there are longer time three databases on one instance, that have got linked own aplications and with sometime too hard transactions, etc...,but with clear life_cycle, without taking RAM and raising Transaction Log to the extreme amount, but in the last week I added there another 4th. aplication that ... I don't know what, where I must to start, I look at connections, live and runned queries, then live Objects, everything (my view) talking about unclosed connections with unclosed Objects ... –  mKorbel Dec 8 '11 at 13:23
    
Perfmon counter SQLServer:General Statistics:User connections. If this is climbing continuously, you have open connections that are not being closed. –  Mark Storey-Smith Dec 8 '11 at 13:29
    
thanks for edit, in this moment you're gave me more informations as I able ..:-), –  mKorbel Dec 8 '11 at 13:45
    
+1 Great answer! –  RMacy Dec 8 '11 at 17:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.