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 look at the data being stored in the DB if your SCCM database is using up more disk space. The ConfigMgr database should not be shrunk because doing so would just reduce performance; instead, it is advised that you increase your disk space if necessary. If you do shrink it, run your database maintenance operations on it afterwards because your indexes will likely be fragmented.

http://forums.worldsamba.org/showthread.php?tid=31524

https://australiantravelforum.com/travel/showthread.php?tid=114380

http://hondaikmciledug.co.id/HRIS/showthread.php?tid=23&pid=25

https://socalireefer.com/forum/showthread.php?tid=308622

http://famstock.co.uk/showthread.php?tid=1

https://csgamearena.net/showthread.php?tid=35118

http://ordemdospsicologos.org/forum/showthread.php?tid=335&pid=5536

http://zinaramirez.com/mybb/thread-15010.html

https://remont.biz.pl/forum/thread-141517.html

https://forum.bedwantsinfo.nl/thread-150005.html

http://forum.inphtech.pt/viewtopic.php?t=195873

http://forum.inphtech.pt/viewtopic.php?t=178829

http://forum.inphtech.pt/viewtopic.php?t=196833

http://forum.inphtech.pt/viewtopic.php?t=208861

https://www.wirthling.com/forum/viewtopic.php?t=22518

https://www.wirthling.com/forum/viewtopic.php?t=20658

https://www.wirthling.com/forum/viewtopic.php?t=22519

https://www.wirthling.com/forum/viewtopic.php?t=22464

http://www.gartenwelt-oppl.at/forum/viewtopic.php?f=11&t=447520

http://www.gartenwelt-oppl.at/forum/viewtopic.php?f=11&t=448073


Determine the Size of ConfigMgr Database

There are two ways to determine the size of SCCM database: using SQL query and manually checking the database properties in SQL Server. Using a SQL query provides more details in the output, and you can even export the database size details to a file.


Some useful SQL queries that you can use with Configuration Manager are listed below:

  • SCCM SQL Query to Find Last Restart Time of Devices
  • SCCM SQL Query: Find Last Heartbeat Time Stamp of Clients
  • Find SCCM Application Deployment Details using SQL Query
  • Quickly List SCCM Packages using SQL Query | PowerShell


How to Find SCCM Database Size using SQL Query

Let’s go through the steps to find the size of SCCM database using a SQL query.

  • Launch the SQL Server Management Studio.
  • Connect to the Database Engine with your credentials.
  • Right-click SCCM Database and select New Query.
  • In the query window, enter the below SQL query and click Execute.
  • The query output shows the SCCM database size and file path details.


From the query output, you get the size of the SCCM database in MB along with following details:


  • DBName: The name of the SQL database that holds the ConfigMgr data.
  • FileSize (MB): The total size of the ConfigMgr Database in MB.
  • UsedSpace (MB): The total space utilized.
  • FreeSpace (MB): Free space remaining in SCCM database.
  • GrowthSpace (MB)

http://www.gartenwelt-oppl.at/forum/viewtopic.php?f=11&t=447533

https://forum.trapeza.ru/viewtopic.php?t=275632

https://forum.trapeza.ru/viewtopic.php?t=43265

https://forum.trapeza.ru/viewtopic.php?t=207018

https://forum.trapeza.ru/viewtopic.php?t=274747

http://theglobalfederation.org/viewtopic.php?id=116850

http://theglobalfederation.org/viewtopic.php?id=579031

http://imsf.ru/forum/index.php?topic=7170.0

http://imsf.ru/forum/index.php?topic=5458.0

http://imsf.ru/forum/index.php?topic=7126.0

http://www.hertha03-fz2.de/phpBB3/viewtopic.php?f=6&t=165617&p=266158

http://www.hertha03-fz2.de/phpBB3/viewtopic.php?f=9&t=301

http://www.hertha03-fz2.de/phpBB3/viewtopic.php?f=6&p=272473

http://www.hertha03-fz2.de/phpBB3/viewtopic.php?p=285

http://forums.lonelybitsgames.com/viewtopic.php?t=813830

http://forums.lonelybitsgames.com/viewtopic.php?t=823596

https://forums.lonelybitsgames.com/viewtopic.php?t=817769

https://forums.lonelybitsgames.com/viewtopic.php?t=801942

Check the Size of SCCM Database from SQL Server

If you want to avoid using a SQL query to find the size of SCCM database, you can manually check the database size from SQL server. To accomplish that, launch the SQL Server Management Studio and connect to Database Engine. Expand Database and right-click on ConfigMgr Database and select Properties.

On the Database Properties window of Configuration Manager database, select General option. On the right-hand side, you can see the size of the SCCM database along with total space available. The SQL collation details are also shown in the same window.


Read Next

  • How to Install SCCM Reporting Services Point | ConfigMgr SSRS
  • 3 Ways to Find SCCM Maintenance Windows for a Computer
  • 3 Useful WSUS Maintenance Options in Configuration Manager
  • How To Enable WSUS Cleanup in ConfigMgr – Bonus Guide

Comments

Post a Comment

Popular posts from this blog

The 10 Best Apartment Websites of 2019

Condo discoverer sites are prospering, with most destinations joined by Android and iOS applications for in a hurry get to. To abstain from passing up key highlights, be that as it may, it's ideal to concentrate on the sites themselves. Here's are the ten best sites to discover lofts, regardless of whether its a studio or a shabby 2 room. 1.Hotpads: Most Feature-Packed Apartment Finder  Naturally, this component rich site gives you a guide of the zone, with a rundown see close by. In the guide see, you select symbols of structures to see subtleties and photographs of explicit loft postings. Photographs additionally incorporate Google Street View. Worked in inquiry channels incorporate condo, value run, number of office setup showers, rental sorts, and property types. You can choose from rental kinds, for example, customary, sublet, corporate, and space for lease, just as from property types, for example, loft, apartment suite, duplex, house, and townhouse. On the of
Read more

The 10 Best Sites for Free Stock Images

On the off chance that you need to download free stock pictures to add to your site, blog, social profiles or whatever else, you need to realize where to search for them on the web. The best destinations have enormous libraries of astounding pictures in each classification conceivable that you can use for essentially anything by any stretch of the imagination—without expecting to give attribution on the off chance that you'd favor not. We scoured the web to locate the most elite. Examine the accompanying rundown with the expectation of complimentary stock photographs that will overwhelm you. 1.Unsplash: Crowdsourced Photos from Photograpehrs Around the World  Unsplash is a notable top choice, highlighting probably the most expert looking photography you'll discover anyplace on the web. The majority of its photographs originate from the liberal picture takers who give them to the network to use for nothing, no attribution fundamental (however valued). You can make your
Read more

ConfigMgr 2212 Technical Preview Update Details

There will be no ConfigMgr 2212 Technical Preview release. Yes, you heard it right: Microsoft skipped the 2212 technical preview release, and the next TP release will be version 2301. Typically, Microsoft releases a technical preview version every single month of the year. In the past, we also saw two technical preview releases in a month. But for the first time ever, there won’t be a technical preview release. On this blog, I have been covered the installation and new features all the versions of technical preview that have been released so far. Did you know that there have been 97 technical preview versions released by Microsoft so far? The two previous technical preview releases were TP 2211 and TP 2210 and version 2212 was expected in the month of December 2022. Here is an updated guide consisting of all the SCCM technical preview releases. https://www.tnfnorth.com/viewtopic.php?t=2830 http://tnfnorth.com/viewtopic.php?t=7189 http://tnfnorth.com/viewtopic.php?t=155931 https://tnfno
Read more