May 5, 2011 at 12:20 pm
Does anyone know how to calculate the approximate maximum connections a SQL Server box can handle based on hardware?
I have a 64-bit SQL Server 2005 with 8 processors, 16GB connected to the SAN.
The middle-ware people have one BizTalk service that can eat up at least 16k connections.
At about 15,000 connections the server starts to crawl and we experience timeout issues.
I say it is a BizTalk application problem, but would like to be able to tell my boss that the current hardware is good for x number of connections.
May 5, 2011 at 12:29 pm
There really isn't a math to that. One connection doing a heavy enough query can bring any server to its knees, so how could there be?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 6, 2011 at 12:01 am
Hello William,
Please refer the following two links which might help you to justify to the management.
http://msdn.microsoft.com/en-us/library/aa175395(v=sql.80).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply