How does SQL Server deal with a missing tempDB?

Azure has announced the new "D" series of VM's where the temporary drive resides on a SSD

I was planning to use this as the tempDB, it should speed up SQL somewhat with faster temoDB access. However,data on this drive may be lost at any reboot.

In such a situation, how does SQL deal with the loss? Is this supported behavior?

ssd
sql-server
azure

Akash

Posted 2014-09-25T17:41:49.557

Reputation: 3 682

Answers

Storing TempDB and also Buffer Pool Extensions on SSDs is supported in Azure VMs.

Look at http://blogs.technet.com/b/dataplatforminsider/archive/2014/09/25/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions.aspx

user372379

Posted 2014-09-25T17:41:49.557

Reputation: 26

Asked: 2014-09-25T17:41:49.557

Viewed: 506 times

Active: 2014-09-25T23:09:59.927