Very Computer

Bill,
You should investigate using both the SQL Server Audit feature,
available in SQL Server 10 and 11, as well as SQL Monitor.  SQL
Monitor will give you execution times of stored procedures when
using SQL Monitor 11.0.x (which can run against SQL Server 10 and
11) as well as I/Os by table (Object I/O).  Also, Sybase Historical
Server (part of the SQL Monitor Bundle kit) includes additional
detail that SQL Monitor Client doesn't give with its default
windows.  There, you can get I/Os by stored procedure line # !

You may not need plans on this, but it all depends on what you
are trying to do.  I'd be glad to talk to you more about this if
you're interested.  I work right in your area.

Is there any way I can use "set showplan", "statistics_io" and
"statistics time" to monitor queries and stored procedures that are
run from within a GUI "canned" application (Platinum Financials).  I
am not sure what queries and stored procedures are used during the
execution of different jobs from within the application.  I have some
experience working with Oracle's trace files and TKPROF.  With Oracle
I am able to have the user log into the canned app which produces a
trace file matching their SID which will trace all the sql thrown at
the database.  With "set showplan" it seems that I would have to some
how pull out all the SQL an run it manually !!!

Any help would be greatly appreciated !!!!!

************************************
Bill Timm
Asplundh Tree Expert Co.
voice:  (215) 784-1457
fax:    (215) 784-1366

************************************