February 23, 2016 at 7:26 am
Hi
We have Production and Archival DB for our web application.
Production DB contains more records than the Archival DB as we have started archival process very lately and the archival process is an On-Demand activity.
In this scenario, the archival DB's size is larger than the size of the Production DB.
App_PROD: Record count: 2053484, Size: 168747.50 MB
App_ARCH_PROD: Record count: 1995618, Size: 291496.00 MB
Why there is an huge difference when the no. of records are low in Archival DB when comparing to Prod DB?.
Let me know.
Thanks in Advance.
Venkatroyal
February 23, 2016 at 7:51 am
Any available space in the files?
-- Gianluca Sartori
February 23, 2016 at 8:22 am
I don't understand. Available space in the file?.
Is there SQL statement or SQL System SP's you can tell me , so that i can provide the information required.
Venkatroyal
February 23, 2016 at 8:41 am
sp_spaceused
This will tell you how much unallocated space you have in the database.
-- Gianluca Sartori
February 24, 2016 at 7:55 am
Hi,
Find below the output from sp_spaceused sql.
Prod
database_name database_size unallocated space
APP_PROD 169344.50 MB 2.56 MB
reserved data index_size unused
112670144 KB 112641192 KB 13320 KB 15632 KB
Archive
database_name database_size unallocated space
APP_ARCH_PROD 298282.81 MB 5.33 MB
reserved data index_size unused
301607600 KB 301543640 KB 12824 KB 51136 KB
Let me know your feedback.
Venkatroyal
February 25, 2016 at 1:30 pm
Another method
In SSMS:
Expand Databases
R-click the DB
Click Reports
Click Disk Usage
At the bottom of the Disk Usage Report click the + by "Disk Space Used by Data Files".
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply