Home Forums SQL Server 2008 SQL Server 2008 - General File group is running out of space frequently. RE: File group is running out of space frequently.

  • September 1, 2015 at 3:09 pm

    #1823826

    EasyBoy (9/1/2015)

    Thanks for your prompt response. I understand that we can't limited to growth. But, this is how they implemented tempdb. According to technet.microsoft if we have 200 MB or more then filegrowth should be 10%. Can you please suggest what would be the advisable size?

    https://technet.microsoft.com/en-us/library/ms175527(v=sql.105).aspx

    Thanks again for your help.

    This is one case where you should ignore Technet! Do as Gail says!


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]