SQL Server Performance  Problem with sql 2005  Discussion in
'SQL Server 2005 General DBA Questions' started by vph, Jun 10,
2008.    1. vph New Member      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     - 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   2.
techbabu303 New Member      can you run the following query and
post the results so that we understand your SQL settings better
USE master     EX