SQL Server 2005 Performance RRS feed

  • Question

  • Dear Friends,

    We have a software suite to manage transport companies. Usually the companies have from 5 to 20 users connected simultaneously using a MSDE instance in a Windows Server (2000 or 2003).

    Recently a great customer buy ouwn solution to use with more then 200 users simultaneously, with SQL Server 2005, and when all users are using the database the performance grow down excessively.

    Hardware Specifications:
    DELL PowerEdge 1900
    Intel QuadCore 3.6Ghz
    Cache 4MB
    16gb RAM

    OS Specification
    MS-Windows Server 2003 Enterprise

    SGBD Specification
    MS-SQL Server 2005

    How I increase the database performance? What the points that I need change or consider to grow up the database performance?


    Alonso JR.
    Autumn TI
    Monday, June 16, 2008 2:39 PM