Something special about Benjamin Session Objectives and Takeaways

Something special about Benjamin

Session Objectives and Takeaways

Unified Management Infrastructure @ Microsoft IT Infrastructure • 6 Primary Sites • 13 Secondary Sites • 250 Distribution Points PCs & Devices • ~300, 000 clients • ~125, 000 mobile devices Users • ~98 k FTEs • ~82 k Vendors Unified Device Mgmt. Site ~98 K devices * Redmond Site 1 75 k Clients Redmond Site 2 75 k Clients Active Directory Federation Server 2. 0 A D User Discovery corp domains MS Online Directory Sync (Dir. Sync) Intune Subscription Connector Site role North & South America 35 k Clients Europe, Mid. East, Africa 40 k Clients Australia & Asia 75 k Clients MS Online Directory Services (MSODS)

Database File Configuration

Disk Configuration http: //msdn. microsoft. com/en-us/library/dd 758814(v=SQL. 100). aspx

Database File Configuration http: //sdrv. ms/11 o. BObv

Database File Configuration

Database File Configuration – What we do

Backup & Recovery us/library/gg 712697. aspx http: //technet. microsoft. com/en-

Backup & Recovery

Backup & Recovery

SQL and CM Maintenance Task Recommendations

SQL and CM Maintenance Task Recommendations

Index Maintenance

Options for Index Maintenance

Index Maintenance – What we do Database Indexing Resources - Ola Hallengren : http: //ola. hallengren. com/

Moving a Config. Mgr Database

Database Moves – Pre Requisites http: //sdrv. ms/Z 3 w. RRm http: //technet. microsoft. com/en-us/library/hh 427336. aspx#BKMK_Modify. Database. Config

Database Moves – Lessons Learned

Database Moves

Database Size

Database Size http: //sdrv. ms/14 Up 144 Table Name Num. Of. Rows Data. Size (MB) Data. Size (GB) CI_Current. Compliance. Status. Details 64, 396, 595 84, 093 82. 12 DRSSent. Messages 20, 599, 266 71, 458 69. 78 DRSReceived. Messages 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

Database Size – Before & After Table Name Num. Of. Rows Data. Size (MB) Data. Size (GB) Index Maint DRSSent. Messages 20, 599, 266 71, 458 69. 78 19. 62 hours DRSReceived. Messages 10, 608, 458 54, 850 53. 56 9. 87 hours Table Name Num. Of. Rows Data. Size (MB) Data. Size (GB) Index Maint DRSSent. Messages 23, 886 27 0. 026 0 hours DRSReceived. Messages 4, 808 5 0. 005 0 hours

Database Size - Logging & History Information

Database Size Table Name Num. Of. Rows Data. Size (MB) Data. Size (GB) CI_Current. Compliance. Status. Details 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

Replication: States Defined

Replication Thresholds

Replication Thresholds Replication. Group Sync. Interval Degraded Failed Degraded Threshold Retries (minutes) Failed Threshold (minutes) Site Control Data 1 12 24 Hardware_Inventory 5 12 24 60 120

Replication: Panic Time?

Database Replica for Reporting

Database Replica for Reporting

Database Replica for Reporting

High Availability & Disaster Recovery

Note: Always. On Availability Groups only work as a database mirroring solution without auto failover

High Availability & Disaster Recovery

Reporting Service @ Microsoft

Reporting as Service – Future State

SQL Replication Status Daily Report 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

Measuring Replication Health Link for downloading custom SQL job and SSRS report: http: //sdrv. ms/10 z. D 3 T 3

In Review

Related Content from Microsoft IT

Resources http: //msdn. microsoft. com/en-us/library/ms 189858. aspx http: //msdn. microsoft. com/sv-se/library/cc 966523(en-us). aspx

More Information http: //blogs. technet. com/b/system_center_in_action http: //technet. microsoft. com/en-us/library/hh 913620. aspx http: //technet. microsoft. com/en-us/library/hh 925141. aspx http: //blogs. msdn. com/b/shitanshu

Complete your session evaluations today and enter to win prizes daily. Provide your feedback at a Comm. Net kiosk or log on at www. 2013 mms. com. Upon submission you will receive instant notification if you have won a prize. Prize pickup is at the Information Desk located in Attendee Services in the Mandalay Bay Foyer. Entry details can be found on the MMS website.

Resources