You need to relax and get out more.
We SQL Server DBAs are constantly checking that cell phone, worried about that email from a user saying, “The server is borked.” When it comes in, we drop everything, run to the nearest laptop, and try to figure out just how bad things are and if they’ve gone back to normal.
You’ll be more relaxed on the weekends if you can do these two things:
- Find out before the users find out
- Be able to check health from anywhere
There’s a web app for that – Red Gate SQL Monitor. It sends you emails when things start to go pear-shaped, and then you can whip out your trusty iPad to check your server’s health and stats from anywhere. You can see it live now by going to http://monitor.red-gate.com, which shows SQLServerCentral’s database servers. (You don’t have to log in, but of course you’d use the built-in username/password security for your own SQL Monitor web site.) A few screenshots:
All from your iPad, anytime you’re within range of WiFi or a 3G cellular signal. You can stop worrying about what your server’s doing, and start being present with your family, your friends, and your hobbies.
What’s that? You don’t have an iPad?
Red Gate wants to fix that. They’re giving away 30 prize packages, each with a 16GB 3G iPad and a license to Red Gate SQL Monitor! I got 10 to give away, Steve Jones is giving away 10, and Grant Fritchey is giving away 10, but you can only enter in one of our contests. To enter for mine, all you have to do is post a blog comment below and tell me where you’d go if you didn’t have to worry about what your servers are doing. The deadline for entry is Friday, December 17th, 2010, and then we’ll pick 10 random lucky winners to be announced on Monday, December 20th, 2010. (And if you win, you owe me a picture of yourself monitoring your SQL Servers with your new iPad!)
Here’s the fine print:
- The contest is open to professionals with SQL Server monitoring responsibility. Entrants must be 18 years old or over.
- Entries must be received by Friday, December 17, 2010. The contest organizers accept no responsibility for corrupted or delayed entries.
- Employees of Red Gate, the contest organizers and their family members are not eligible to participate in the contest.
- Entries are limited to one per person across the three simultaneous contests hosted on www.SQLServerCentral.com, www.BrentOzar.com, and www.ScaryDBA.com.
- The organizers reserve the right, within their sole discretion, to disqualify nominations.
- The organizers’ decisions are final.
- Red Gate Software and those involved in the organization, promotion, and operation of the contest and in the awarding of prizes explicitly make no representations or warranties whatsoever as to the quality, suitability, merchantability, or fitness for a particular purpose of the prizes awarded and they hereby disclaim all liability for any loss or damage of any kind, including personal injury, suffered while participating in the contest or utilizing any prizes awarded.