Friday, March 9, 2012

'Primary filegroup is full

I have an application that receives the error that the primary filegroup is
full a couple of times at day. I can bump up the database size but I would
think having it set to grow at 10 percent I shouldn't have to worry about
this. I just looked and there is 3 percent of available space. How do I
make sure there is always available space?
ThanksNever set the DB to a % for autogrow since the size changes with each
growth. Determine what size in MB can be grown in about 10 seconds or less
and use that amount instead. But just make the data files large enough to
hold what you expect for a long time out and you should never need to use
autogrow. Do not shrink the database or turn on autoshrink.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Don" <Don@.discussions.microsoft.com> wrote in message
news:52A45F80-F8C3-4766-9F3C-D1BE2D3E9066@.microsoft.com...
>I have an application that receives the error that the primary filegroup is
> full a couple of times at day. I can bump up the database size but I
> would
> think having it set to grow at 10 percent I shouldn't have to worry about
> this. I just looked and there is 3 percent of available space. How do I
> make sure there is always available space?
> Thanks
>|||Be sure you checked "Enable Autogrowth" of your database in the Primary File
Group and then be sure that Maximum File Size is "Unrestricted File Growth"
if you do not wanna bother yourself with this issue again.
You can do these settings from the properties of your database.
And do neglect setting values of File Growth and Miximum File Size according
to your system needs. These settings affect SQL Server's performance
(especially for huge ones).
--
Ekrem Ã?nsoy
"Don" <Don@.discussions.microsoft.com> wrote in message
news:52A45F80-F8C3-4766-9F3C-D1BE2D3E9066@.microsoft.com...
>I have an application that receives the error that the primary filegroup is
> full a couple of times at day. I can bump up the database size but I
> would
> think having it set to grow at 10 percent I shouldn't have to worry about
> this. I just looked and there is 3 percent of available space. How do I
> make sure there is always available space?
> Thanks
>|||Don,
Pay attention to all of what Andrew is saying, it is important. Nothing, and
I mean nothing replaces knowing your enviornment and what your database
resource needs are.
If you allow growth (or shrinkage) you are fragmenting the partition/drive
your database resides on and will pay for it in performance.
Jay
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OlR4Lii8HHA.4420@.TK2MSFTNGP02.phx.gbl...
> Never set the DB to a % for autogrow since the size changes with each
> growth. Determine what size in MB can be grown in about 10 seconds or less
> and use that amount instead. But just make the data files large enough to
> hold what you expect for a long time out and you should never need to use
> autogrow. Do not shrink the database or turn on autoshrink.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Don" <Don@.discussions.microsoft.com> wrote in message
> news:52A45F80-F8C3-4766-9F3C-D1BE2D3E9066@.microsoft.com...
>>I have an application that receives the error that the primary filegroup
>>is
>> full a couple of times at day. I can bump up the database size but I
>> would
>> think having it set to grow at 10 percent I shouldn't have to worry about
>> this. I just looked and there is 3 percent of available space. How do I
>> make sure there is always available space?
>> Thanks
>|||Thanks for the help, so I went into Enterprise Manager and bumped up the size
for 4 GB to 5GB but get the error Error 5041 Modify File Failed File. It
does not exiist/
when trying to save the new setting
"Jay" wrote:
> Don,
> Pay attention to all of what Andrew is saying, it is important. Nothing, and
> I mean nothing replaces knowing your enviornment and what your database
> resource needs are.
> If you allow growth (or shrinkage) you are fragmenting the partition/drive
> your database resides on and will pay for it in performance.
> Jay
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OlR4Lii8HHA.4420@.TK2MSFTNGP02.phx.gbl...
> > Never set the DB to a % for autogrow since the size changes with each
> > growth. Determine what size in MB can be grown in about 10 seconds or less
> > and use that amount instead. But just make the data files large enough to
> > hold what you expect for a long time out and you should never need to use
> > autogrow. Do not shrink the database or turn on autoshrink.
> >
> > --
> > Andrew J. Kelly SQL MVP
> > Solid Quality Mentors
> >
> >
> > "Don" <Don@.discussions.microsoft.com> wrote in message
> > news:52A45F80-F8C3-4766-9F3C-D1BE2D3E9066@.microsoft.com...
> >>I have an application that receives the error that the primary filegroup
> >>is
> >> full a couple of times at day. I can bump up the database size but I
> >> would
> >> think having it set to grow at 10 percent I shouldn't have to worry about
> >> this. I just looked and there is 3 percent of available space. How do I
> >> make sure there is always available space?
> >>
> >> Thanks
> >>
> >
>
>|||Did you change the name of the file by mistake in the dialog? Have you
tried it again? If that doesn't work you might want to try and use ALTER
DATABASE instead.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Don" <Don@.discussions.microsoft.com> wrote in message
news:77A8F234-BD7D-4683-AB2E-FF0A8F9315B3@.microsoft.com...
> Thanks for the help, so I went into Enterprise Manager and bumped up the
> size
> for 4 GB to 5GB but get the error Error 5041 Modify File Failed File. It
> does not exiist/
> when trying to save the new setting
>
> "Jay" wrote:
>> Don,
>> Pay attention to all of what Andrew is saying, it is important. Nothing,
>> and
>> I mean nothing replaces knowing your enviornment and what your database
>> resource needs are.
>> If you allow growth (or shrinkage) you are fragmenting the
>> partition/drive
>> your database resides on and will pay for it in performance.
>> Jay
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:OlR4Lii8HHA.4420@.TK2MSFTNGP02.phx.gbl...
>> > Never set the DB to a % for autogrow since the size changes with each
>> > growth. Determine what size in MB can be grown in about 10 seconds or
>> > less
>> > and use that amount instead. But just make the data files large enough
>> > to
>> > hold what you expect for a long time out and you should never need to
>> > use
>> > autogrow. Do not shrink the database or turn on autoshrink.
>> >
>> > --
>> > Andrew J. Kelly SQL MVP
>> > Solid Quality Mentors
>> >
>> >
>> > "Don" <Don@.discussions.microsoft.com> wrote in message
>> > news:52A45F80-F8C3-4766-9F3C-D1BE2D3E9066@.microsoft.com...
>> >>I have an application that receives the error that the primary
>> >>filegroup
>> >>is
>> >> full a couple of times at day. I can bump up the database size but I
>> >> would
>> >> think having it set to grow at 10 percent I shouldn't have to worry
>> >> about
>> >> this. I just looked and there is 3 percent of available space. How
>> >> do I
>> >> make sure there is always available space?
>> >>
>> >> Thanks
>> >>
>> >
>>|||Thanks for the help, I did figure out what the issue was. The drive was set
as Fat32 (4 GB limit) so I had to change how the 300 GB drive was set.
Thanks
"Andrew J. Kelly" wrote:
> Did you change the name of the file by mistake in the dialog? Have you
> tried it again? If that doesn't work you might want to try and use ALTER
> DATABASE instead.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Don" <Don@.discussions.microsoft.com> wrote in message
> news:77A8F234-BD7D-4683-AB2E-FF0A8F9315B3@.microsoft.com...
> > Thanks for the help, so I went into Enterprise Manager and bumped up the
> > size
> > for 4 GB to 5GB but get the error Error 5041 Modify File Failed File. It
> > does not exiist/
> > when trying to save the new setting
> >
> >
> > "Jay" wrote:
> >
> >> Don,
> >>
> >> Pay attention to all of what Andrew is saying, it is important. Nothing,
> >> and
> >> I mean nothing replaces knowing your enviornment and what your database
> >> resource needs are.
> >>
> >> If you allow growth (or shrinkage) you are fragmenting the
> >> partition/drive
> >> your database resides on and will pay for it in performance.
> >>
> >> Jay
> >>
> >> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> >> news:OlR4Lii8HHA.4420@.TK2MSFTNGP02.phx.gbl...
> >> > Never set the DB to a % for autogrow since the size changes with each
> >> > growth. Determine what size in MB can be grown in about 10 seconds or
> >> > less
> >> > and use that amount instead. But just make the data files large enough
> >> > to
> >> > hold what you expect for a long time out and you should never need to
> >> > use
> >> > autogrow. Do not shrink the database or turn on autoshrink.
> >> >
> >> > --
> >> > Andrew J. Kelly SQL MVP
> >> > Solid Quality Mentors
> >> >
> >> >
> >> > "Don" <Don@.discussions.microsoft.com> wrote in message
> >> > news:52A45F80-F8C3-4766-9F3C-D1BE2D3E9066@.microsoft.com...
> >> >>I have an application that receives the error that the primary
> >> >>filegroup
> >> >>is
> >> >> full a couple of times at day. I can bump up the database size but I
> >> >> would
> >> >> think having it set to grow at 10 percent I shouldn't have to worry
> >> >> about
> >> >> this. I just looked and there is 3 percent of available space. How
> >> >> do I
> >> >> make sure there is always available space?
> >> >>
> >> >> Thanks
> >> >>
> >> >
> >>
> >>
> >>
>

No comments:

Post a Comment