All Forums Viewpoint
Waris 1 post Joined 02/13
07 Feb 2013
Alert on DML Queries

 
Dear Member
is there any mechanism/utility by which we can trigger an ALERT immediately via email or anything whenever a DML query is fired on any specific databases
 
 

dnoeth 4628 posts Joined 11/04
09 Feb 2013

There are no database level triggers.
If it's not neccessarily "immediatle" you might run a job extracting that info from the Access Log every few minutes.
Dieter

Dieter

sureshv 5 posts Joined 02/13
11 Feb 2013

Hi ,
I have a qry . in that join is taking more time . its showing 10 m in plan. 
one of the join column is skewed with one value.
can u pls help me how can we make that join faster.
 

SELECT

COL1,

COL2,

TRIM(COL3) COL3,

 

FROM TABLE A

 

LEFT JOIN

(

SELECT

COL1,

COL2,

CAST(COL3 AS VARCHAR(50)) COL3

FROM TABLE B

)   TEST

ON TABLE A.COL3  =  TABLE B.COL3

 

TABLEA.COL3 IS SKEWED 

 

pls help me to solve this.

 

Thanks,

Suresh.

stever 149 posts Joined 08/09
12 Feb 2013

You can fire such an alert quite easily using TASM.  Create an ALERT only Filter and add classifications (Query Characteristics: Only DML statements & Target: Include XXX Databases)

You must sign in to leave a comment.