microsoft.public.sqlserver.server - Lazy writer buffers/sec in SQL 2000

Author

Lazy writer buffers/sec in SQL 2000

Sekar

2002-11-28, 1:23 am

Hi ,

I am looking for the counter "lazy writer buffers/sec"
in SQL Server 2000 but i couldnot found.

But this is available in sql server 7.0 in sysperfinfo
table.

Can any one help me how to get this value in SQL Server
2000.

Thanks in advance,
Sekar.

Alen Zulic

2002-11-28, 12:23 pm

Hi,

sysperfinfo

object_name : SQLServer:Buffer Manager
counter_name : Lazy writes/sec

Best Regards
Alen Zulic

"Sekar" <dhanasekaran_r@ctd.hcltech.com> wrote in message
news:1c1ed01c296a6$bc83d890$89
f82ecf@TK2MSFTNGXA01...
> Hi ,
>
> I am looking for the counter "lazy writer buffers/sec"
> in SQL Server 2000 but i couldnot found.
>
> But this is available in sql server 7.0 in sysperfinfo
> table.
>
> Can any one help me how to get this value in SQL Server
> 2000.
>
> Thanks in advance,
> Sekar.
>
>
>
>

Sponsored Links