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,
    Ud9, Jun 16, 2006
    #2

  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.



    Luis Martin, Jun 16, 2006
    #2

  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 ?



    Ud9, Jun 19, 2006
    #2

  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.
    satya, Jun 19, 2006
    #2

Share This Page