Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
    
Automatically? Or manually? – Canadian Luke Nov 3 '12 at 18:25
    
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 Nov 5 '12 at 17:36

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .