This post is not directly related to SQL Server but to one of the questions asked by someone at SSC couple of days back. In Windows when the drive is running low on space, a pop-up is displayed in the System Notification area which looks like
The question was whether we can modify the threshold which controls this behavior of Windows. By default, when the free space available on the drive is less than 90% this notification is displayed.
There is no direct way of doing this, however the following registry tweak can do it for us.
- Open registry editor (Run –> regedit.exe)
- Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
- Check if a name called DiskSpaceThreshold exists. If it does not exist, right click and create new DWORD value and rename is as DiskSpaceThreshold
- The value of this name can range from 0 to 99. This represents the percentage of disk full at which Windows should pop-up the Low Disk Notification.
- The server needs to be restarted for this change to take affect.
The other question he did not ask whether this notification can be disabled? Yes even this notification can be disabled. Here is how.
- Open Registry Editor
- Navigate to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer
- Create a new DWORD value named NoLowDiskSpaceChecks
- Double click the new value and enter the value as 1
Restart the server and the notification will not be displayed until this value is deleted or its value is changed to 0.