question

ChrisStamey-9421 avatar image
0 Votes"
ChrisStamey-9421 asked ChrisStamey-9421 commented

Questions Using the Azure Temp Drive for TempDB

I have seen several articles around the Internet describing the use of the Azure temporary drive for TempDB storage. It brought up a couple of questions for me. 1. What is the temp drive physical hardware, Standard SSD, Premium SSD, Ultra SSD? How can I find out? Does the disk type match the disk type of C:? 2. As I don't think I can change the block size for the temp drive, and it is set to 4K, what will that do to performance vs me setting up my own drive set for 64K block size? 3. Should TempDB data AND log go on the temporary drive? Thanks, Chris

azure-sql-virtual-machines
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ChrisStamey-9421 Any updates on the issue?

Please "Accept as Answer" if below helped so it can help others in community looking for help on similar topics.

Thanks

0 Votes 0 ·

1 Answer

GuillaumeH avatar image
0 Votes"
GuillaumeH answered ChrisStamey-9421 commented

Regarding the hardware behind it, this is voluntarily not documented by Microsoft as answered elsewhere by an employee :
"We will not provide performance metrics on temp drive has it varies with every VM size. Hence it's not been documented and since temp drive are provided to VMs, from underlying compute machine itself the read/write operations will be fast. However it can't be expanded or increased based on requirement. You may have to increase the size of VMs if you need more temp drive space and if that temporary files are important, then you need to go for premium disks as it provide persistent data."

I would be against storing logs on it as you could loose them and they can matter a lot depending of the situation.

It seems that putting TempDB on the temp drive is recommended : https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices
"Place TempDB on the local SSD D:\ drive for mission critical SQL Server workloads (after choosing correct VM size)." (D: being the temp drive)

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

When I said "log" I meant the TempDB log, not user DB logs. Do you have any info on the difference in block size question?

0 Votes 0 ·