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

    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
  2. techbabu303 New Member

    can you run the following query and post the results so that we understand your SQL settings better
    USE master
    EXEC sp_configure 'show advanced option', '1'
    RECONFIGURE
    EXEC sp_configure
    Cheers
    Sat

Share This Page