By executing this SQL query you will get the overall size of your database as well as the used and free space inside the database:
SELECTt.NAME AS TableName,s.Name AS SchemaName,p.rows AS RowCounts,SUM(a.total_pages) 8 AS TotalSpaceKB,SUM(a.used_pages) 8 AS UsedSpaceKB,(SUM(a.total_pages) - SUM(a.used_pages)) 8 AS UnusedSpaceKBFROMsys.tables tINNER JOINsys.indexes i ON t.OBJECT_ID = i.object_idINNER JOINsys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOINsys.allocation_units a ON p.partition_id = a.container_idLEFT OUTER JOINsys.schemas s ON t.schema_id = s.schema_idWHEREt.NAME NOT LIKE 'dt%'AND t.is_ms_shipped = 0 AND i.OBJECT_ID > 255GROUP BYt.Name, s.Name, p.RowsORDER BYt.Name
There is a data retention feature that helps manage your database size in SPDocKit. If you turn this feature on, the retention job will usually happen every day at the random time between 4AM and 5AM. However, even when our tool deletes old data from the tables, the SQL server will still use the same amount of disk space.
There are two parts of storage that are used by any database:
the data itself, stored in a database file (.MDF)
transaction logs, stored in log files (.LDF). (Check to see if there are any SPDocKit related entries in your Windows event logs.)
In order to reduce the database size you can do the following:
Open the Options wizard, select the Data Retention tab. Here is where you will see how your retention policies are defined.
You will see the Force Data Retention button, and next to that is an Execute button. Pressing this button will automatically delete old information, then attempt to shrink your database (the way this runs is determined by the settings in step 1).
If you are not running the latest version, you can do this manually:
Shrink the database by following these instructions.
Change the database to the Simple Recovery Model and perform a backup (This article explains the differences between SQL’s different recovery models).
To find out which version of SPDocKit you are using, please follow these steps:
From the File menu choose Help.
Your version will be written under About SPDocKit part of the screen.
This message is sometimes generated when there are insufficient rights given to an end user. To load User Profile Synchronization connections you need to do the following:
Start the User Profile Synchronization Service.
The account used to create a snapshot needs to be a member of the Administrators group of the User Profile Service Application and have Full Control access. This is done by adding them to the User Profile Service Administrators group using the “Administrators” button in SharePoint Central Administration > Application Management > Manage Service Applications.
All accounts taking a snapshot must have the same level of access.
For more information, please see the following article.