Wednesday, March 28, 2012

log flush counters

What is log flush ? I see a lot of these counters under the
SQLServer:Databases Object in perfmon...A log flush occurs when a transaction log buffer is written to disk. Data
are written to the database transaction log before the modified data pages
so that SQL Server can guarantee committed data are permanently persisted
and uncommitted data rolled back, if needed.
You can read more about the transaction log architecture in the SQL 2000
Books Online <architec.chm::/8_ar_da2_876t.htm>.
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OvXyaYpaEHA.1048@.tk2msftngp13.phx.gbl...
> What is log flush ? I see a lot of these counters under the
> SQLServer:Databases Object in perfmon...
>sql

No comments:

Post a Comment