That is the question: how many concurrent connections support Microsoft SQL Server 2005?
Thanks in advance,
Javier.That depends on how liquid is your check book, the baseline license is per server processor and I have seen 32 way servers running SQL Server. Hope this helps.|||That depends on your hardware and database activity. I've gotten command timeouts on our development server with just 4 threads beating on it. OTOH, at my previous job we had an Oracle server with some serious hardware behind it (12 GB RAM, 24 64 bit processors) did just fine with over 1,000 active connections. Other departments used SQL Server in fairly high stress environments successfully. (Although I've heard that 32 processor Intel boxs can be fragile.)|||
sorry for not answering directly on the question , but just needed to comment on
12 GB RAM, 24 64 bit processors
Oh my - never been close to such a monster !!!
While I have no numbers to contribute with - this whole discussion really is a reminder on the fact that open connections do cost - and for scalability applications should release their connection to the connection pool (i.e oConn.Close) ASAP
No comments:
Post a Comment