timeout and user connections | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

timeout and user connections

Hi!
I wanna know should i do to have less user connections to my sqlserver. The main reason is performance, i guess it’s related to the timeout, i think the time is very high. I think the number of user connections is very high specially because the number of connections to my web server is much more less, for example in my web server i have 100 user connections but in the sql server the number is over 800. What should i do?
Do you have any other tip to boost the performance? Thank you
Hi,
Have u installed latest fixes i.e. service packs and mdac at nodes and at server.
it depends upon your application coding also… if you close / open very often or u may open connection once when logging in and then close the connection at the time application exits… it depends the other issue is Network Performance also..if you have installed SQL SP (lattest sp4 released) it will patch buffer / cache ratio problem. please follow the guidelines specified :
FOR SQL/ASP :http://www.sql-server-performance.com/asp_sql_server.asp FOR SQL/VB :http://www.sql-server-performance.com/visual_basic_performance.asp it will help you.
thanx hsGoswami
[email protected]
Make sure you’re closing the connections once the transaction is finished by that particular connection from application side. This way you can reduce pileup of connections at server end. A comprehensive guidehttp://vyaskn.tripod.com/watch_your_timeouts.htm to watch the timeouts. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>