Re: Massive DTS job (5 days and i am nervous)

From: N (raasen_at_hotmail.com)
Date: 06/19/04 

Date: Sat, 19 Jun 2004 15:12:45 +0200

YEs, i remembered about profiler a bit too late. But i have started it only
after the SP has been running for about 4 hours now
;)))
...

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:O7bKytfVEHA.3012@tk2msftngp13.phx.gbl...
> If you have SQL Server 2000 SP3 (or SP3a), then you may be able to get
that
> with fn_get_sql(). Check out the BOL for more details. In future, you
can
> simply run the Profiler and trace the SP:StmtStarted events.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> .
> "N" <raasen@hotmail.com> wrote in message
> news:%23Y6MRnfVEHA.212@TK2MSFTNGP12.phx.gbl...
> Hi
>
> I have inherited a DTS job that takes about 5 days to run.
> This job is made up of about 20 stored procedures and some vbscript and so
> on.
> There is a bit of a process log that is kept in a table which is basically
a
> log of a start of a stored proc and then logs an end time for the stored
> proc. The stored procs are made up of loads of sql statements. Is there
any
> way i could see which statement is being executed at the current point in
> time? dbcc inputbuffer just gives me the "exec stored_proc" command used
in
> the SQL task. I can see that something is happening as the disk space
usage
> is increasing and the CPUTime and DISKIo are going up for the spid
executing
> the sql task. There are also no blks for any of the processes so i am
> certain nothing is blocking anything. I however, would like to know which
> sql statement is being executed just to satisfy myself that this thing is
> not hanging on one sql statement the entire time....
>
> any ideas?
>
>

Relevant Pages

  • Re: Massive DTS job (5 days and i am nervous)
    ... Inserts are done as a transaction. ... Columnist, SQL Server Professional ... The way this was written and i am using the current stored proc being executed as an example is that no transactions are used. ... would like to know which> sql statement is being executed just to satisfy myself that this thing is> not hanging on one sql statement the entire time.... ...
    (microsoft.public.sqlserver.programming)
  • Re: Newbie Problems Updating SQL
    ... > I have checked the sql update command during debug and it is formulated ... I also do not see the command when I run SQL Profiler. ... >> before you call Update and see what your Actual SQL Statement ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Massive DTS job (5 days and i am nervous)
    ... Columnist, SQL Server Professional ... log of a start of a stored proc and then logs an end time for the stored ... not hanging on one sql statement the entire time.... ...
    (microsoft.public.sqlserver.programming)
  • Re: Massive DTS job (5 days and i am nervous)
    ... Our development transform server and our production transform server are ... > Columnist, SQL Server Professional ... > log of a start of a stored proc and then logs an end time for the stored ... > not hanging on one sql statement the entire time.... ...
    (microsoft.public.sqlserver.programming)
  • Re: Update changed columns only
    ... And inside the trigger do you use the UPDATEfunction ... For now I would like to make 100 % that you see in SQL Profiler the SQL ... To know for sure the best way is to see the SQL statement using the SQL ...
    (microsoft.public.dotnet.framework.aspnet)