Does a heavy used database go through being locked up as it autogrows ?Any users that update or insert new rows after the user who initiated an
autogrow will wait until the growth is finished. If they are only selecting
there is no issue.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Hassan" <hassan@.hotmail.com> wrote in message
news:O2Frv7rFIHA.1316@.TK2MSFTNGP02.phx.gbl...
> Does a heavy used database go through being locked up as it autogrows ?
>|||If it is the trasaction log that is growing and and the users are doing
anything that generates a log record, it can look like the system is
hanging.
"Hassan" <hassan@.hotmail.com> wrote in message
news:O2Frv7rFIHA.1316@.TK2MSFTNGP02.phx.gbl...
> Does a heavy used database go through being locked up as it autogrows ?
>|||Hassan;
This KB article has good info on the autogrow behavior and its potential
impact on concurrency.
Linchi
"Hassan" wrote:
> Does a heavy used database go through being locked up as it autogrows ?
>
>|||Linchi,
Which KB article would that be? :)
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:2E2D0152-266B-459A-A542-6C37A24A8AE3@.microsoft.com...
> Hassan;
> This KB article has good info on the autogrow behavior and its potential
> impact on concurrency.
> Linchi
> "Hassan" wrote:
>> Does a heavy used database go through being locked up as it autogrows ?
>>|||Oops! http://support.microsoft.com/kb/315512/
Linchi
"Andrew J. Kelly" wrote:
> Linchi,
> Which KB article would that be? :)
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:2E2D0152-266B-459A-A542-6C37A24A8AE3@.microsoft.com...
> > Hassan;
> >
> > This KB article has good info on the autogrow behavior and its potential
> > impact on concurrency.
> >
> > Linchi
> >
> > "Hassan" wrote:
> >
> >> Does a heavy used database go through being locked up as it autogrows ?
> >>
> >>
> >>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment