How to Find the Size of a Maximizer Database
There are multiple ways of finding the size of an existing Maximizer database. This information is useful if you are moving to a new server, or migrating from an On-Premise installation to Maximizer CRM Live.
Here are some of the ways to check the size of your database:
- Using SSMS you can enable object explorer detail from Edit or View menu, and click on the database name, it will show you the database size in the right hand section.
- You can go to the default data location folder for your SQL server and right click on the properties of your .mdf folder and .ldf folder to see the size
- You can run the following query against your database in SQL server
database_name = DB_NAME(database_id)
, log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
, row_size_mb = CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
, total_size_mb = CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2))
FROM sys.master_files WITH(NOWAIT)
WHERE database_id = DB_ID() -- for current db
GROUP BY database_id