Click here to Skip to main content
15,905,071 members
Home / Discussions / Database
   

Database

 
AnswerSQL Server 2008 R2 log growth question - solved! Pin
GuyThiebaut4-Oct-14 8:28
professionalGuyThiebaut4-Oct-14 8:28 
SuggestionRe: SQL Server 2008 R2 log growth question Pin
Richard Deeming6-Oct-14 1:51
mveRichard Deeming6-Oct-14 1:51 
GeneralRe: SQL Server 2008 R2 log growth question Pin
GuyThiebaut6-Oct-14 1:58
professionalGuyThiebaut6-Oct-14 1:58 
QuestionMax throughput Microsoft SQL Server? Pin
devvvy2-Oct-14 13:05
devvvy2-Oct-14 13:05 
GeneralRe: Max throughput Microsoft SQL Server? Pin
PIEBALDconsult2-Oct-14 13:36
mvePIEBALDconsult2-Oct-14 13:36 
AnswerRe: Max throughput Microsoft SQL Server? Pin
Mycroft Holmes2-Oct-14 22:15
professionalMycroft Holmes2-Oct-14 22:15 
AnswerRe: Max throughput Microsoft SQL Server? Pin
Eddy Vluggen3-Oct-14 7:33
professionalEddy Vluggen3-Oct-14 7:33 
AnswerRe: Max throughput Microsoft SQL Server? Pin
jschell3-Oct-14 9:32
jschell3-Oct-14 9:32 
devvvy wrote:
hi... is there a max limit to throughput of Microsoft SQL Server cluster in terms of how many request (or... *simple* query) the cluster can take per minute?


Everything in computing has limits but I doubt that has anything to do with your question.

Presumably you or someone else you know thinks that X is 'better' than SQL server without even doing any real analysis.

Here is an example of someone using SQL Server

http://highscalability.com/blog/2014/7/21/stackoverflow-update-560m-pageviews-a-month-25-servers-and-i.html[^]

Myself I was tasked with doing performance tests using the application that I was working on, and at the time the application server could handle 100+ TPS a second sustained where I estimated that the entire US market for that business domain was only 2000 TPS.

And during that test I couldn't get SQL Server to even provide any real CPU/Memory load on some pretty crappy equipment. Consequently my conclusion was that for any conceivable reality a single SQL server instance would serve the needs of the company.

Now it is certainly possible that you have a business domain that has some very specific data needs based on the business needs. Not hypothetical tech arguments. If so then you need to do the following
- Collect the actual business requirements that might lead to performance problems.
- Collect the actual market potential of business. One might reasonably claim as a top level that owning the entire market in the world is the goal but claiming astronomical numbers without any real world basis is foolhardy. So is making up numbers without looking at markets at all.
- Do an analysis of likely transaction flows based on the first item.
- Identify possible bottle necks.
- AFTER doing the above then look for solutions that will solve any bottle necks at the data persistence layer.

Finally expect that if you have bottle necks at the data persistence layer then you MUST expect that you are going to need to have other architectural changes necessary to deal with that. A specific type of data persistence server will NOT solve problems of this sort.
GeneralRe: Max throughput Microsoft SQL Server? Pin
Eddy Vluggen3-Oct-14 9:52
professionalEddy Vluggen3-Oct-14 9:52 
GeneralRe: Max throughput Microsoft SQL Server? Pin
devvvy3-Oct-14 14:38
devvvy3-Oct-14 14:38 
GeneralRe: Max throughput Microsoft SQL Server? Pin
Jörgen Andersson3-Oct-14 20:13
professionalJörgen Andersson3-Oct-14 20:13 
GeneralRe: Max throughput Microsoft SQL Server? Pin
jschell6-Oct-14 10:04
jschell6-Oct-14 10:04 
GeneralRe: Max throughput Microsoft SQL Server? Pin
devvvy7-Oct-14 12:55
devvvy7-Oct-14 12:55 
GeneralRe: Max throughput Microsoft SQL Server? Pin
jschell8-Oct-14 10:26
jschell8-Oct-14 10:26 
QuestionCan predicates in the WHERE clause affect the type of join Pin
Richard.Berry1002-Oct-14 10:16
Richard.Berry1002-Oct-14 10:16 
AnswerRe: Can predicates in the WHERE clause affect the type of join Pin
Jörgen Andersson2-Oct-14 10:34
professionalJörgen Andersson2-Oct-14 10:34 
GeneralRe: Can predicates in the WHERE clause affect the type of join Pin
PIEBALDconsult2-Oct-14 10:41
mvePIEBALDconsult2-Oct-14 10:41 
GeneralRe: Can predicates in the WHERE clause affect the type of join Pin
Jörgen Andersson2-Oct-14 10:46
professionalJörgen Andersson2-Oct-14 10:46 
GeneralRe: Can predicates in the WHERE clause affect the type of join Pin
PIEBALDconsult2-Oct-14 11:45
mvePIEBALDconsult2-Oct-14 11:45 
GeneralRe: Can predicates in the WHERE clause affect the type of join Pin
Richard.Berry1002-Oct-14 11:15
Richard.Berry1002-Oct-14 11:15 
AnswerRe: Can predicates in the WHERE clause affect the type of join Pin
Arora_Ankit13-Oct-14 21:06
Arora_Ankit13-Oct-14 21:06 
AnswerRe: Can predicates in the WHERE clause affect the type of join Pin
Member 1115182813-Oct-14 23:38
Member 1115182813-Oct-14 23:38 
QuestionNeed Suggestion for Replacement DB Pin
Kevin Marois30-Sep-14 12:41
professionalKevin Marois30-Sep-14 12:41 
AnswerRe: Need Suggestion for Replacement DB Pin
Mycroft Holmes30-Sep-14 12:52
professionalMycroft Holmes30-Sep-14 12:52 
GeneralRe: Need Suggestion for Replacement DB Pin
Kevin Marois30-Sep-14 12:55
professionalKevin Marois30-Sep-14 12:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.