Cleanup Frequency Maximum of Task Name Records Older Than Records to Hold Database Cleanup Jobs AirProxyLogs Alerts APNTracking DatabaseTaskSchedulerLogs System data is not affected by number of devices DataUsageLogs DeviceLocations DeviceLogs 30 Days Daily 1,800,000 14 Days Daily 250,000 60 Days Daily 10,000,000 30 Days Daily 300,000 30 Days Daily 100,000,000 180 Days Daily 6,000,000 365 Days Daily 50,000 30 Days Daily 1,000,000 30 Days Daily 100,000 30 Days Daily 1,000,000 30 Days Daily 1,000,000 30 Days Daily 60,000,000 180 Days Daily 12,000,000 180 Days Daily 36,000,000 30 Days Daily 10,000,000 30 Days Daily 1,000,000 365 Days Daily 500 365 Days Daily 500,000 30 Days Daily 1,000,000 DeviceStatistics If you keep historical data: ErrorChainLogs iOSDeviceInformation If you keep historical data: iOSDeviceNetworkInformation If you keep historical data: iOSInstalledApplications If you keep historical data: iOSInstalledCertificates If you keep historical data: iOSInstalledConfigurationProfiles If you keep historical data: iOSMDMSyncLogs iOSSecurityInfo If you keep historical data: LicensingLogs System data is not affected by number of devices MailMessageLogs MDMSyncLogs NotifyMDM Database Table Maintenance The Database Task Scheduler 9 PhoneLog 365 Days Recover License Seats Rollover Logs TextMessageLog Warnings Daily 4,000,000 - Daily - - Daily - 365 Days Daily 20,000,000 30 Days Daily 250,000 Stored Procedures Defragment Indexes - Weekly - Systems with More than 1000 Devices For systems accommodating more than 1,000 devices, the Maximum of Records to Hold recommendations listed above should be multiplied to arrive at a figure that accommodates multiples of one thousand devices.. For example, maximum records for the DataUsageLogs and AirProxyLogs tables should be configured as follows: 1,000 Device System 100,000,000 Maximum of Records to Hold 100,000,000 5,000 Device System 5 x 100,000,000 500,000,000 100,000 25,000 Device System 25 x 100,000,000 999,999,999 40,0
How to draft a Maintenance Database? An easy way to start completing your document is to download this Maintenance Database template now!
Every day brings new projects, emails, documents, and task lists, and often it is not that different from the work you have done before. Many of our day-to-day tasks are similar to something we have done before. Don't reinvent the wheel every time you start to work on something new!
Instead, we provide this standardized Maintenance Database template with text and formatting as a starting point to help professionalize the way you are working. Our private, business and legal document templates are regularly screened by professionals. If time or quality is of the essence, this ready-made template can help you to save time and to focus on the topics that really matter!
Using this document template guarantees you will save time, cost and efforts! It comes in Microsoft Office format, is ready to be tailored to your personal needs. Completing your document has never been easier!
Download this Maintenance Database template now for your own benefit!