SQL Server Performance Forum – Threads Archive
Database Size Issue
Dear all I am new for SQL Server. There is a urgent issue I need to cope with. Before I re-calculate the database size in EM, there is still has 850M size, however, after I recalculate the database, the result becamce 0M remain in database. But I can still insert data in this database. What happen to the database !!! P.S. My databaes vesion is 6.5 Thanks in advance Kwan22 May 2004
At home I don’t have 6.5 documentation, try with sp_spaceused in QA.
Since EM is a GUI tool, sometimes give wrong information.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
I believe you’re monitoring the free space from enterprise manager (GUI tool) which is flaky and as mentioned by Luis run the SP_SPACEUSED from Isql(query) window and run SP_SPACEUSED @UPDATEUSAGE=’true’ in order to get accurate results. Use this undocumented stored procedures using MASTER database:
EXEC sp_MSforeachtable @command1="print ‘?’ sp_spaceused(‘?’)" Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Dear Thanks for all your advise. I think the EM is wrong. And I got the right answer by using sp_spaceused command Regards Kwan
24 May 2004
]]>