Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals >
> 
> 
> 
Maximum devices for LocalDB

Answered Maximum devices for LocalDB

  • Thursday, December 20, 2012 1:59 PM
     
     
    Sign In to Vote
    0

    I thought I recall making a noted in the Getting Started guide, FAQ or forums that I saw a "recommended max" for devices using the LocalDB as opposed to a full Standard or Enterprise version.  Can you note the recommendation? ex. 10,000 and also if this is per the installation or just per Database.

    Ex.  I have 20,000 servers, should I split this into multiple databases or installations?

     

All Replies

  • Thursday, December 20, 2012 7:16 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Although there isn't any "official" recommendation, I would say that for any inventory over 6 or 7K machines, you will want to use a full edition of SQL Server such as Standard or Enterprise and follow the directions in this Wiki article on setting up the dedicated SQL instance that MAP needs.

    http://social.technet.microsoft.com/wiki/contents/articles/1645.manually-install-sql-server-for-use-with-map-toolkit-en-us.aspx

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.

     
  • Thursday, January 03, 2013 10:38 PM
     
     
    Sign In to Vote
    0
    Thanks Mike, that was my thoughts as well and probable recommendation for the rest of the team.  Much appreciated!