Re: Performance Counters for stored proc calls within DTS

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 03/04/04 

Date: Thu, 4 Mar 2004 20:05:35 +0000

In message <eB8loIhAEHA.444@TK2MSFTNGP11.phx.gbl>, ShikariShambu
<shikarishambu70@hotmail.com> writes
>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
>
>

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

Relevant Pages

  • Re: Performance Counters for stored proc calls within DTS
    ... > I have some long running DTS packages that call some stored procs that ... You can add user configurable trace events into your stored procedures. ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Crystal reports
    ... > SQL SERVER stored procedures to get the data, and then use Crystal will do ... > the selection criteria box it asks for the date and time and the selection ... > now we are creating DTS packages to read the database, ...
    (microsoft.public.sqlserver.programming)
  • Re: Performance Counters for stored proc calls within DTS
    ... >> I have some long running DTS packages that call some stored procs ... > You can add user configurable trace events into your stored procedures. ... > Darren Green (SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Performance Counters for stored proc calls within DTS
    ... >> I have some long running DTS packages that call some stored procs ... > You can add user configurable trace events into your stored procedures. ... > Darren Green (SQL Server MVP) ...
    (microsoft.public.dotnet.framework)
  • Re: DTS licensing question
    ... >I have a DTS licensing question: Is a SQL Server 2000 license required ... >for a machine dedicated to running DTS packages, ... >is not running the RDBMS component of SQL Server 2000? ...
    (microsoft.public.sqlserver.dts)
Loading