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 |
sponguru_dba
Yak Posting Veteran
93 Posts |
Posted - 2006-12-04 : 02:37:18
|
hiHow many Concurant transaction SQL SERVER will support at a timeSreenivasaRaoBangalore,INDIA |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-04 : 05:17:31
|
sql server 2000 allowes a maximum of 32,767 concurent connections.Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-04 : 05:27:24
|
Only one transaction at a time for each and one record.Peter LarssonHelsingborg, Sweden |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-12-04 : 06:40:04
|
It's a pretty silly statistic.If one of those transactions is using 97% of the system resources, you won't have too many others able to run at the same time.The real number depends on your hardware, the database size, the query optimisation, the indexes, the disk partitioning etc etc etcDamian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
|
|