sql server connect: i asked this question yesturday and got an answer from John Bell (thanks by the way) and i want to clarify what i need
is there any document that say for each hardware the number of connections the sql can tolerate and still working fine
i have 2 processores (1.4 ghz) computer with 2 gb ram and still after 100 connections the sql getting slower with loknings and easc query take it time to run
if i upgrade to 4 processores will i see a change

Obviously the more hardware you have the more it will ultimately be able to
handle assuming everything else is well tuned. But the size of thhardware
has really little to do with how many users it can safely handle. What you
are doing and how well you are doing it will determine how the hardware
handles the load. 100 users on a 2 processor box should not be an issue in
general. Locking is much more a factor of a well tuned system than hardware
by far. If your getting slowness due to locking you probably don't have
proper indexes and poorly written queries. Here are some links that may
help:


http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring


--
Andrew J. Kelly SQL MVP


[quoted text, click to view]
connections the sql getting slower with loknings and easc query take it time
to run.
[quoted text, click to view]