RAM Disk and SQL server tempdb

Started by lohmag112

lohmag112

RAM Disk and SQL server tempdb   23 November 2016, 00:42

After reboot SQL Server service won't start automatically if tempdb located on the RAM disk. I think it is because it starts before the disk is ready. Disk is configured to start at boot time. Are there are any solutions?
SoftPerfect Support forum - Andrew avatar image

Re: RAM Disk and SQL server tempdb   23 November 2016, 09:13

Does it produce any error messages in the Windows event log?

Perhaps changing the MSSQL Service startup type from Automatic to Automatic (Delayed Start) in Services.msc can do the trick. This would cause the server to start a bit later after all automatic services have started, at which point the RAM Disk should be available.

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • Write in English. If possible, check your spelling and grammar.

Author:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

 **     **  **    **  **     **  ********   ******** 
 ***   ***  **   **    **   **   **     **  **       
 **** ****  **  **      ** **    **     **  **       
 ** *** **  *****        ***     ********   ******   
 **     **  **  **      ** **    **         **       
 **     **  **   **    **   **   **         **       
 **     **  **    **  **     **  **         ******** 

Message: