SQL Server Performance

How can I increase SQL Server2005

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Ud9, Jun 16, 2006.

  1. Ud9 New Member

    Hi friends,
    Two weeks ago, I bought new server machine and setup Windows 2003 Ent Edit. Sp1 and SQL Server 2005 Sp1. Then, I copied Sqlserver 2000 databases to new server and attached db by using T-SQL.

    My new machine conf.
    HP DL580 - 16 Gb Ram, 4xCPU
    ; 5 x 146 GB HD Raid-5 on HP MSA1000 SAN

    How can I increase SQL Server performance by using SQL SERVER Proporties/ Option.?

    Notice:

    * On this sql server2005, there are a lot of Insert, Delete, Update transactions and selects for reports.
    * Nearly 300 users logins to this server.

    Thanks now for helps,

    Ufuk,
  2. Luis Martin Moderator

    What memory setting do you have?
    The databases was compatibles with 2005?
    2005 use tempdb a lot, is a good idea to put it in faster disks.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. Ud9 New Member

    Thaks Luis,

    When I look at VM properties on C disk, I saw the our server Virtual Memory setting ;
    Initial Size = 2048,
    Maximum Size = 4092.
    on C disk.

    Sql Server 2005 was installed on C disk. (Tempdb at the local server disk that
    C:program FilesMicrosoft SQL Server 2005 Standart x64MSSQL.1MSSQLData)

    Is it enough if not what can I do ?



  4. satya Moderator

    http://support.microsoft.com/?kbid=319942

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page