Both scalability, performance and future expansion needs. I’m not sure how to break down the Disk Size for the TempDB, .db files and Transaction log files with the estimate you’ve provided below. The Primary Site in a hierarchy (up to 25k clients) w/ co-located sql server). Seem reasonable? Initial size5120# Clients577DB size pr. client5# processors4# cores2Memory16384 From: [email protected] To: [email protected] Subject: RE: [mssms] SQL Server Sizing Date: Fri, 31 Jan 2014 18:39:04 +0000
Less than 1000 clients I'd say you can get by with about any reasonably sized box. John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP From: [email protected] [mailto:[email protected]] On Behalf Of Dzikowski, Michael Sent: Friday, January 31, 2014 12:28 PM To: [email protected] Subject: RE: [mssms] SQL Server Sizing Are you looking for sizing so you can determine scaling or performance? Is the client count for that site going to grow? With the client count of ~570 – I’d guess you would be fine following some general guidelines: http://blogs.msdn.com/b/scstr/archive/2012/05/31/configuration_2d00_manager_2d00_2012_2d00_sizing_2d00_considerations.aspx Component ConfigMgr 2012 Suggested Minimum Configurations Site Servers CAS/Standalone Primary Site (up to 50,000 clients) w/co-located SQL Server: · 2 x Quad-Core (Intel Xeon E5504 or comparable) · 32GB of RAM · 350GB - 950GB total hard disk space* (OS, ConfigMgr, SiteDB, TempDB) Primary Site in a hierarchy (up to 25,000 clients) w/co-located SQL Server: · 2 x Dual-Core (Intel Xeon 5140 or comparable) · 16GB of RAM · 450GB - 1050GB total hard disk space* (OS, ConfigMgr, SiteDB, DistDB, TempDB) Primary Site in a hierarchy (up to 50,000 clients) w/remote SQL Server: · 2 x Dual-Core (Intel Xeon 5140 or comparable) · 8GB of RAM · 50GB total hard disk space* (OS, ConfigMgr) Remote SQL Server (to support above Primary Site): · 2 x Quad-Core (Intel Xeon E5504 or comparable) · 32GB of RAM · 425GB - 1225GB total hard disk space (OS, SiteDB, DistDB, TempDB) Michael Dzikowski Senior Systems Engineer | Ally Technical Infrastructure – Windows Hosting From: [email protected] [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Friday, January 31, 2014 1:25 PM To: [email protected] Subject: RE: [mssms] SQL Server Sizing I should point this out. Local SQL Install on my Primary. 1 DP as a FSP 2 other DPs will host content such as (Image content, Apps, Software updates) From: [email protected] To: [email protected] Subject: [mssms] SQL Server Sizing Date: Fri, 31 Jan 2014 12:21:48 -0600 I'm using Kent's ConfigMgr-SQL-recommendations spreadsheet found on this blog: http://blog.coretech.dk/kea/system-center-2012-configuration-manager-sql-recommendations/ The one thing I'm having difficulty with is determining the exact number of processors and cores. This particular client environment consists of the following: ~570 (servers & clients) - 4 Locations (1 Primary Site in WA, 2nd DP at Primary HQ in WA, 3rd DP in CA and a 4th DP in the Cloud. How do I estimate the number of cores and processors for this installation? Thanks, Brian Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
<<inline: image001.png>>
