Prev: Remove Duplicate Rows
Next: Stats assessment, accurate?
From: RG on 11 Aug 2010 14:46
Does sql server maintain a view containing info on checkpoint activity? Like
when the checkpoints took place and how long they ran.

Thanks in advance
From: Erland Sommarskog on 11 Aug 2010 16:57
RG (RG(a)discussions.microsoft.com) writes:
> Does sql server maintain a view containing info on checkpoint activity?
> Like when the checkpoints took place and how long they ran.

No, but I believe that there are some performance counters.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: Amol Lembhe on 13 Aug 2010 03:11
not sure, May be you can look at default trace.

"Erland Sommarskog" wrote:

> RG (RG(a)discussions.microsoft.com) writes:
> > Does sql server maintain a view containing info on checkpoint activity?
> > Like when the checkpoints took place and how long they ran.
>
> No, but I believe that there are some performance counters.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
> .
>
From: RG on 13 Aug 2010 08:26
where is the default trace?

"Amol Lembhe" wrote:

> not sure, May be you can look at default trace.
>
> "Erland Sommarskog" wrote:
>
> > RG (RG(a)discussions.microsoft.com) writes:
> > > Does sql server maintain a view containing info on checkpoint activity?
> > > Like when the checkpoints took place and how long they ran.
> >
> > No, but I believe that there are some performance counters.
> >
> >
> > --
> > Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
> >
> > Links for SQL Server Books Online:
> > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> > SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
> >
> > .
> >
From: Erland Sommarskog on 13 Aug 2010 18:11
RG (RG(a)discussions.microsoft.com) writes:
> where is the default trace?

In the LOG directory of your instance.

But there is event for CHECKPOINT what I can see, so it cannot be in the
default trace.
 | 
Pages: 1
Prev: Remove Duplicate Rows
Next: Stats assessment, accurate?