Post reply

Alert on database space issue in SQL server 2000

  • December 20, 2005 at 3:23 am

    #115789

    I am getting database space issue alert message one of my SQL server 2000 server. Basically there is no space issue on the database and when i execute sp_spaceused stored proc, it is returning the minus value for the unallocated database space.I have fixed this issue by running DBCC updateusage on the database, But again and again I am getting the above issue on the particular sever.Can any one suggest permanent resolution for the above problem.ThanksRajarajan Bangaru

  • December 20, 2005 at 8:41 am

    #610601

    It sounds like you've got a problem with inaccuracies in your indexes.  Is your application frequently dropping and adding indexes? 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • December 20, 2005 at 9:05 am

    #610617

    Not to be difficult, but are you double checking to be sure you're looking at the right db? I've made that mistake before.

    Also, is there a lot of insert/update/delete activity on this database? Sometimes the indexes aren't correct for some reason.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply