excessive number of connections | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

excessive number of connections

hi, we are getting (what seems to be) an excessive amount of connections from our web servers. I think we can probably rule out MDAC because this is occurring from servers running Windows 2k3 SP1 (hence latest version of MDAC) and others not patched and running MDAC 2.8 RTM Something that seems weird (though I#%92m not sure if it isn#%92t normal behaviour??) is that there are lots (up to thousands) of “NULL” connections – connections which no longer have a command associated with them (i.e. if you click on them in EM they don#%92t show a command). These connections often have a last_batch time of hours or even longer ago Well just wondering if anyone might have any ideas

It may be some kind of hacking attack!
Ensure in the code you’re disconnecting the connection once transaction is finished.
May check with PROFIELR and see what these connections are performing. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi,<br />its most likely an issue when connection is not close from vb application, we have had this issue some time before… nothing else and from security point of view you can download this tool "Microsoft Baseline Security Analyzer v2.0 (for IT Professionals)" from microsoft itself which suggest you what and where you need to do changes aspect from security .<br /><br /><b><a href=’http://www.microsoft.com/downloads/Popular.aspx?displaylang=en’ target=’_blank’ title=’http://www.microsoft.com/downloads/Popular.aspx?displaylang=en'<a target="_blank" href=http://www.microsoft.com/downloads/Popular.aspx?displaylang=en>http://www.microsoft.com/downloads/Popular.aspx?displaylang=en</a></a></b><br /><br /><br />HTH<br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][:I][<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />