Performance question

sql functions vs sub selects vs inner joins instead of sub selects. Which
is faster."isicoder" <isicoder@.newsgroups.nospam> wrote in message
news:eRs9$YBLGHA.1132@.TK2MSFTNGP10.phx.gbl...
> sql functions vs sub selects vs inner joins instead of sub selects. Which
> is faster.
>
>
Depends on many things. Indexes, parallelism and so forth.
Start doing some reading at www.sql-server-performance.com
Check the execution plans and so forth.
Rick Sawtell
MCT, MCSD, MCDBA

Performance monitor stats from table

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.googlegr oups.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.
>

Performance monitor stats from table

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.
>

Performance monitor stats from table

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.
>