High Availability

Tech-Archive recommends: Speed Up your PC by fixing your registry

Greetings All,

I am seeking an answer to high availability.

I am building out a new enviroment that will highly depend on a SQL server.

In my mind, the OS/SQL Software will die before the hardware will... so I am
at odd's with spending 100K on a fibre SAN.

This brings me to my question....

If one my SQL Box dies, weather that be due to a virus or hardware failure
or Windows Crash, I want the second box to pick up the load. Ideally this
would carry over any live session as the time, but not essencial. During the
time that there is no problems, I would like the 2 SQL boxes to share the
load. THus, so I do not have a box just sitting there doing nothing.

What exactly should I be looking for in a solution?

I have speced out Dell Hardware and am looking at blade solutions and a SAN,
but the cost is so high, I am wondering if I could tone down my hardware cost
and build a better software solution?

Thanks in Advance,
--
Da' Drone
.

Relevant Pages

  • Re: High Availability
    ... > I am seeking an answer to high availability. ... > I am building out a new enviroment that will highly depend on a SQL server. ... the OS/SQL Software will die before the hardware will... ... > but the cost is so high, I am wondering if I could tone down my hardware cost ...
    (microsoft.public.windows.server.clustering)
  • Re: MSCS Questions
    ... hardware won't necessarily speed things up. ... > server solution than we had, including more memory and faster processors. ... > I understand that clustering isn't a performance benefit, ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)
  • Re: High Availability
    ... SQL does not load balance. ... Hardware should be on Clustering HCL - ... the OS/SQL Software will die before the hardware will... ...
    (microsoft.public.windows.server.clustering)
  • Re: Web Server Setup
    ... Also, have a bunch of space for temporary SQL dbs, just for playing and tests. ... the specifications you described might be just the hardware for the test machine. ... I need to set up a server to handle an application that will pretty much ... 146GB Drives w/ RAID and dual hot swappable power supplys. ...
    (microsoft.public.windows.server.general)
  • Re: Performance problem...
    ... made many changings to the hardware structure. ... I have created many SPs instead using dynamic SQL ... The database is 1 GB large. ... >> at the same time, data from Profiler, Perfmon and SQL Analyser. ...
    (microsoft.public.sqlserver.tools)