SQL Server Performance

RamDisk and tempdb

Discussion in 'Performance Tuning for DBAs' started by bj007, Oct 20, 2005.

  1. bj007 New Member

    Hello,

    Is anyone using RamDisk for SQL Server and its tempdb ? Will SQL server work fine / supported with ramdisk.

    I am thinking of this as an option, for our reporting db solution. thanks much for your help.

    bj
  2. FrankKalis Moderator

    AFAIK does MS think, that tempdb and access to tempdb is optimized enough that they dropped this tempdb in RAM feature which was in SQL Server 6.5. I've never heard of this tool you mention. Can you share a link?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  3. satya Moderator

    I think using SQL server with RAMDISK is not supported, we have had similar issues previously and MS support declined to offer any information.

    It is true that where tempdb access limits server performance, a RAM disk provides the highest-performing storage medium available. Because the tempdb file's contents are truly of a temporary nature, it is an ideal candidate for a RAM disk. If the file is not present when SQL Server starts, SQL Server creates the file. It is not necessary to save its contents at system shutdown.

    I think probably check with the vendor in this case for any counters.

    BTW how big is the database and how frequently the results are queried from the database?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. bj007 New Member

    http://superspeed.com/servers/ramdisk.php
    http://superspeed.com/servers/ms-sql-performance.php#1

    DB is around 16GB. We have HP ProLiant DL380 G3. 5 drives plus 1 online/hot spare, 6gb ram,dual 2.8ghz, one channel.
    We use BI tool for reporting. Limited control over the sql being generated by it.
    Some of the monthly volume reports runs for 5 minutes. Does lots of grouping / sorting.

    while running perfmon, we hit 100% on physical disk read /sec most of the time, while processor and memory is < 5%. Thinking of testing this out in our lab with ramdisk for tempdb.

    The db is tuned for app(oltp), with enough indexes, and no complaints. only reporting suc..! Most of the daily reports are ok though. BTW, we have a reporting db in a seperate server, with daily refreshes from prod. BI can go against prod or rep db.
  5. satya Moderator

    In this case you may need proper RAID disks, rather than using RAMDISK which is not sure whether it is supported or not.



    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page