Pause VM when SQL server idle

0

In OSX Mountain Lion, I run a Windows Server 2003 VM solely to run SQL Sever 2008. It chews up a lot of battery life. Is there some way to automatically pause the VM when the SQL Server is idle and restart it again when requested (kind of like wake-on-lan)?

Update: I can get it to pause when idle by setting the power setting in Windows to put the system to sleep. However, I cannot get it to start back up again.

Kyle Heironimus

Posted 2012-11-03T17:27:15.863

Reputation: 189

Automatically? Or manually? – Canadian Luke – 2012-11-03T18:25:36.647

Automatically. Ideally it would start it when it was requested and pause it when idle for some number of minutes. Question updated to be clearer. – Kyle Heironimus – 2012-11-05T17:36:37.263

Answers

0

Well, sql server cannot do anything once the OS is asleep.

That leaves hardware (or virtual hardware). If you could modify the clients to check how long it was since they last accessed the server and if it was longer than windows leep time send a wake up call, pause while windows boots again, and then continue; then yes, you could.

I bit more practical might be to just run an sql server on OSX.

Hennes

Posted 2012-11-03T17:27:15.863

Reputation: 60 739

Asked: 2012-11-03T17:27:15.863

Viewed: 49 times

Active: 2016-06-29T18:36:48.143