locked
scale up and scale out RRS feed

  • Question

  • hi, experts, when discussing the sql server,

    scale up -> adding more memory?

    scale out -> add more sql server hardware for cluster?

    adding more cpus/ threads on VM for sql server-> scale up or scale out?

    adding more storage -> scale up or scale out?

    I heard these during meeting for sql server configuration. wanna understand more.

    thanks!

    Sunday, June 21, 2015 7:38 AM

Answers

All replies

  • Scale up - means adding more resources to the existing set up - resources such as memory,cpu etc.. 

    scale out - means offloading some the workload to another server, typically, you build another sql server and migrate the databases\data to that. so, you are reducing the workload on the current server and building another server and offloading the workload to it...

    refer this : http://www.brentozar.com/archive/2011/02/scaling-up-or-scaling-out/

    read this article from micrsoft : https://msdn.microsoft.com/en-us/library/aa479364.aspx?f=255&MSPPError=-2147217396


    Hope it Helps!!


    Sunday, June 21, 2015 7:50 AM
    Answerer
  • Scaling out a SQL Server environment across multiple systems can be a difficult and complicated project, involving partitioned databases, federation and more. So, when it comes to SQL Server scalability, most organizations prefer to scale individual systems up as much as possible before trying to tackle the out option.

    http://blog.codinghorror.com/scaling-up-vs-scaling-out-hidden-costs/

    http://www.techrepublic.com/article/two-options-for-scaling-out-your-sql-server-system/6170401/


    Please Mark Answer if it solved your issue, Vote As Helpful if it helps to solve your issue

    Sunday, June 21, 2015 11:56 AM
  • Architectural design of database server systems should include scaling (out or up) as an important consideration. With cheaper hardware, scale out has become the norm . Another factor which has influenced scale out is SQL Server features - which support scal out - such as : http://www.sqlserver-dba.com/2011/01/sql-server-scaling-techniques.html


    Jack Vamvas sqlserver-dba.com

    Monday, June 22, 2015 5:38 AM