none
Growing SCCM databate RRS feed

  • Question

  • Hi
    Our SCCM db is growing bigger and bigger, right now 60 gb..

    We are using SCCM 2007 R2 (SP2), running on Win 20008 R2, MS SQL 2008 R2 (SP1).
    We have around 600 computers in our network. I belive that db size is really to much for our small enviroment?

    I made a query to see the biggest tables in the DB:


    name data_kb index_kb blob_kb

    CI_ConfigurationItems 387128 17136 2829

    LU_SoftwareList 238456 146840 4647

    CI_SDMPackages 202488 57264 6869

    CI_SDMPackageRelations 130000 32776 9495

    LU_SoftwareHash 116104 46320 124125

    StatusMessageInsStrs 110792 154155 156157

    StatusMessages 97552 37384 198199

    SoftwareInventory 92328 26336 244245

    

    Does anyone have any ideas of what I should do to see what is causing that table to grow so rapidly and fix the problem?

    Thanks in advance

    Tuesday, August 7, 2012 7:30 AM

Answers

All replies

  • 60 GB for 600 clients is not normal. I would suggest you to call CSS (Microsoft support). Have you done any changes in the environment recently that is not a standard practice ? Some helpful stuff in the following links (have you already gone through those) 

    http://blogs.technet.com/b/configurationmgr/archive/2011/08/30/eliminating-slack-space-in-the-configmgr-2007-database.aspx

    http://blogs.technet.com/b/configurationmgr/archive/2009/01/27/troubleshooting-database-growth-issues-in-configuration-manager-2007.aspx


    Anoop C Nair - @anoopmannur :: MY Site:  www.AnoopCNair.com :: FaceBook:  ConfigMgr(SCCM) Page :: Linkedin:  Linkedin<

    Tuesday, August 7, 2012 7:45 AM
  • That is really to big for that amount of clients, have you configured the builtin maintence tasks?

    Also take a look at this blog post: http://blogs.technet.com/b/configurationmgr/archive/2009/01/27/troubleshooting-database-growth-issues-in-configuration-manager-2007.aspx?wa=wsignin1.0

    Tuesday, August 7, 2012 7:46 AM
  • Hi
    Our SCCM db is growing bigger and bigger, right now 60 gb..

    We are using SCCM 2007 R2 (SP2), running on Win 20008 R2, MS SQL 2008 R2 (SP1).
    We have around 600 computers in our network. I belive that db size is really to much for our small enviroment?

    I made a query to see the biggest tables in the DB:


    name data_kb index_kb blob_kb

    CI_ConfigurationItems 387128 17136 2829

    LU_SoftwareList 238456 146840 4647

    CI_SDMPackages 202488 57264 6869

    CI_SDMPackageRelations 130000 32776 9495

    LU_SoftwareHash 116104 46320 124125

    StatusMessageInsStrs 110792 154155 156157

    StatusMessages 97552 37384 198199

    SoftwareInventory 92328 26336 244245

    

    Does anyone have any ideas of what I should do to see what is causing that table to grow so rapidly and fix the problem?

    Thanks in advance

    If I sum all these table sizes, it's only 1374848 Kb so 1,3Gb , are you sure these are biggest table?
    Tuesday, August 7, 2012 8:32 AM
  • Good point..  Here is all the sizes.

    Sum of data_kb is 2111,7 mb and sum of index_kb is 542 mb?

    Am I missing some tables?

    name	data_kb	index_kb	blob_kb
    CI_ConfigurationItems	387128	17136	0
    LU_SoftwareList	238456	146840	0
    CI_SDMPackages	202488	57264	0
    CI_SDMPackageRelations	130000	32776	0
    LU_SoftwareHash	116104	46320	0
    StatusMessageInsStrs	110792	0	0
    StatusMessages	97552	37384	0
    SoftwareInventory	92328	26336	0
    LU_SoftwareCode	65784	32992	0
    INSTALLED_SOFTWARE_DATA	52264	13920	0
    StatusMessageAttributes	49520	26760	0
    Update_DetectionStatus	44208	17064	0
    Add_Remove_Programs_DATA	42056	0	0
    Update_ComplianceStatus	38712	12528	0
    RecentlyUsedApps_DATA	33000	9504	0
    CI_CurrentComplianceStatus	32416	728	0
    Policy	25992	0	0
    LU_MSProd	18592	6872	0
    PNP_DEVICE_DRIVER_DATA	18056	0	0
    CI_ContentFiles	17232	4232	0
    HinvChangeLog	15176	7808	0
    Services_DATA	14088	0	0
    System_Devices_DATA	14024	0	0
    SoftwareFile	13280	6232	0
    CI_Contents	11336	4288	0
    TableChangeNotifications	10888	0	0
    INSTALLED_SOFTWARE_MS_DATA	10824	3336	0
    Software_Updates_Extended_DATA	10512	1952	0
    SoftwareFilePath	10424	3504	0
    Power_Management_Dail_DATA	9688	0	0
    TaskExecutionStatus	9064	600	0
    CI_ConfigurationItemRelations_Flat	8432	4456	0
    CI_CurrentSettingsComplianceStatusDetail	8296	2400	0
    CollectionMembers	8240	5032	0
    CI_ConfigurationItemContents	7000	4112	0
    CI_UpdateCIs	6720	2296	0
    Operating_System_HIST	6384	0	0
    CI_CIUpdateSources	6064	2152	0
    Update_DetectionStatus_DD	5960	0	0
    CI_CICategories	5616	1448	0
    Logical_Disk_HIST	5576	0	0
    CI_CICategories_All	5472	1496	0
    CI_ComplianceHistory	5312	2680	0
    INSTALLED_SOFTWARE_HIST	5232	0	0
    CI_CIHash	5000	0	0
    SYSTEM_CONSOLE_USAGE_HIST	4928	0	0
    CI_ConfigurationItemRelations	4808	2560	0
    Update_ComplianceStatus_DD	4808	0	0
    SW_LICENSING_PRODUCT_HIST	4768	0	0
    USB_DEVICE_HIST	4744	0	0
    Netcard_HIST	4016	0	0
    Network_HIST	3912	0	0
    CI_LocalizedProperties	3840	568	0
    SYSTEM_CONSOLE_USER_HIST	3464	0	0
    Power_Settings_DATA	3392	0	0
    AUTOSTART_SOFTWARE_DATA	3264	0	0
    SoftwareProductMap	2712	1184	0
    CI_ConfigurationItemRelations_Flat_DD	2440	0	0
    CI_UpdateInfo	2440	0	0
    SoftwareProduct	2368	976	0
    Power_Management_Dail_DATA_DD	2184	0	0
    Computer_System_HIST	1984	0	0
    Add_Remove_Programs_HIST	1880	0	0
    CI_CICategories_All_DD	1864	0	0
    ClientOfferStatus	1784	744	0
    User_User_Group_Name_ARR	1744	0	0
    Netcard_DATA	1728	0	0
    CI_CICategories_DD	1672	0	0
    ResPolicyCollMap	1480	1016	0
    Add_Remove_Programs_DATA_DD	1472	0	0
    INSTALLED_SOFTWARE_DATA_Summary	1464	656	0
    AUTOSTART_SOFTWARE_HIST	1320	0	0
    USB_DEVICE_DATA	1312	272	0
    CI_CurrentComplianceStatusMachineInfo	1280	0	0
    SMS_Advanced_Client_S_DATA	1280	0	0
    PNP_DEVICE_DRIVER_DATA_DD	1224	0	0
    MachineGroupXRef	1144	0	0
    Processor_HIST	1128	0	0
    Network_DATA	1088	0	0
    BROWSER_HELPER_OBJECT_HIST	1040	0	0
    BROWSER_HELPER_OBJECT_DATA	1032	0	0
    LU_CPU	992	464	0
    ResPolicyMap	936	408	0
    SW_LICENSING_PRODUCT_DATA	936	0	0
    CI_AssignmentStatus	920	144	0
    LocalGroupMembers_DATA	912	0	0
    RecentlyUsedApps_DATA_DD	904	0	0
    USB_Controller_DATA	888	0	0
    CI_ContentPackages	864	144	0
    LocalGroupMembers_HIST	856	0	0
    Update_ComplianceSummary	848	328	0
    Services_HIST	800	0	0
    ClientKeyData	792	88	0
    Video_Controller_HIST	784	0	0
    PkgStatus	728	200	0
    OfferStatusSummaryDetail	720	0	0
    System_Devices_DATA_DD	712	0	0
    IDE_Controller_DATA	640	0	0
    Network_Client_DATA	632	0	0
    System_DISC	608	280	0
    ContentDPMap	536	0	0
    Add_Remove_Programs_64_DATA	528	0	0
    Power_Management_Mont_DATA	528	0	0
    CollectionMembers_DD	512	0	0
    CI_ConfigurationItems_DD	480	0	0
    CI_UpdateCIs_DD	480	0	0
    PolicyAssignment	456	144	0
    SYSTEM_CONSOLE_USAGE_DATA_DD	456	0	0
    Video_Controller_DATA	456	0	0
    NAP_System_Health_Age_DATA	448	0	0
    Sound_Devices_DATA	432	0	0
    INSTALLED_SOFTWARE_DATA_DD	400	0	0
    Services_DATA_DD	392	0	0
    FolderMembers	376	200	0
    Desktop_Monitor_HIST	368	0	0
    ResOfferCollMap	360	0	0
    Desktop_Monitor_DATA	352	0	0
    DiscItemAgents	352	0	0
    Update_DeploymentSummary	352	144	0
    Collections	344	96	0
    Network_Client_HIST	336	0	0
    Disk_DATA	320	0	0
    SoftwarePolicy	320	0	0
    ClientDeploymentState	312	144	0
    Modem_HIST	312	0	0
    Report	304	88	0
    ReportParameters	304	32	0
    Power_Settings_HIST	296	0	0
    CH_PolicyRequestHistory	280	0	0
    PkgPrograms	280	56	0
    Disk_HIST	272	0	0
    INSTALLED_SOFTWARE_MS_DATA_DD	272	0	0
    PkgServers	272	0	0
    ProgramOffers	264	104	0
    System_System_OU_Name_ARR	264	0	0
    Computer_System_DATA	248	0	0
    Operating_System_DATA	248	0	0
    Modem_DATA	240	0	0
    Processor_DATA	240	0	0
    SMSPackages	240	0	0
    Sound_Devices_HIST	240	0	0
    System_AUX_Info	240	96	0
    System_System_Group_Name_ARR	240	0	0
    CD_ROM_DATA	232	0	0
    Logical_Disk_DATA	232	0	0
    MachineIdGroupXRef	232	88	0
    Partition_DATA	232	0	0
    SecurityObjInstances	216	0	0
    PkgAccess	208	0	0
    Update_ScanStatus	208	64	0
    Collection_Rules	192	32	0
    CI_AssignmentTargetedCIs	184	40	0
    InventoryClassProperty	184	40	0
    User_DISC	184	32	0
    System_DATA	176	0	0
    DepPolicyAssignment	168	0	0
    SMSPackageHash	168	0	0
    SYSTEM_CONSOLE_USER_DATA	168	0	0
    PC_BIOS_DATA	160	0	0
    NAP_CLIENT_DATA	152	0	0
    CD_ROM_HIST	144	0	0
    CH_ClientSummary	144	0	0
    CH_ClientSummaryHistory	144	0	0
    Collection_EvaluationAndCRCData	144	0	0
    LocalGroupMembers_DATA_DD	144	0	0
    LocalizedNameLookup	144	0	0
    OfferNotification	144	0	0
    PC_Memory_DATA	144	0	0
    PC_Memory_HIST	144	0	0
    Power_Capabilities_DATA	144	0	0
    Power_Settings_DATA_DD	144	0	0
    SMSProcParameters	144	0	0
    Summarizer_ComponentTallys	144	0	0
    System_Enclosure_DATA	144	0	0
    USB_DEVICE_DATA_DD	144	0	0
    User_User_OU_Name_ARR	144	0	0
    PkgNotification	136	0	0
    System_Resource_N_ARR	128	72	0
    AttributeMap	120	40	0
    System_MAC_Addres_ARR	120	64	0
    CI_CategoryInstances	96	40	0
    ClientHealthState	96	32	0
    LU_Category	96	64	0
    CI_SDMPackageLocalizedData	88	16	0
    INSTALLED_SOFTWARE_MS_HIST	88	0	0
    LU_MSProd_DD	88	0	0
    OfferStatusSummary	88	32	0
    SSL_CONFIGURATIONS_DATA	88	0	0
    Software_Updates_Extended_HIST	80	0	0
    Motherboard_DATA	72	0	0
    ResPolicyChange	72	0	0
    Software_Updates_Extended_DATA_DD	72	0	0
    SYSTEM_CONSOLE_USAGE_DATA	72	0	0
    AMT_Agent_DATA	64	0	0
    ClientOfferStatus_DD	64	0	0
    Collection_Rules_SQL	64	0	0
    Collection_SubCollections	64	32	0
    DataItemProperty	64	0	0
    FileUsageSummaryIntervals	64	0	0
    GroupMap	64	32	0
    LU_HardwareRequirements	64	32	0
    MonthlyUsageSummary	64	48	0
    Netcard_DATA_DD	64	0	0
    Network_DATA_DD	64	0	0
    SysResList	64	32	0
    WorkstationStatus_DATA	64	0	0
    AUTOSTART_SOFTWARE_DATA_DD	56	0	0
    CI_CategoryInstances_Flat	56	16	0
    CollectionOfferList	56	0	0
    InventoryClass	56	16	0
    Partition_HIST	56	0	0
    Power_Capabilities_HIST	56	0	0
    ScanPackage_Version_DATA	56	16	0
    SMS_Advanced_Client_S_DATA_DD	56	0	0
    System_IP_Address_ARR	56	0	0
    Add_Remove_Programs_64_HIST	48	0	0
    CI_CIAssignments	48	32	0
    CI_CurrentComplianceStatus_DD	48	0	0
    CI_LocalizedProperties_DD	48	0	0
    CollectionNotifications	48	24	0
    DataItem	48	16	0
    Folders	48	16	0
    LU_CAL_ProductList	48	32	0
    MeterData	48	32	0
    OfferStatusInfo	48	0	0
    PropertyDisplayNode	48	16	0
    Queries	48	0	0
    SCSI_Controller_DATA	48	0	0
    SMSProcedures	48	16	0
    SR_ClientMessageStats	48	0	0
    Summarizer_Components	48	16	0
    SupportedPlatforms	48	0	0
    SW_LICENSING_SERVICE_DATA	48	0	0
    System_IP_Subnets_ARR	48	0	0
    Windows_Update_Agent__DATA	48	0	0
    Virtual_Machine__64__DATA	48	0	0
    CI_LocalizedCategoryInstances	40	0	0
    Collection_Maint	40	0	0
    Collection_MemberChg_Notif	40	0	0
    MeterRules	40	16	0
    Parallel_Port_DATA	40	0	0
    Power_Management_Mont_DATA_DD	40	0	0
    ResyncPolicy	40	0	0
    Sites_DATA	40	0	0
    SoftwareInventoryStatus	40	0	0
    Summarizer_SiteSystem	40	0	0
    TS_References	40	0	0
    VULNERABILITY_DEF	40	0	0
    AIProxy	32	16	0
    Boundary	32	16	0
    BROWSER_HELPER_OBJECT_DATA_DD	32	0	0
    CEP_ServiceWindows	32	16	0
    CI_Types	32	16	0
    CI_UpdateSources	32	16	0
    ClientOfferSummary	32	0	0
    CollectionOfferListAC	32	0	0
    ConversionRules	32	16	0
    CustomSeverityReference	32	16	0
    DiscoveryArchitectures	32	16	0
    DPNotification	32	0	0
    DrillThroughColumns	32	0	0
    EULA_Content	32	16	0
    EULA_LocalizedContent	32	16	0
    FileUsageSummary	32	16	0
    IDE_Controller_DATA_DD	32	0	0
    InventoryClassContext	32	16	0
    LocaleFallback	32	16	0
    Logical_Disk_DATA_DD	32	0	0
    MeteredUsers	32	16	0
    NAP_ErrorCodeDescription	32	0	0
    PkgProgramOS	32	16	0
    PropertyDisplayProps	32	16	0
    RoamingBoundaryADSite	32	16	0
    RoamingBoundaryIPSubnet	32	16	0
    Sound_Devices_DATA_DD	32	0	0
    SR_StateNames	32	0	0
    SR_SummaryTasks	32	16	0
    SummarizationInterval	32	16	0
    SW_LICENSING_PRODUCT_DATA_DD	32	0	0
    SYSTEM_CONSOLE_USER_DATA_DD	32	0	0
    System_SMS_Assign_ARR	32	0	0
    System_SMS_Instal_ARR	32	0	0
    Templates	32	16	0
    UnknownSystem_DISC	32	16	0
    USB_Controller_DATA_DD	32	0	0
    WOLScheduleMap	32	16	0
    VULNERABILITY_DETAIL_DEF	32	16	0
    ResOfferCollMapChg_Notif	24	0	0
    ResPolicyCollMapChg_Notify	24	0	0
    ActiveDirectoryDiscoveryMetaData	16	0	0
    Add_Remove_Programs_64_DATA_DD	16	0	0
    Agents	16	0	0
    AI_Generic	16	0	0
    AIHinvClass	16	0	0
    AMT_Agent_DATA_DD	16	0	0
    AMT_Agent_HIST	16	0	0
    AMT_PowerScheme	16	0	0
    AMT_Profile	16	0	0
    ArchitectureMap	16	0	0
    BootImgPkg_References	16	0	0
    CD_ROM_DATA_DD	16	0	0
    CEP_CollectionExtendedProperties	16	0	0
    CEP_CollectionPolicies	16	0	0
    CEP_CollectionVariables	16	0	0
    CH_CollectionSummary	16	0	0
    CH_Settings	16	0	0
    CI_AssignmentCRCs	16	0	0
    CI_CategoryInstances_DD	16	0	0
    CI_CategoryInstances_Flat_DD	16	0	0
    CI_CIEULA	16	0	0
    CI_CIRelationTypeMapping	16	0	0
    CI_ComplianceSummary	16	0	0
    CI_LocalizedCategoryInstances_DD	16	0	0
    CI_LocalizedSettingType	16	0	0
    CI_RelationTypes	16	0	0
    CI_SDMErrors	16	0	0
    CI_TypeNames	16	0	0
    CI_UpdateCategorySubscription	16	0	0
    CI_ValidationSeverity	16	0	0
    ClientKeyDataCertExtend	16	0	0
    ClientKeyDataChangeLog	16	0	0
    Collection_DeltaRules	16	0	0
    Collection_Filter	16	0	0
    Collections_DD	16	0	0
    Computer_System_DATA_DD	16	0	0
    ConversionTypes	16	0	0
    DataItemContext	16	0	0
    DeletedItems	16	0	0
    DeletedMachines	16	0	0
    DepPkgPrograms	16	0	0
    Desktop_Monitor_DATA_DD	16	0	0
    DeviceClientCustomCodes	16	0	0
    DeviceDiscoveryTranslation	16	0	0
    DeviceHinvTranslation	16	0	0
    DeviceMPSettings	16	0	0
    DiscPropertyDefs	16	0	0
    DiscPropertyMap	16	0	0
    Disk_DATA_DD	16	0	0
    DistributionPointGroup	16	0	0
    DistributionPoints	16	0	0
    DPInfo	16	0	0
    DPStatusInfo	16	0	0
    IDE_Controller_HIST	16	0	0
    InstallMap	16	0	0
    InventoryAction	16	0	0
    Keyboard_DATA	16	0	0
    Keyboard_DATA_DD	16	0	0
    Keyboard_HIST	16	0	0
    LocalizedNameValue	16	0	0
    MeteringPolicy	16	0	0
    MeterRuleChanges	16	0	0
    Modem_DATA_DD	16	0	0
    Motherboard_DATA_DD	16	0	0
    Motherboard_HIST	16	0	0
    Mouse_DATA	16	0	0
    Mouse_DATA_DD	16	0	0
    Mouse_HIST	16	0	0
    NAP_CLIENT_DATA_DD	16	0	0
    NAP_CLIENT_HIST	16	0	0
    NAP_System_Health_Age_DATA_DD	16	0	0
    NAP_System_Health_Age_HIST	16	0	0
    Network_Client_DATA_DD	16	0	0
    NextIds	16	0	0
    OfferStatusIntervals	16	0	0
    Operating_System_DATA_DD	16	0	0
    Parallel_Port_DATA_DD	16	0	0
    Parallel_Port_HIST	16	0	0
    Partition_DATA_DD	16	0	0
    PC_BIOS_DATA_DD	16	0	0
    PC_BIOS_HIST	16	0	0
    PC_Memory_DATA_DD	16	0	0
    PDF_Package	16	0	0
    PDF_Program	16	0	0
    PeerDPStatusInfo	16	0	0
    PkgPrograms_DD	16	0	0
    PolicyCollMap	16	0	0
    PolicyCollMapFlat	16	0	0
    Power_Capabilities_DATA_DD	16	0	0
    Power_Management_Inso_DATA	16	0	0
    Power_Management_Inso_DATA_DD	16	0	0
    Processor_DATA_DD	16	0	0
    ProgramOffers_DD	16	0	0
    PropertyScopeProps	16	0	0
    ProtectedSiteSystem_ARR	16	0	0
    ReplicatedObjects	16	0	0
    ScanPackage_Version_DATA_DD	16	0	0
    ScanPackage_Version_HIST	16	0	0
    SchemaViewVersion	16	0	0
    SCSI_Controller_DATA_DD	16	0	0
    SCSI_Controller_HIST	16	0	0
    SecurityObjs	16	0	0
    SecurityObjUsers	16	0	0
    SecurityPermissions	16	0	0
    SettingsPolicy	16	0	0
    SetupInfo	16	0	0
    SiteControl	16	0	0
    SiteControlNotification	16	0	0
    Sites	16	0	0
    SMS_Advanced_Client_S_HIST	16	0	0
    SMSData	16	0	0
    SMSObjects	16	0	0
    SMSPackages_DD	16	0	0
    SQLTaskStatus	16	0	0
    SR_MissingMessageRanges	16	0	0
    SSL_CONFIGURATIONS_DATA_DD	16	0	0
    SSL_CONFIGURATIONS_HIST	16	0	0
    StatMsgModuleNames	16	0	0
    Summarizers_Status	16	0	0
    SW_LICENSING_SERVICE_DATA_DD	16	0	0
    SW_LICENSING_SERVICE_HIST	16	0	0
    System_DATA_DD	16	0	0
    System_DISC_DD	16	0	0
    System_Enclosure_DATA_DD	16	0	0
    System_Enclosure_HIST	16	0	0
    System_HIST	16	0	0
    System_IPv6_Addre_ARR	16	0	0
    System_SMS_Instal_ARR_DD	16	0	0
    System_System_Rol_ARR	16	0	0
    SystemHeartbeats	16	0	0
    Tape_Drive_DATA	16	0	0
    Tape_Drive_DATA_DD	16	0	0
    Tape_Drive_HIST	16	0	0
    TS_License_Key_Pack_DATA	16	0	0
    TS_TaskSequence	16	0	0
    TupleTypes	16	0	0
    Update_ScanStatus_DD	16	0	0
    Update_SyncStatus	16	0	0
    USB_Controller_HIST	16	0	0
    Video_Controller_DATA_DD	16	0	0
    Windows_Update_Agent__DATA_DD	16	0	0
    Windows_Update_Agent__HIST	16	0	0
    Virtual_Machine__64__DATA_DD	16	0	0
    Virtual_Machine__64__HIST	16	0	0
    WOLApplicableScheduleMap	16	0	0
    WOLClientTimeZones	16	0	0
    WOLStatusInfo	16	0	0
    WorkstationStatus_DATA_DD	16	0	0
    WSUSServerLocations	16	0	0
    VULNERABILITY_SCORE_DEF	16	0	0
    ActiveSync_Service_DATA	0	0	0
    ActiveSync_Service_DATA_DD	0	0	0
    ActiveSync_Service_HIST	0	0	0
    AdvertMemberCount	0	0	0
    AI_MVLS	0	0	0
    AI_NON_MS_LICENSE	0	0	0
    AI_UploadQueue	0	0	0
    AMT_802xProfile	0	0	0
    AMT_ACLs	0	0	0
    AMT_AuditPolicy	0	0	0
    AMT_Cert	0	0	0
    AMT_MachineClientCert	0	0	0
    AMT_MachineProperties	0	0	0
    AMT_OTPs	0	0	0
    AMT_ProvisionAccounts	0	0	0
    AMT_Realms	0	0	0
    AMT_WirelessProfile	0	0	0
    AttributeMap_DD	0	0	0
    CAL_Device	0	0	0
    CAL_Device_DD	0	0	0
    CAL_History	0	0	0
    CAL_User	0	0	0
    CAL_User_DD	0	0	0
    CEP_PowerConfig	0	0	0
    CI_ContentPackages_Unverified	0	0	0
    CI_UpdateSources_DD	0	0	0
    ClientModeReadiness	0	0	0
    ClientUpdateOfferStatus	0	0	0
    CollectedFiles	0	0	0
    Collection_Copies	0	0	0
    Connected_Device_DATA	0	0	0
    Connected_Device_DATA_DD	0	0	0
    Connected_Device_HIST	0	0	0
    Dashboard	0	0	0
    DashboardReports	0	0	0
    Device_CertificateInfo_DATA	0	0	0
    Device_CertificateInfo_DATA_DD	0	0	0
    Device_CertificateInfo_HIST	0	0	0
    Device_Certificates_DATA	0	0	0
    Device_Certificates_DATA_DD	0	0	0
    Device_Certificates_HIST	0	0	0
    Device_Computer_Syste_DATA	0	0	0
    Device_Computer_Syste_DATA_DD	0	0	0
    Device_Computer_Syste_HIST	0	0	0
    Device_Display_DATA	0	0	0
    Device_Display_DATA_DD	0	0	0
    Device_Display_HIST	0	0	0
    Device_FileSystem_DATA	0	0	0
    Device_FileSystem_DATA_DD	0	0	0
    Device_FileSystem_HIST	0	0	0
    Device_Memory_DATA	0	0	0
    Device_Memory_DATA_DD	0	0	0
    Device_Memory_HIST	0	0	0
    Device_Network_DATA	0	0	0
    Device_Network_DATA_DD	0	0	0
    Device_Network_HIST	0	0	0
    Device_OS_Information_DATA	0	0	0
    Device_OS_Information_DATA_DD	0	0	0
    Device_OS_Information_HIST	0	0	0
    Device_OwnerInformation_DATA	0	0	0
    Device_OwnerInformation_DATA_DD	0	0	0
    Device_OwnerInformation_HIST	0	0	0
    Device_PhoneIdent_DATA	0	0	0
    Device_PhoneIdent_DATA_DD	0	0	0
    Device_PhoneIdent_HIST	0	0	0
    Device_Power_DATA	0	0	0
    Device_Power_DATA_DD	0	0	0
    Device_Power_HIST	0	0	0
    Device_UserInformation_DATA	0	0	0
    Device_UserInformation_DATA_DD	0	0	0
    Device_UserInformation_HIST	0	0	0
    DeviceClientDeploymentState	0	0	0
    DeviceClientHealthState	0	0	0
    DeviceSettingItems	0	0	0
    DeviceSettingPackageItems	0	0	0
    DeviceSettingPackages	0	0	0
    GroupMap_DD	0	0	0
    ImageDeploymentAgent	0	0	0
    INSTALLED_EXECUTABLE_DATA	0	0	0
    INSTALLED_EXECUTABLE_DATA_DD	0	0	0
    INSTALLED_EXECUTABLE_HIST	0	0	0
    LU_CAL_ProductList_DD	0	0	0
    LU_Category_DD	0	0	0
    LU_Category_Local	0	0	0
    LU_Category_Local_DD	0	0	0
    LU_CPU_DD	0	0	0
    LU_CPU_Local	0	0	0
    LU_HardwareRequirements_DD	0	0	0
    LU_HardwareRequirements_Local	0	0	0
    LU_HardwareRequirements_Local_DD	0	0	0
    LU_SoftwareCode_DD	0	0	0
    LU_SoftwareHash_DD	0	0	0
    LU_SoftwareList_DD	0	0	0
    LU_SoftwareList_Local	0	0	0
    LU_SoftwareList_Local_DD	0	0	0
    MEP_MachineExtendedProperties	0	0	0
    MEP_MachinePolicies	0	0	0
    MEP_MachineVariables	0	0	0
    ObjectCategory	0	0	0
    PatchStatusSummary	0	0	0
    PeerDPPkgMap	0	0	0
    PeerDPPkgPolicy	0	0	0
    PeerDPPolicy	0	0	0
    PeerDPResMap	0	0	0
    PeerDPResMapChg_Notif	0	0	0
    PendingRegistrationData	0	0	0
    PkgRuleExpressions	0	0	0
    PkgStatus_VirtualApp	0	0	0
    Quar_ClientRestrictionHistory	0	0	0
    Quar_ClientRestrictionSummary	0	0	0
    Quar_QuarantineCIs	0	0	0
    Quar_RestrictionErrorSummary	0	0	0
    QueriableObjectColumns	0	0	0
    QueriableObjectRelations	0	0	0
    QueriableObjects	0	0	0
    RoamingBoundaryIPRange	0	0	0
    RoamingBoundaryIPv6Prefix	0	0	0
    SiteBoundaryADSite	0	0	0
    SiteBoundaryIPSubnet	0	0	0
    SiteNotification	0	0	0
    Sites_DD	0	0	0
    SiteWork	0	0	0
    SMS_Power_Config_DATA	0	0	0
    SMS_Power_Config_DATA_DD	0	0	0
    SOFTWARE_SHORTCUT_DATA	0	0	0
    SOFTWARE_SHORTCUT_DATA_DD	0	0	0
    SOFTWARE_SHORTCUT_HIST	0	0	0
    Software_Updates_DATA	0	0	0
    Software_Updates_DATA_DD	0	0	0
    Software_Updates_HIST	0	0	0
    StateMigration	0	0	0
    StateMigrationAssociation	0	0	0
    StateMigrationAssociationUsers	0	0	0
    System_IPv6_Prefi_ARR	0	0	0
    System_IPX_Addres_ARR	0	0	0
    System_System_Container_Name_A	0	0	0
    TS_License_Key_Pack_DATA_DD	0	0	0
    TS_License_Key_Pack_HIST	0	0	0
    UpdatePackages	0	0	0
    UpdateRelations	0	0	0
    UpdatesSummary	0	0	0
    User_Group_DISC	0	0	0
    User_User_Container_Name_ARR	0	0	0
    Virtual_Application_Packages_DATA	0	0	0
    Virtual_Application_Packages_DATA_DD	0	0	0
    Virtual_Application_Packages_HIST	0	0	0
    Virtual_Applications_DATA	0	0	0
    Virtual_Applications_DATA_DD	0	0	0
    Virtual_Applications_HIST	0	0	0
    VirtualApp	0	0	0
    VULNERABILITY_DATA	0	0	0
    VULNERABILITY_DATA_DD	0	0	0
    VULNERABILITY_DETAIL_DATA	0	0	0
    VULNERABILITY_DETAIL_DATA_DD	0	0	0
    VULNERABILITY_DETAIL_HIST	0	0	0
    VULNERABILITY_DETAIL_SUMM	0	0	0
    VULNERABILITY_HIST	0	0	0
    VULNERABILITY_SUMM	0	0	0

    Tuesday, August 7, 2012 8:55 AM
  • Could you send the result of this query on your SCCM database?

    USE sccmdatabasename

    exec sp_spaceused


    • Edited by jdulongc Tuesday, August 7, 2012 9:33 AM
    Tuesday, August 7, 2012 9:32 AM
  • Could you send the result of this query on your SCCM database?

    USE sccmdatabasename

    exec sp_spaceused


    reserved data index_size unused

    66912392 KB 65397176 KB 1386920 KB 128296 KB

    Tuesday, August 7, 2012 9:44 AM
  • That is really to big for that amount of clients, have you configured the builtin maintence tasks?

    Also take a look at this blog post: http://blogs.technet.com/b/configurationmgr/archive/2009/01/27/troubleshooting-database-growth-issues-in-configuration-manager-2007.aspx?wa=wsignin1.0

    Yes I have maint. tasks running. And I checked that link before but it didnt help me :(

    Really strange that my tables are not so big, not compare to the DB size.

    Tuesday, August 7, 2012 9:57 AM
  • Your backups are ok?
    Tuesday, August 7, 2012 10:00 AM
    • Marked as answer by Sabrina Shen Monday, August 20, 2012 3:56 AM
    Tuesday, August 7, 2012 10:30 AM
    Moderator