March 27, 2006 at 6:30 am
We had a very puzzled proble, not sure anyone had the same. Our SQL server host Internet based application. The application code on the App/Web server is .Net using ADO and connection pooling with max. of 400 connections each web server (Web server is IIS 6.0). We load balanced across 3 Web servers. We noticed that when the connection is above 300 conenction from he URL, the performance degradation start happening and throwing SQL server un-reachable or timed-out error on the Web server while new connections still seems come thru. I know this is not a SQL problem, but you know when they see 'SQL server unreachable', DBA has to explain it.
Anyone has any clue ehat's the possible cause ? We already set presistence conenction to true on the ADO.
March 28, 2006 at 11:55 am
You probably need to look at your web server logs for more detailed diagnostics.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply