managementpoint
Slow Software Center search results
Currently Software Center will use WMI to query all available software for the computer, then it will ask the management point for user assigned apps.
If your computer is a bit slow/old the wait time checking WMI can be painful. You can check this on the client log SCNotify_MONASH@%username%_1.log
Please vote for my Uservoice - https://configurationmanager.uservoice.com/forums/300492-ideas/suggestions/39082435-speed-up-software-centre-searches-by-returning-use
If your SQL is slow you have another problem.. You can check this on the MP UserService.log - Search for GetFilteredApplications.
SQL Fixes:
Set the right compatibility level - https://support.microsoft.com/en-au/help/3196320/sql-query-times-out-or-console-slow-on-certain-configuration-manager-d
Reindex right - https://www.scconfigmgr.com/2017/01/03/configuration-manager-sql-database-maintenance/
Bad Fat mifs in a multiple user environment
If you are getting alot of error 2719 under SMS_INVENTORY_DATA_LOADER in a multiple user enviroment such as a lab of computers consider tweaking the data you are collecting.
Inventory Data Loader failed to process the file G:Program FilesMicrosoft Configuration Managerinboxesauthdataldr.boxProcessH5CCBXME.MIF because it is larger than the defined maximum allowable size of 5000000.
Solution:
Increase the maximum allowable size, which is defined in the registry key HKLMSoftwareMicrosoftSMSComponentsSMS_INVENTORY_DATA_LOADERMax MIF Size (the default is 5 MB), and wait for Inventory Data Loader to retry the operation.
Solution is not increasing the maximum allowable size and make your DB massive.
In a multiple user environment the class that will be expanding those mifs is the 'CCM_RecentlyUsedApps'.
To cut the fat go to the Administration pane in SCCM 2012, then Client Settings. Right click 'Default Client Settings' and choose properties.
In the new window click 'Hardware Inventory'
Click 'Set Classes'
Search for 'CCM_RecentlyUsedApps', expand it. Is up to decide what you really need but we have deseleted the following.
Powershell script to clean up IIS's log file mess
Management Point's rely heavily on IIS and IIS loves to log a lot which will fill up your hard drive. Here's a script that deletes logs older than 14 days. Location and amount of days can be changed easily.
We have ours scheduled to run monthly on site systems using IIS.