Re: how to write sql to use Profiler to capture sql and sp running longer than 5 sec
From: Uri Dimant (urid_at_iscar.co.il)
Date: 02/02/05
- Next message: Devinder Singh: "Re: Query to get the last inserted records first"
- Previous message: Olivier Matrot: "Query to get the last inserted records first"
- In reply to: Mullin Yu: "how to write sql to use Profiler to capture sql and sp running longer than 5 sec"
- Next in thread: Devinder Singh: "Re: how to write sql to use Profiler to capture sql and sp running longer than 5 sec"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 2 Feb 2005 10:46:04 +0200
Hi
In the subject you write "how to write sql to use Profiler to capture sql
and sp running longe" but when you ask the question you wrote
i don't want to use Profiler.
Look up system stored procedures in the BOL that you can run to capture the
DML.
sp_trace_create for example
"Mullin Yu" <mullin_yu@ctil.com> wrote in message
news:uP5CJ%23PCFHA.2676@TK2MSFTNGP12.phx.gbl...
> hi,
>
> i have two db, say db1 and db2. i want to create a sql statement to
capture
> those sql statement and sp running longer than 5 sec.
>
> any hints? i don't want to use Profiler.
>
> thanks!
>
>
- Next message: Devinder Singh: "Re: Query to get the last inserted records first"
- Previous message: Olivier Matrot: "Query to get the last inserted records first"
- In reply to: Mullin Yu: "how to write sql to use Profiler to capture sql and sp running longer than 5 sec"
- Next in thread: Devinder Singh: "Re: how to write sql to use Profiler to capture sql and sp running longer than 5 sec"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
