Microsoft SQL server does not disable the drives?

Hi all.


I have a separate home computer which turns a lot of things including MS SQL Server, which I use for development (no apps on it no). SQL server database is stored on a RAID1 array, and SQL server while it is running constantly then it writes\reads, as I understand it, in order not to allow the drives to stop.


I understand that this is a reasonable behavior to when there was a request he could as quickly as possible to answer, but in my situation when I'm asleep the request is not coming and could use the discs to stop (me to sleep better, and the discs were not worn out). And when I Wake up in the morning, I can wait and he'll spin the discs on the first request.


Can this option be turned off? All settings are dug up not found.
October 8th 19 at 02:34
2 answers
October 8th 19 at 02:36
can you suggest a different method — put vmware or etc. and all that is associated with the development start moving. before going to sleep just turn off the virtual machine, and sleep peacefully, and as a bonus save electricity.
by the way, if it is a separate machine, then you can put a hypervisor on it and then tie anything
October 8th 19 at 02:38
Use Resource Monitor / ProcMon technet.microsoft.com/en-us/sysinternals/bb896645
to understand what resources are used. don't have sql server to use the drives without the need

Find more questions by tags SQL Server