Re: What are dirty pages?
From: Alex (alex_removethis__at_healthmetrx.com)
Date: 01/24/05
- Next message: Michael C: "Re: SQL Server 2000 SP3 stops responding"
- Previous message: Wayne Snyder: "Re: procedure cache flush?"
- In reply to: Kalen Delaney: "Re: What are dirty pages?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 24 Jan 2005 09:59:24 -0800
Thank you Kalen for comprehensive answer.
Alex
"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:O5PCGidAFHA.3860@TK2MSFTNGP11.phx.gbl...
> No, a dirty page is one that has been modified since it was brought into
the
> buffer pool, so it does not match what is on disk. It may or may not be
> committed.
>
> Dirty pages can be written to disk before they are committed, which is
often
> a good thing, as in the case of a transaction that updates thousands of
> pages.
>
> When a transaction commits, the LOG records for that transaction are
written
> to disk, but not the data pages. The dirty data pages are written to disk
> whenever a checkpoint occurs (and when space is needed in the buffer pool,
> and a few other times), and it is basically totally asynchronous with
> transaction commit operations.
> --
> HTH
> ----------------
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
>
> "Alex" <alex_remove_this_@telus.net> wrote in message
> news:jc%Id.20865$Qb.12333@edtnps89...
> > BOL(ans other resourses) say that 'Buffer pages that contain
modifications
> > that have not been written to disk.'
> > My understanding is that they are those which transactions have already
> > been
> > commited and they are just waiting to be flushed from buffer pool out to
> > disk. Am I right?
> >
> > Thank you all
> >
> > Alex
> >
> >
>
>
- Next message: Michael C: "Re: SQL Server 2000 SP3 stops responding"
- Previous message: Wayne Snyder: "Re: procedure cache flush?"
- In reply to: Kalen Delaney: "Re: What are dirty pages?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
