locked
SQL Requirement - Local vs Remote RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,

    We're setting out a plan to setup SCCM 2012 R2 for computer/server inventory to begin with with under 5000 clients. I've looked around and can't really find a definitive answer. Would using a remote sql database work fine or would we be better off installing SQL locally on the same sccm server?
    Wednesday, February 12, 2014 3:15 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    The recommendation is to install SQL locally, it will actually perform better (assuming you configure enough memory and conform to the recommended disk layout) than if SQL was remote.  Also, configuration will be easier.
    Wednesday, February 12, 2014 3:19 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    The recommendation is to install SQL locally, it will actually perform better (assuming you configure enough memory and conform to the recommended disk layout) than if SQL was remote.  Also, configuration will be easier.
    Wednesday, February 12, 2014 3:19 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    from technet

    Stand-alone primary site

    • Up to 100,000 clients
    • SQL Server is installed on the site server computer
    • 8 cores (Intel Xeon E5504 or comparable CPU)
    • 32 GB of RAM
    • 550 GB hard disk space for the operating system, SQL Server, and all database files

    Unless you are above 100k clients and need a CAS, installing SQL remotely on a single primary doesn't buy you anything.  Plus, CM 2012 comes with a SQL standard license, so licensing isn't a factor.

    Wednesday, February 12, 2014 3:22 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you for the speedy response, it's greatly appreciated!
    Wednesday, February 12, 2014 3:39 PM