sql server wait interface?

[Ryan]

Oracle has a 'wait interface' for monitoring bottlenecks, etc... does SQL
Server have utilities like this?

[Simon Hayes]

Re: sql server wait interface?

"Ryan" <rgaffuri@cox.n et> wrote in message news:<KZlPb.575 6$_H5.3086@lake read06>...[color=blue]
> Oracle has a 'wait interface' for monitoring bottlenecks, etc... does SQL
> Server have utilities like this?[/color]

Depending on what you mean by a bottleneck, you can look into using
Query Analyzer (poor query plans), Profiler (long running queries),
and Performance Monitor (numerous SQL metrics, plus OS metrics such as
disk I/O).

See "Monitoring Server Performance and Activity" in Books Online for
more details.

Simon

[Ryan]

Re: sql server wait interface?

none of those. In oracle, I get a window into the kernel to see if I have
excessive reading from a file, blocking on my temporary tablespace, blocking
on memory latches.

I guess not. :(. Wait interface is very useful.
"Simon Hayes" <sql@hayes.ch > wrote in message
news:60cd0137.0 401202359.3bb50 c35@posting.goo gle.com...[color=blue]
> "Ryan" <rgaffuri@cox.n et> wrote in message[/color]
news:<KZlPb.575 6$_H5.3086@lake read06>...[color=blue][color=green]
> > Oracle has a 'wait interface' for monitoring bottlenecks, etc... does[/color][/color]
SQL[color=blue][color=green]
> > Server have utilities like this?[/color]
>
> Depending on what you mean by a bottleneck, you can look into using
> Query Analyzer (poor query plans), Profiler (long running queries),
> and Performance Monitor (numerous SQL metrics, plus OS metrics such as
> disk I/O).
>
> See "Monitoring Server Performance and Activity" in Books Online for
> more details.
>
> Simon[/color]

[Simon Hayes]

Re: sql server wait interface?

"Ryan" <rgaffuri@cox.n et> wrote in message news:<dCCPb.581 5$_H5.51@lakere ad06>...[color=blue]
> none of those. In oracle, I get a window into the kernel to see if I have
> excessive reading from a file, blocking on my temporary tablespace, blocking
> on memory latches.
>
> I guess not. :(. Wait interface is very useful.
> "Simon Hayes" <sql@hayes.ch > wrote in message
> news:60cd0137.0 401202359.3bb50 c35@posting.goo gle.com...[color=green]
> > "Ryan" <rgaffuri@cox.n et> wrote in message[/color]
> news:<KZlPb.575 6$_H5.3086@lake read06>...[color=green][color=darkred]
> > > Oracle has a 'wait interface' for monitoring bottlenecks, etc... does[/color][/color]
> SQL[color=green][color=darkred]
> > > Server have utilities like this?[/color]
> >
> > Depending on what you mean by a bottleneck, you can look into using
> > Query Analyzer (poor query plans), Profiler (long running queries),
> > and Performance Monitor (numerous SQL metrics, plus OS metrics such as
> > disk I/O).
> >
> > See "Monitoring Server Performance and Activity" in Books Online for
> > more details.
> >
> > Simon[/color][/color]

You can use the system function fn_virtualfiles tats() to get details
of database file I/O, and the Performance Monitor disk I/O counters
may also be useful. For blocking, you can use sp_who2 and sp_lock to
view process and locking information - sp_who2 shows any blocked
processes.

Simon