Re: SQL profiler feature in Pgsql?

--- "Robert J. Sanford, Jr."
<rsanford(at)nolimitsystems(dot)com> wrote:
> will do!
>
> at its simplest the mssql profiler is a remote
> client that
> provides the ability to trace all of the sql
> commands that
> are being executed against a database. when
> initiating a
> trace you specify the server that you have admin
> priveleges
> on. you watch commands fly across the screen until
> you have
> seen enough and then stop the trace to figure out
> what you
> need to do from there.

I want one too! (Having used MS's) But, alas, spare
time is hard to come by these days.

> there is also an index tuning wizard that will try
> to walk you
> through suggestions on how to optimize your indices
> based on
> the performance of the trace that you just
> collected.

Currently doing this the hard way.

>
> being able to watch what is happening live very
> nice.

I'm using KPM 1.3k6 Visual Process Manager - it comes
with SuSE 7.2.

Troy

______________________________________________________________________
Find, Connect Date! http://personals.yahoo.ca