I have a major problem with deploying my application on my Tomcat 6.0.18 running Ubuntu Server 8.04... Or actually, I can deploy the application and it starts just fine the first time. But as soon as I restart Tomcat or restart the Ubuntu server the application fails to start... In catalina.out...
Well, I have done DBCC UPDATEUSAGE, no difference. And its not just that SQL Server has problem showing the correct size of the table, the physical size of the database is wrong. Yesterday, after my exercise of coping and truncating the table the database size went from 28 GB to about 5 Gb...
Well, I found this on Microsofts web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en
Seems to be just a small update for SP2a for those who already have SP2...
Yes, as far as I know all other tables are fine, at least the total size of the database is resonable when I exclude this table.
But this is the only table as well that I delete about 700000 records every night and recalculates them, and to me it feels like the deleted records is left in the...
I didn't know that... Microcrap... I hope the upgrade works anyway...
The table starts to grow directly, this is what have happen tonight:
2007-03-07
----------
Rows = 14673912
Reserved = 4512600 KB
Data = 3010040 KB
Index size = 1501888 KB
Unused = 672 KB
2007-03-08...
Yes, I know about that for SP2 CTP... I will upgrade to SP2a later this week...
Anyway, I did a test, copied all the records to another database, truncated the table and copied everything back, which resulted in:
Rows = 14673912
Reserved = 4512600 KB
Data = 3010040 KB
Index...
I knew that my calculation was not fully accurate, but still, it should give some kind of indication where we are headed. Anyway, I ran the script that you linked to and that showed that the table size should be about 5.5 GB, still a lot less then the 18.2 GB that SQL Server 2005 reports.
I'm...
Thanks! I will check into this, but I already have the SP2 CTP installed so I don't know if this will solve it.
But still, automatic grows gives you more unused space, my problem is that it reports that I have 18,2 Gb of used data when it should only be about 2,9 Gb according to my calculations.
I'm running SQL Server 2005 and one of my databases is eating up space and I have no idea why... My calculations of the required space is just not saying the same thing as the SQL Server reports. Have a look at this:
EXEC sp_spaceused MyTableName
Returns
-------
Name = MyTableName
Rows =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.