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 QUICKSHIFT Real?

QuickShift is advertising a software product to radically improve SQL
performance. They claim to be Microsoft certed. Does anyone know if this
product is real? If it is it would lead one to ask why Microsoft has not
done something similiar to what they do to improve performance.
Thanks
SB
It is real; as to whether it works as advertised? I don't know... The
product uses dynamic compression to do its job. If your processors are
underutilized but you have other kinds of bottlenecks (e.g. IO, RAM), I
think it could work well... But companies have been trying compression for a
long time, with little success. Remember Stacker?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"SB99379" <SB99379@.discussions.microsoft.com> wrote in message
news:FBE6476E-13D7-42D0-9AFB-28AFCB76F0FF@.microsoft.com...
> QuickShift is advertising a software product to radically improve SQL
> performance. They claim to be Microsoft certed. Does anyone know if this
> product is real? If it is it would lead one to ask why Microsoft has not
> done something similiar to what they do to improve performance.
> Thanks
> SB

Is QUICKSHIFT Real?

QuickShift is advertising a software product to radically improve SQL
performance. They claim to be Microsoft certed. Does anyone know if this
product is real? If it is it would lead one to ask why Microsoft has not
done something similiar to what they do to improve performance.
Thanks
SBIt is real; as to whether it works as advertised? I don't know... The
product uses dynamic compression to do its job. If your processors are
underutilized but you have other kinds of bottlenecks (e.g. IO, RAM), I
think it could work well... But companies have been trying compression for a
long time, with little success. Remember Stacker?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"SB99379" <SB99379@.discussions.microsoft.com> wrote in message
news:FBE6476E-13D7-42D0-9AFB-28AFCB76F0FF@.microsoft.com...
> QuickShift is advertising a software product to radically improve SQL
> performance. They claim to be Microsoft certed. Does anyone know if this
> product is real? If it is it would lead one to ask why Microsoft has not
> done something similiar to what they do to improve performance.
> Thanks
> SB

Is QUICKSHIFT Real?

QuickShift is advertising a software product to radically improve SQL
performance. They claim to be Microsoft certed. Does anyone know if this
product is real? If it is it would lead one to ask why Microsoft has not
done something similiar to what they do to improve performance.
Thanks
SBIt is real; as to whether it works as advertised? I don't know... The
product uses dynamic compression to do its job. If your processors are
underutilized but you have other kinds of bottlenecks (e.g. IO, RAM), I
think it could work well... But companies have been trying compression for a
long time, with little success. Remember Stacker?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"SB99379" <SB99379@.discussions.microsoft.com> wrote in message
news:FBE6476E-13D7-42D0-9AFB-28AFCB76F0FF@.microsoft.com...
> QuickShift is advertising a software product to radically improve SQL
> performance. They claim to be Microsoft certed. Does anyone know if this
> product is real? If it is it would lead one to ask why Microsoft has not
> done something similiar to what they do to improve performance.
> Thanks
> SB