Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NemoMaximus

    Deploying problems with Tomcat on Ubuntu

    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...
  2. NemoMaximus

    Where has all the space disappeared?

    FYI... I had no problem at all upgrading from SP2 CTP to SP2a :) Its going to be interesting to see if this changes the behavior of my table growth...
  3. NemoMaximus

    Where has all the space disappeared?

    I have 10 %... That is not the problem...
  4. NemoMaximus

    Where has all the space disappeared?

    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...
  5. NemoMaximus

    Where has all the space disappeared?

    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...
  6. NemoMaximus

    Where has all the space disappeared?

    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...
  7. NemoMaximus

    Where has all the space disappeared?

    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...
  8. NemoMaximus

    Where has all the space disappeared?

    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...
  9. NemoMaximus

    Where has all the space disappeared?

    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...
  10. NemoMaximus

    Where has all the space disappeared?

    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.
  11. NemoMaximus

    Where has all the space disappeared?

    I have already done DBCC UPDATEUSAGE, didn't help...
  12. NemoMaximus

    Where has all the space disappeared?

    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 =...

Part and Inventory Search

Back
Top