ACTUAL SQL TRACING

[rajeevnandanmishra]

My application is suddenly started taking longer time while updating sql server data.
In a particular form, I am updating TABLE1 with a single record. And on TABLE1 i had a trigger on update, which again updates two more tables. I want to check where is the bottleneck.
I had opened the SQL Trace but it shows me only the UPDATE command for first Table. I want to know the sql activity after the update command i.e. the trigger activity.

Please let me know about it, If it is possible. It is urgent.

Thanks in advance.

 

[foxdev]

Have you tried SQL Server Profiler? Create a trace in it using the Trace Wizard - Worst Performing Queries, then edit its profile and tweak it as necessary (add and remove filters, etc). Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[rajeevnandanmishra]

Thanks Foxdev,

But i am working in SQL 6.5

Is there any way to work out the same in 6.5.

 

[TomSark]

SQL 6.5 has a SQL Trace utility... Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[foxdev]

Hi, Tom. I'm not a 6.5 user, so I'm asking out of ignorance: is the 6.5 "Trace Utility" effectively the same thing as SQLS 7/2K's SQL Server Profiler? Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[dbmsguy]

just curiously, can you not just execute the triggers manually? ie. extract them and modify them enough with values that would be passed? then the sql trace should pick it up!

Paul

http://www.dbmsguy.com