How to know pages flushed at checkpoint?

The checkpoints at our system take way too long.
I'd like to figure out the number of dirty pages
flushed at a checkpoint and ideally which tables and indexes
they belong to.
Is there any way to do it?
Thanks a lotHi,
Use SQL Server performance monitor counters specifically SQL Server Buffer
Mgr: Checkpoint Pages/Sec and SQL Server Buffer Mgr: Lazy Writes/Sec
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
<news1_skh@.yahoo.com> wrote in message
news:61be40e2.0308150733.56398e08@.posting.google.com...
> The checkpoints at our system take way too long.
> I'd like to figure out the number of dirty pages
> flushed at a checkpoint and ideally which tables and indexes
> they belong to.
> Is there any way to do it?
> Thanks a lot|||Thanks - these counters are very helpful.
They, however, do not give an exact info on the number
of flushed pages - just an estimate.
The reason I'd like to have an exact info is this:
checkpoints on our Production database take very long (~20 sec).
The majority of the deta from the Production DB is replicated
on another server where checkpoints take ~0.2 sec.
I'd like to compare what exactly is flushed on both servers
to see if the difference is due to the hardware problems
or there is something I can do with the DB settings
to improve performance.
Any help is greatly appreciated...