Slashdot: News for Nerds


Welcome to the Slashdot Beta site -- learn more here. Use the link in the footer or click here to return to the Classic version of Slashdot.

Thank you!

Before you choose to head back to the Classic look of the site, we'd appreciate it if you share your thoughts on the Beta; your feedback is what drives our ongoing development.

Beta is different and we value you taking the time to try it out. Please take a look at the changes we've made in Beta and  learn more about it. Thanks for reading, and for making the site better!

Low cost way to maximize SQL Server uptime?

jdray (645332) writes | more than 2 years ago


jdray writes "My wife and I own a mid-sized restaurant with a couple of Point of Sale (POS) terminals. The software, which runs on Windows and .NET, uses SQL Server on the back end. With an upgrade to the next major release of the software imminent, I'm considering upgrading the infrastructure it runs on to better ensure uptime (we're open seven days a week). We can't afford several thousand dollars' worth of server infrastructure (two cluster nodes and some shared storage, or somesuch), so I thought I'd ask Slashdot for some suggestions on enabling maximum uptime. I considered a single server node running VMWare with a limp-mode failover to a VMWare instance on a desktop, but I'm not sure how to set up a monitoring infrastructure to automate that, and manual failover isn't much of an option with non-tech staff. What suggestions do you have?"

cancel ×


YES! I have a suggestion! (1)

Jane Q. Public (1010737) | more than 2 years ago | (#40422781)

Next time, get software that runs on *nix, rather than Windows. Then you will no longer be dependent on SQL Server. Instead you will have a fantastic array of options.

If you are locked in to a particular software vendor, I strongly suggest you change to something that does not require such proprietary solutions. There is a whole world of it out there. Some of it very, very good.

And when it comes to server reliability, as well as SQL reliability and performance, Microsoft is far, far behind the curve.

Change it.

Re:YES! I have a suggestion! (1)

Jane Q. Public (1010737) | more than 2 years ago | (#40422813)

And by the way: if you want "low cost", Microsoft is almost never the way to go, today. If uptime is your concern, and if (as you imply), you lose money to downtime, then buy some cheap GENERIC hardware and run Linux.

That IS your answer. Microsoft cannot supply what you ask.
Check for New Comments
Slashdot Account

Need an Account?

Forgot your password?

Don't worry, we never post anything without your permission.

Submission Text Formatting Tips

We support a small subset of HTML, namely these tags:

  • b
  • i
  • p
  • br
  • a
  • ol
  • ul
  • li
  • dl
  • dt
  • dd
  • em
  • strong
  • tt
  • blockquote
  • div
  • quote
  • ecode

"ecode" can be used for code snippets, for example:

<ecode>    while(1) { do_something(); } </ecode>
Create a Slashdot Account