What are dirty pages?
From: Alex (alex_remove_this__at_telus.net)
Date: 01/24/05
- Next message: Fuzail: "Converting MS Access to SQL Server 2K"
- Previous message: Anthony Thomas: "Re: Maintenance Plans - Master, MSDB, etc."
- Next in thread: Kalen Delaney: "Re: What are dirty pages?"
- Reply: Kalen Delaney: "Re: What are dirty pages?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 24 Jan 2005 04:54:39 GMT
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: Fuzail: "Converting MS Access to SQL Server 2K"
- Previous message: Anthony Thomas: "Re: Maintenance Plans - Master, MSDB, etc."
- Next in thread: Kalen Delaney: "Re: What are dirty pages?"
- Reply: Kalen Delaney: "Re: What are dirty pages?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|