D
D
Dmitry Guketlev2012-03-04 12:21:12
SQL Server
Dmitry Guketlev, 2012-03-04 12:21:12

Microsoft SQL Server won't let you disable disks?

Hi all.
I have a separate computer at home on which a lot of things are running, including MS SQL Server, which I use for development (there are no applications on it). The SQL server database is stored on a RAID1 array, and when the SQL server is running, it constantly writes / reads something in it, as I understand it, in order to prevent the disks from stopping.
I understand that this is reasonable behavior so that when a request comes in, it can respond as quickly as possible, but in my situation, when I sleep, the request will not come and the disks could be stopped (so that I sleep better and the disks do not wear out). And when I wake up in the morning, I can wait until he spins the disks at the first request.
Can I disable this option somehow? I didn't find all the settings.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
B
benipaz, 2012-03-04
@benipaz

I can offer another way - install vmware or the like. and transfer everything related to development there. before going to bed, just turn off the virtual machine and sleep peacefully, and as a bonus, save electricity.
by the way, if this is a separate machine, then you can put a hypervisor, and then screw anything you want on it

D
dbmaster, 2012-03-06
@dbmaster

Use Resource Monitor / ProcMon technet.microsoft.com/en-us/sysinternals/bb896645
to understand what resources are being used. shouldn't sql server use disks unnecessarily

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question