June 10, 2008 at 7:18 pm
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
June 10, 2008 at 7:26 pm
What are you getting for an error?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply