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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-02-09 : 08:08:49
|
| Hi I have heard that SQL Server can support upto 10,000 users, What if my application , connects to the sql & does not do antything then , why does the SQL server slow down with just 700 users.I mean just the connection is established & NOTHING further is done.Thanks |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-02-09 : 08:20:06
|
| I'd expect it may have something to do with the hardware. Something might be able to support 10000 connections, but other things may stuggle with the resourcing.-------Moo. :) |
 |
|
|
penumatsa
Constraint Violating Yak Guru
289 Posts |
Posted - 2006-02-09 : 08:20:52
|
| Can you be more specific when you say that SQL Server slows down with just 700 users. Also i dont know that SQL Server can support only or upto 10,000 users.suresh penumatsa |
|
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-02-09 : 08:48:52
|
| Lets say that I have a Vb application that makes a ADO connection to the SQL Server, then there is some data that pops up on a text box from the DB , This box contains a lot of info which is read by the user, now in this case there is not other operation performed on the SQL Server .Such 700 users are logged on to the server & the server slows down , why when it can support 10000 users, here now we dont even have any I/O or processing going on. |
|
|
|
penumatsa
Constraint Violating Yak Guru
289 Posts |
Posted - 2006-02-09 : 08:57:33
|
| How are you getting data data from the database? Are you using an adhoc sql query or are you using a stored proc to get the data. It all depends on how the query is written.suresh penumatsa |
|
|
|
ks2000
Starting Member
1 Post |
Posted - 2006-02-09 : 09:04:42
|
| Can you post some of your queries which you are using in your application??? |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-02-09 : 11:06:30
|
| What does your application do ? |
|
|
|
|
|
|
Connections to SQL