rsorrentino (5/2/2013)
I have SQL server 2008 running on a Dell Server with 8 processors and 24 Gb RAM. Every few weeks the third party applications receives an SQL timeout issues which freezes other users. I then have to restart the server to bring it back on line. I have been running PerfMon and notice that my batch requests/sec were on average less than 10. My database is only 160 Mg and at most 25-30 user connections. Processor usage is minimal. Page life expetancy is over 300. Page splits are at time double the batch request/sec. Other performance parameters seem ok. Network connection readings are good. I set the memory max of 20 Gb and concurrent connections to 100.Why would the system timeout? Could this be an issue regarding the programmin?
Why do you need to configure concurrent connection setting to 100. ??
By default it will be 0 and better to leave as it is as SQL server will allow up to 32000 and more connections.