Is there a way that instead of using performance monitory,
I can query from system tables to get information like
log flush wait time, Disk Read Queue length counter and
all related information.
Thanks.Hi
Those are OS counters, and you need to run the OS Perfmon to capture those.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1119648499.019039.254950@.g43g2000cwa.googlegroups.com...
> Is there a way that instead of using performance monitory,
> I can query from system tables to get information like
> log flush wait time, Disk Read Queue length counter and
> all related information.
> Thanks.
>
Monday, February 20, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment