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 |
|
marshalh
Starting Member
1 Post |
 Posted - 2009-02-09 : 20:29:29
|
| Hi All,I'm hoping someone can help.We are deploying a new CMS. We have aDell 1950 (dual Quads)SQL 2005MS Server 2003We are using ODBC and I was wondering how well a single DSN will cope with 600 sessions (max) through the one machine? Do I imagine it as a single pipe to communicate with SQL or does it multithread natively? How well would a cluster setup work for this senario? - Unfortunately being a non-profit we have little to spend so this may not be the best economical option, but technical advice would be appritiated.The .Net app we are running is quite intense. I've been searching for a bit on how well an DSN can handle large sums of connections, could anyone point me in the correct direction or have I got it all wrong?Thanks in advanceHeath |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-02-10 : 16:02:57
|
| When you say "max" I assume you mean concurrent. 1)Make sure you are using connection pooling.2)Ensure you manage your connections via the app - open/close3)Optimise the db for your app - efficient code Saying all that , I would consider DSN-Less connection mode , which I've found to be far more effectiveJack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
|
|
|
ODBC and SQL