How to Find SCCM Database Size using SQL Query
In this post, I will show you how to find SCCM database size using SQL query. SQL Server allows you to manually check the size of the SCCM database, including free space details. We know that each Configuration Manager site requires a supported SQL Server version and configuration to host the site database. Older versions of SQL Server installed for SCCM must be updated to recent version as they provide better performance. SQL Server is used to store information for Configuration Manager sites. Each site in a Configuration Manager hierarchy contains a site database and a server that is assigned the site database server role. You must be aware of the size of the SCCM database because occasionally, you may run out of the disk space. For example, the size of the report server database log file taking up most of the disk space is one of the most common problems ConfigMgr administrators run into. Luckily, you can shrink the size of SCCM reporting services log database. You might need to loo