Thursday, December 20, 2012 1:59 PM
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?
Thursday, December 20, 2012 7:16 PMModerator
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.
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 PMThanks Mike, that was my thoughts as well and probable recommendation for the rest of the team. Much appreciated!