When you create an Azure VM, it creates a D: drive named "Temporary Storage". It's unclear to me just how temporary this is though. Is it reset between reboots, start/stop, or just if the image is recreated? Or arbitrarily? Also, what are some use cases for this temporary storage?
当您创建一个Azure VM时,它会创建一个D:名为“临时存储”的驱动器。我不清楚这有多短暂。它是否在重新启动、启动/停止、或者仅仅是重新创建映像之间重置?还是随意?另外,这个临时存储的一些用例是什么?
3 个解决方案
#1
19
Resets, reboots, fail overs etc. can wipe it. It is only to be used for swap files etc.
重置、重新启动、故障转移等可以清除它。它只用于交换文件等。
Performance Best Practices for SQL Server in Azure Virtual Machines
Azure虚拟机中SQL Server的性能最佳实践。
Temporary Disk
临时磁盘
The temporary storage drive, labeled as the D: drive is not persisted and is not saved in the Windows Azure Blob storage. It is used primarily for the page file and its performance is not guaranteed to be predictable. Management tasks such as a change to the virtual machine size, resets the D: drive. In addition, Windows Azure erases the data on the temporary storage drive when a virtual machine fails over. The D: drive is not recommended for storing any user or system database files, including tempdb.
临时存储驱动器,标记为D:驱动器不持久,并没有保存在Windows Azure Blob存储中。它主要用于页面文件,它的性能不能保证是可预测的。管理任务,如更改虚拟机大小,重置D:驱动器。此外,当虚拟机失败时,Windows Azure会删除临时存储驱动器上的数据。D:不建议存储任何用户或系统数据库文件,包括tempdb。
EDIT: Interestingly enough the above has now been updated to the below which says that is is OK to store your tempdb on if you are using the D-Series Virtual Machines.
编辑:有趣的是,上面的内容现在已经更新到下面了,如果您使用d系列虚拟机,那么可以将您的tempdb存储在下面。
The temporary storage drive, labeled as the D: drive, is not persisted to Azure blob storage. Do not store your data or log files on the D: drive. Only store tempdb and/or Buffer Pool Extensions on the D drive when using the D-Series Virtual Machines (VMs). Unlike the other VM series, the D drive in the D-Series VMs is SSD-based. This can improve the performance of workloads that heavily use temporary objects or that have working sets which don't fit in memory. For more information, see Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions.
临时存储驱动器,贴上D:开车,不是持久化到Azure blob存储。不存储数据或日志文件在D:开车。只有tempdb和/或缓冲池存储扩展D驱动器上使用D时虚拟机(vm)。与其他虚拟机系列、D D VM是SSD-based开车。这可以改善工作负载的性能,大量使用临时对象,或者有工作集,不适合在内存中。有关更多信息,请参见在Azure vm使用ssd存储TempDB和缓冲池扩展SQL Server。
Some Azure Virtual Machine Basics Please
请提供一些Azure虚拟机的基础知识。
The Temporary storage drive is a local drive on the physical box that should only serve as scratch space. For example, we put the paging file onto this drive to save on transaction costs for each Windows page-in but nothing else. I would recommend you don’t put anything that you need persisted on this drive as it will be deleted upon any hardware failure the system sees whereas the OS disk and any data disks attached will remain persisted in storage even on hardware failures.
临时存储驱动器是物理框上的一个本地驱动器,该驱动器只可作为暂存空间。例如,我们将分页文件放在这个驱动器上,以节省每个Windows页面的事务成本,但除此之外没有别的。我建议您不要将您所需要的任何东西放在这个驱动器上,因为它将在系统看到的任何硬件故障时被删除,而操作系统磁盘和附加的任何数据磁盘即使在硬件故障时也会继续存储在存储中。
#2
7
This disk is a local disk, non-replicated. If it crashes, anything on it is gone. If your VM is moved to another server, the content is gone. If you scale a VM size down, it's likely this data will be gone, as the allocation size decreases.
此磁盘是本地磁盘,非复制。如果它崩溃了,它上面的任何东西都消失了。如果您的VM被转移到另一个服务器,内容就会消失。如果您缩小了VM大小,那么随着分配大小的减少,这些数据很可能会消失。
As for use cases: Think about database servers that need a scratch disk. Or maybe your workflow involves grabbing content from a blob, processing it, then shipping it off somewhere (e.g. photo/video/audio processing). You could download to temporary storage, do all of your transform work on that disk, then pick up the results, saving the final file somewhere durable. Temp storage use is really open-ended - it's really up to you how you use it; just realize that it's not durable storage (unlike your VHD, which is in durable storage).
至于用例:请考虑需要一个临时磁盘的数据库服务器。或者你的工作流程包括从一个blob中抓取内容,处理它,然后将其发送到某个地方(例如,照片/视频/音频处理)。您可以下载到临时存储,在该磁盘上完成所有的转换工作,然后获取结果,将最终文件保存到某个持久的地方。临时存储的使用是开放式的——这取决于你如何使用它;只要意识到它不是持久存储(不像VHD,它在持久存储中)。
#3
0
When you resize the VM, When you shutdown or restart your VM, when your VM is moved to a different host server(due to service healing, shutdown and restart), when the host is updated, when the host experiences a hardware failure etc.
当您调整VM的大小时,当您关闭或重新启动VM时,当您的VM被移动到另一个主机服务器(由于服务的恢复、关机和重启),当主机被更新时,当主机经历硬件故障等时。
Source: Azure Pricing page
来源:Azure价格页面
#1
19
Resets, reboots, fail overs etc. can wipe it. It is only to be used for swap files etc.
重置、重新启动、故障转移等可以清除它。它只用于交换文件等。
Performance Best Practices for SQL Server in Azure Virtual Machines
Azure虚拟机中SQL Server的性能最佳实践。
Temporary Disk
临时磁盘
The temporary storage drive, labeled as the D: drive is not persisted and is not saved in the Windows Azure Blob storage. It is used primarily for the page file and its performance is not guaranteed to be predictable. Management tasks such as a change to the virtual machine size, resets the D: drive. In addition, Windows Azure erases the data on the temporary storage drive when a virtual machine fails over. The D: drive is not recommended for storing any user or system database files, including tempdb.
临时存储驱动器,标记为D:驱动器不持久,并没有保存在Windows Azure Blob存储中。它主要用于页面文件,它的性能不能保证是可预测的。管理任务,如更改虚拟机大小,重置D:驱动器。此外,当虚拟机失败时,Windows Azure会删除临时存储驱动器上的数据。D:不建议存储任何用户或系统数据库文件,包括tempdb。
EDIT: Interestingly enough the above has now been updated to the below which says that is is OK to store your tempdb on if you are using the D-Series Virtual Machines.
编辑:有趣的是,上面的内容现在已经更新到下面了,如果您使用d系列虚拟机,那么可以将您的tempdb存储在下面。
The temporary storage drive, labeled as the D: drive, is not persisted to Azure blob storage. Do not store your data or log files on the D: drive. Only store tempdb and/or Buffer Pool Extensions on the D drive when using the D-Series Virtual Machines (VMs). Unlike the other VM series, the D drive in the D-Series VMs is SSD-based. This can improve the performance of workloads that heavily use temporary objects or that have working sets which don't fit in memory. For more information, see Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions.
临时存储驱动器,贴上D:开车,不是持久化到Azure blob存储。不存储数据或日志文件在D:开车。只有tempdb和/或缓冲池存储扩展D驱动器上使用D时虚拟机(vm)。与其他虚拟机系列、D D VM是SSD-based开车。这可以改善工作负载的性能,大量使用临时对象,或者有工作集,不适合在内存中。有关更多信息,请参见在Azure vm使用ssd存储TempDB和缓冲池扩展SQL Server。
Some Azure Virtual Machine Basics Please
请提供一些Azure虚拟机的基础知识。
The Temporary storage drive is a local drive on the physical box that should only serve as scratch space. For example, we put the paging file onto this drive to save on transaction costs for each Windows page-in but nothing else. I would recommend you don’t put anything that you need persisted on this drive as it will be deleted upon any hardware failure the system sees whereas the OS disk and any data disks attached will remain persisted in storage even on hardware failures.
临时存储驱动器是物理框上的一个本地驱动器,该驱动器只可作为暂存空间。例如,我们将分页文件放在这个驱动器上,以节省每个Windows页面的事务成本,但除此之外没有别的。我建议您不要将您所需要的任何东西放在这个驱动器上,因为它将在系统看到的任何硬件故障时被删除,而操作系统磁盘和附加的任何数据磁盘即使在硬件故障时也会继续存储在存储中。
#2
7
This disk is a local disk, non-replicated. If it crashes, anything on it is gone. If your VM is moved to another server, the content is gone. If you scale a VM size down, it's likely this data will be gone, as the allocation size decreases.
此磁盘是本地磁盘,非复制。如果它崩溃了,它上面的任何东西都消失了。如果您的VM被转移到另一个服务器,内容就会消失。如果您缩小了VM大小,那么随着分配大小的减少,这些数据很可能会消失。
As for use cases: Think about database servers that need a scratch disk. Or maybe your workflow involves grabbing content from a blob, processing it, then shipping it off somewhere (e.g. photo/video/audio processing). You could download to temporary storage, do all of your transform work on that disk, then pick up the results, saving the final file somewhere durable. Temp storage use is really open-ended - it's really up to you how you use it; just realize that it's not durable storage (unlike your VHD, which is in durable storage).
至于用例:请考虑需要一个临时磁盘的数据库服务器。或者你的工作流程包括从一个blob中抓取内容,处理它,然后将其发送到某个地方(例如,照片/视频/音频处理)。您可以下载到临时存储,在该磁盘上完成所有的转换工作,然后获取结果,将最终文件保存到某个持久的地方。临时存储的使用是开放式的——这取决于你如何使用它;只要意识到它不是持久存储(不像VHD,它在持久存储中)。
#3
0
When you resize the VM, When you shutdown or restart your VM, when your VM is moved to a different host server(due to service healing, shutdown and restart), when the host is updated, when the host experiences a hardware failure etc.
当您调整VM的大小时,当您关闭或重新启动VM时,当您的VM被移动到另一个主机服务器(由于服务的恢复、关机和重启),当主机被更新时,当主机经历硬件故障等时。
Source: Azure Pricing page
来源:Azure价格页面