is there a a real need for failover clustering or should we invest in other redundancies?

I've read some articles about the andvantages of failover clustering for MS
SQL Server. I wonder if this is really an important point for environments
with web servers accessing a database and with a limeted budget.
As I remember you need the enterprise edition of MS SQL Server to setup a
failover cluster (which is not really cheap). Also with webservers running
custom business logic, you have a much higher risk in crashing the web
application than crashing a single node of an SQL-Server-Cluster. And there
is no performence benefit (I think clustering will cause a lower performance
because of the overhead).
With all this in mind: Who was ever glad to have failover clustering because
of a hardware crash on an SQL server? Are there any studies about the
effective benefit in "uptime" using a failover cluster?
Lets assume :
- 1 internet connection
- 2-node firewall
- 4 web servers
- 2 switches involved
- 1 SQL-Server
Dell publishes a paper these "facts" (are they "facts" or "whishes"?):
- Win2k & SQL-Server => 99% UpTime
- Win2k & SQL-Server & RAID => 99,9% UpTime
- Win2k & SQL-Server & RAID & Cluster => 99,99% UpTime
Is this realistic? If "yes" - what would you assume to be a realistic UpTime
for the configuration above without the SQL-Server - Would you invest in a
Backup Internet Connection, additional firewall nodes, additional web
servers?
Thanks for yout opinion,
SvenFrom the tone of your question it sounds like you don't need it.
It depends on how much down time the business can afford, how
experienced the staff are and what the support coverage is as to whether
it is advisable.
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Is SQL 2005 failover cluster supported on Windows 2008 clusters?

Hi,
I'm trying to install SQL 2005 on a Windows 2008 cluster. I just want
to know if this is supported, and if there's any special procedures
required for the same.
Thanks
M Rosenblum
Since Windows 2008 is not a released product, there is no "supported"
configuration. If there is any information, it will likely be in the
Windows 2008 readme file.
Feel free to experiment and post your results.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Usentr" <usentr@.gmail.com> wrote in message
news:1194464048.828727.215070@.e9g2000prf.googlegro ups.com...
> Hi,
> I'm trying to install SQL 2005 on a Windows 2008 cluster. I just want
> to know if this is supported, and if there's any special procedures
> required for the same.
> Thanks
> M Rosenblum
>