Post reply

Database Allocation

  • January 15, 2008 at 5:20 pm

    #120109

    I use 'SQL Check' and it says that my database allocation is only 15% free,

    I check for each DB in sql management under their property, it has an unrestricted growth by 10%

    DO I need to increase my database allocation? and how?

    Please advice me on this.

    Thanks,

    Susan

  • January 15, 2008 at 5:53 pm

    #768417

    it all depends on whether your data is growing quickly or not. I would check in in a day or two and see how fast it's growing.

    If you have a slow time during the day - I'd schedule some time and add a big chunk of space if your data is growing. don't rely on the auto-grow if you can avoid it (and if you do - don't use a percentage - pick a fixed amount).

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • January 15, 2008 at 6:01 pm

    #768421

    I am not really sure which DB I should add but I suspect the finance DB

    the overall disk space is still about 200Gb

    how do I do it?

    thanks

  • January 15, 2008 at 6:13 pm

    #768423

    you can double-check if you have the default reports installed. From within SSMS, right-click on the database name, then Report>>Standard Reports>>Disk Usage.

    You'll have to do that database by database. Find the ones running out of space.

    I'd increment them by hand. Auto-growth never happens at a convenient time, so pick YOUR time, then grow the file.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • January 15, 2008 at 6:29 pm

    #768427

    Thanks

    do we need to make sure no users login to DB when I increase the file manually?

    thanks again

  • January 15, 2008 at 7:03 pm

    #768429

    It's going to tend to drop connection, so it would be a good idea not to do it when users are connecting. It's more like it will drastically slow everything down.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • January 15, 2008 at 7:07 pm

    #768431

    Thanks Matt

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

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