Hi,
I have some long running DTS packages that call some stored procs that
do significant processing. Is there are way to put performance counters
around the calls to the stored procedures in the DTS package.

Has any one done this? Does .NET help in this scenario? We are running SQL
Server 2000 with sp3 with .NET v 1 as our development platform.

TIA

In message <eB8loIhAEHA.444 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, ShikariShambu
<shikarishambu70 (AT) hotmail (DOT) com> writes
I would start with Profiler. This will allow you to see the SQL issued
by the package.

You can add user configurable trace events into your stored procedures.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

I don't want a one time solution. I want to capture the performance
information on an ongoing basis.

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote