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.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Problem with sql 2005

Author  Topic  vivian Starting Member 1 Post Posted - 2008-06-10 : 21:12:50 Hello I am tuning my sql server production system and found that I cannot have more than 620 connections running concurrently sql queries. Particularly I used the tool Ostress (from Microsoft) with the following query: select count from table1, and 600 threads. Actually I run 6 times Ostress every one with 100 connections COnfguration - Sql server enterprise edition for 32 bits - 32 processors - 64 Gb of RAM - AWE set to 1 - RAID 6 - table1 tiene 20,000 registros - 1 Gb network cardIs there any hard limit in Sql server architecture ? Is there any limit in the number of transactions per second ? Is there any specific option that needs to be setup ?Thanks for your help in advanced