Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / May 2005

Tip: Looking for answers? Try searching our database.

How would you answer?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Richard Douglass - 18 May 2005 23:46 GMT
My boss issued a challenge at lunch today:  Find out if SQL can cluster to
support thousands of end-users with hundreds of thousands of trans per
minute, or we start looking at Oracle.

What do I say to him?

Thanks
Richard
Mike Epprecht \(SQL MVP\) - 19 May 2005 00:20 GMT
http://www.microsoft.com/sql/evaluation/casestudies/alphalisting.asp,
especially the NASDAQ one.

www.tpc.org

700'000 tpm fast enough?

It's not a case of if your DB server can handle the load, but a case of if
your software is capable of pushing it there. Ask your software vendor if
they can push SQL, Oracle, DB2 or Sybase it it's limits. They will look at
you stupid and not have an answer.

SAP is capable, and I have seen no other software able to do it.
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> My boss issued a challenge at lunch today:  Find out if SQL can cluster to
> support thousands of end-users with hundreds of thousands of trans per
[quoted text clipped - 4 lines]
> Thanks
> Richard
Andrew J. Kelly - 19 May 2005 13:59 GMT
I have personally worked on systems that did over 1 million trans per minute
on SQL Server and they were not the largest by any means.  There are
hundreds of systems out there with a thousand or more users with no problem.
Just look at the links Mike pointed out and browse the SQL Server web site
for lots of white papers and case studies.  But don't get confused when you
talk of clustering.  Clustering is a hardware failover solution only when it
comes to sql server. These systems I am talking about are mainly single
boxes with anywhere from 4 to 64 processors.

Signature

Andrew J. Kelly  SQL MVP

> My boss issued a challenge at lunch today:  Find out if SQL can cluster to
> support thousands of end-users with hundreds of thousands of trans per
[quoted text clipped - 4 lines]
> Thanks
> Richard
Geoff N. Hiten - 19 May 2005 14:17 GMT
Sounds like you have an Oracle bigot on your hands.  His defining the term
'cluster' to match Oracle marketing's definition is a dead giveaway.  As
Mike and Andrew noted, SQL can match/exceed Oracle on any conceivable
database implementation.  They will do it differently and if your boss
defines "different" as failure, you won't have a chance.  Show him the
numbers and if he is reasonable, you will have a chance. If he insists that
clustering is a bunch of cheap brick computers that scale out, then he has
gone over to the dark side.

Geoff N. Hiten
Microsoft SQL Server MVP

> My boss issued a challenge at lunch today:  Find out if SQL can cluster to
> support thousands of end-users with hundreds of thousands of trans per
[quoted text clipped - 4 lines]
> Thanks
> Richard
Kevin3NF - 20 May 2005 14:25 GMT
lol...dark side....Star Wars references are so....yesterday ;-)

Signature

Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

> Sounds like you have an Oracle bigot on your hands.  His defining the term
> 'cluster' to match Oracle marketing's definition is a dead giveaway.  As
[quoted text clipped - 17 lines]
>> Thanks
>> Richard
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.