Transcript Infrastructure • 6 Primary Sites • 13 Secondary Sites • 250 Distribution Points PCs & Devices • ~300,000 clients • ~125,000 mobile devices Users • ~98k FTEs • ~82k.

Infrastructure
• 6 Primary Sites
• 13 Secondary Sites
• 250 Distribution Points
PCs & Devices
• ~300,000 clients
• ~125,000 mobile devices
Users
• ~98k FTEs
• ~82k Vendors
Unified Device
Mgmt. Site
~98K devices *
Redmond
Site 1
75k Clients
Redmond
Site 2
75k Clients
Active Directory
Federation
Server 2.0
AD
User Discovery
corp domains
MS Online
Directory Sync
(DirSync)
Intune
Subscription
Connector
Site role
North & South
America
35k Clients
Europe,
MidEast, Africa
40k Clients
Australia &
Asia
75k Clients
MS Online
Directory Services
(MSODS)
http://msdn.microsoft.com/en-us/library/dd758814(v=SQL.100).aspx
http://sdrv.ms/11oBObv
us/library/gg712697.aspx
http://technet.microsoft.com/en-
Database Indexing Resources - Ola Hallengren : http://ola.hallengren.com/
http://sdrv.ms/Z3wRRm
http://technet.microsoft.com/en-us/library/hh427336.aspx#BKMK_ModifyDatabaseConfig
http://sdrv.ms/14Up144
Table Name
NumOfRows DataSize (MB) DataSize (GB)
CI_CurrentComplianceStatusDetails
64,396,595
84,093
82.12
DRSSentMessages
20,599,266
71,458
69.78
DRSReceivedMessages
10,608,458
54,850
53.56
Logs
133,989,969
42,162
41.17
INSTALLED_SOFTWARE_DATA
35,430,685
38,749
37.84
Table Name
NumOfRows DataSize (MB) DataSize (GB) Index Maint
DRSSentMessages
20,599,266
71,458
69.78
19.62 hours
DRSReceivedMessages 10,608,458
54,850
53.56
9.87 hours
Table Name
NumOfRows DataSize (MB) DataSize (GB) Index Maint
DRSSentMessages
23,886
27
0.026
0 hours
DRSReceivedMessages
4,808
5
0.005
0 hours
Table Name
NumOfRows DataSize (MB) DataSize (GB)
CI_CurrentComplianceStatusDetails
64,396,595
84,093
82.12
Logs
133,989,969
42,162
41.17
INSTALLED_SOFTWARE_DATA
35,430,685
38,749
37.84
Services_HIST
52,213,928
22,828
22.29
Services_DATA
50,560,825
19,843
19.38
ReplicationGroup
SyncInterval
Degraded Failed Degraded Threshold
Retries Retries
(minutes)
Failed Threshold
(minutes)
Site Control Data
1
12
24
12
24
Hardware_Inventory
5
12
24
60
120
AlwaysOn Availability Group
SQL Cluster
(DC1SQLCLSTR)
SQL Cluster
(DC2SQLCLSTR)
Windows Failover Cluster (SCCMSQL)
DC1SCCMSQL01
DC2SCCMSQL01
DC1SCCMSQL02
DC2SCCMSQL02
Asynchronous Synchronization
DC1 Datacenter
DC2 Datacenter
Note: AlwaysOn Availability Groups only work as a database mirroring solution without auto failover
Custom SQL Replication reports for System Center 2012 Configuration Manager:
http://blogs.technet.com/b/system_center_in_action/archive/2012/05/02/customsql-replication-reports-for-system-center-2012-configuration-manager.aspx
Link for downloading custom SQL job and SSRS report:
http://sdrv.ms/10zD3T3
http://msdn.microsoft.com/en-us/library/ms189858.aspx
http://msdn.microsoft.com/sv-se/library/cc966523(en-us).aspx
http://blogs.technet.com/b/system_center_in_action
http://technet.microsoft.com/en-us/library/hh913620.aspx
http://technet.microsoft.com/en-us/library/hh925141.aspx
http://blogs.msdn.com/b/shitanshu