Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
san.karkala
Starting Member
5 Posts |
 Posted - 2008-05-14 : 07:11:16
|
| Hi,Is any knows what will be the possible hardware requaired for the sql2005server which support 1200 concurrent connection--Santhosh |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-14 : 07:27:41
|
Anything that have a LOT of memory since connections are stored in memory.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
san.karkala
Starting Member
5 Posts |
Posted - 2008-05-14 : 08:07:43
|
pls let wht exactly memmory required .....is there PCO avilablequote:
Originally posted by san.karkala
Hi,Is any knows what will be the possible hardware requaired for the sql2005server which support 1200 concurrent connection--Santhosh
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-14 : 09:37:31
|
| Possibly Enterprise Edition(OP) and SQL server 2005 Enterprise Edition |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-14 : 23:07:17
|
| >> pls let wht exactly memmory required It also depends on db size, transaction rate and other factors. You can use server vendor's server sizer tool to get server spec. |
|
|
|
san.karkala
Starting Member
5 Posts |
Posted - 2008-05-15 : 00:52:52
|
Thx for all commentsIn my enviornment DB size is every small 5GB and growth of the db is every low and i clean the data once in a month. My only concern is concurrent connection and I want to know server capacity will come in to picture in case of DB is every small(5GB) But concurrent connection more say 1200 to 1500 and i want know wht kind of hardware sutable environment quote:
Originally posted by san.karkala
Hi,Is any knows what will be the possible hardware requaired for the sql2005server which support 1200 concurrent connection--Santhosh
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 22:11:52
|
| What kind of process to the db? You may need very fast disk storage and enough cpu power, do everything you can to reduce blocking. |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2008-05-16 : 20:27:33
|
| Are you talking concurrent connections directly to SQL Server or are these web clients connecting through an application running on a Web Server? Hopefully the later, and Im sure most web servers can manage 1200 requests with a much smaller connection pool. |
|
|
|
|
|
|
hardware requairment for 1200 concurrent connetion