Performance Counters for stored proc calls within DTS

  • Thread starter Thread starter ShikariShambu
  • Start date Start date
S

ShikariShambu

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
 
ShikariShambu said:
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
Click to expand...

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