SQL Server Performance

TempDB Configuration

Discussion in 'SQL Server 2008 General DBA Questions' started by Joben, Feb 5, 2011.

  1. Joben New Member

    Hi,
    Can somebody please let me know that how we can have SQL to select the drive that we want when SQL server starts.
    Thank you for your help!!
  2. Luis Martin Moderator

    Usually the idea is to have SQL system databases and programs in one physical drive, and user databases in others.
    Of course its depends on how many physical disk your server have, RAID, etc.
  3. ghemant Moderator

    I don't think it is possible to force SQL Server to select specific drive when it start, but as Luis said you can configure your server the way it performs well, by having separate and dedicated hardware array for system databases, tempdb, user databases and log files.
    I would recommend two articles http://blogs.msdn.com/b/sqlserverstorageengine/archive/2009/01/04/managing-tempdb-in-sql-server-tempdb-configuration.aspx and http://www.mssqltips.com/tip.asp?tip=1432
    Out of curiosity, are you facing any issues?
  4. satya Moderator

    Your subject line referes to TEMPDB and question related to selecting a drive, which is creating confusion. It will be ideal if you can be specific what you want to accomplish.

Share This Page