Post reply

Is it required to change the initial DB size ??

  • August 5, 2011 at 3:35 am

    #255314

    HI All,

    In my environment one database with 20 GB , The initila size is 9 GB , Space available is showing 0 mB , Autogrowth is 1MB unrestricted growth .

    It will effect any business or database crash ?? We can do any changes on that ??

    please advise ..

    Thanks ,

    Lavanya Sri

  • August 5, 2011 at 3:46 am

    #1364198

    That autogrow needs changing among other things. Grow the DB to maybe 25GB (if it's 20 and full, it needs to grow), then change the autogrow to something sensible like 500MB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 5, 2011 at 4:39 am

    #1364214

    Thanks Gila,

    My database in simple recivery model . i chnaged auto grow to 10 MB .

    I have one more issue with the tempdb .

    Tempdb--> tasks --> shrink-->files -->its showing Available free space is -163.31 MB (-2041%) ,

    what is mean that? i need to change any thing any settings

    all my databases in simple recovery model .

    Thanks

    Lavanya Sri.

  • August 5, 2011 at 4:50 am

    #1364218

    10MB is still not a sensible size. The database is 20GB in size. If it needs to grow by 200MB (not a large amount) you want it to do that in 20 chunks?

    Leave TempDB alone, you're not supposed to try and shrink it while in use, it can cause corruption (there is a kb article on this)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 5, 2011 at 5:02 am

    #1364227

    My question is what is mean by that negative value ???

  • August 5, 2011 at 5:07 am

    #1364229

    Errors in the space used algorithms. Upgrade to at least SP3, they're fixed by then.

    It's not really a problem, if it bothers use use DBCC UPDATEUSAGE

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

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