Post reply

SQL Server 2005 sp2 Disk Space

  • July 7, 2008 at 11:48 am

    #77035

    I am running SQL Server 2005 sp2 (Enterprise Edition) on Windows Server 2003 sp1.

    Question:

    I have a database file that resides on a LUN on my SQL Server. I am running out of disk space and I would like to know what are the best practices for solving this problem. The datafile contain one table.

    I have additional disk space that can be presented to the server. However, before I do this I would like to ensure that I am configuring this properly.

  • July 8, 2008 at 1:06 am

    #839290

    So what is the real question?

    Your SAN guys haven't zoned enogh disk for your server?

    Have them expand it if it's full/too small.

    /Kenneth

  • July 8, 2008 at 7:22 am

    #839475

    Thanks. I thought that was the answer, just want to confirm with someone who feels my pain.:)

  • July 9, 2008 at 4:51 pm

    #840561

    You could also have them add another LUN and then you can add a data file to the new LUN. This wouldn't require downtime, like expanding a LUN would.

  • July 9, 2008 at 5:26 pm

    #840565

    Are you running out of space for the data file? Or, is your log file growing too large?

    We have seen a lot of posts recently about the transaction log growing too large - that is why I ask the question. If you are using full recovery and not backing up the transaction log on a regular schedule (i.e. every hour or more often), then that could be why you are running out of space.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • July 10, 2008 at 7:34 am

    #840806

    When I add the new datafile on the new LUN, will all the new data be added to new data file? Thanks for your response.

  • July 10, 2008 at 7:35 am

    #840807

    Datafile.

    Thanks for the reply

  • July 10, 2008 at 8:04 am

    #840842

    Thanks for the post, I found the answer that I needed. I am going to Alter my database and set a maximum size. This will prevent it from filling up my disk. I will add a new datafile (as suggested by Edogg) and all should be well, without any downtime. Thanks again.

  • July 10, 2008 at 10:11 am

    #840951

    New data will be added to the new data file according to Microsoft's proportional fill algorithm. This means SQL Server will write data to the data file with the most free space first.

  • July 10, 2008 at 10:12 am

    #840953

    Thank you.

Viewing 10 posts - 1 through 9 (of 9 total)

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