Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Profiler Expand / Collapse
Author
Message
Posted Wednesday, April 24, 2013 6:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:32 AM
Points: 128, Visits: 182
Hi Friends,

I am running an external web application. I just need to trace all the DML queries alone using profiler. I tried myself but not able to get the correct ouptut.

Could any one suggest me the steps to trace the queries , please ?

Any suggestions would be really appreciated...

Thank you in advance ....
Post #1445927
Posted Wednesday, April 24, 2013 7:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
Hello,

Use events like Stored procedures and TSQL.
sub events as per your needs.



Regards
Durai Nagarajan
Post #1445943
Posted Wednesday, April 24, 2013 7:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:32 AM
Points: 128, Visits: 182
durai nagarajan (4/24/2013)
Hello,

Use events like Stored procedures and TSQL.
sub events as per your needs.



Thank you Durai....
Post #1445953
Posted Wednesday, April 24, 2013 7:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
happy to help

Regards
Durai Nagarajan
Post #1445976
Posted Friday, April 26, 2013 3:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 10, 2014 5:09 AM
Points: 2,567, Visits: 4,654
The link below has a book on SQL Server Profiler by Brad McGehee

http://www.sqlservercentral.com/articles/books/65797/



Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1446886
Posted Tuesday, April 30, 2013 5:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:32 AM
Points: 128, Visits: 182
Kingston Dhasian (4/26/2013)
The link below has a book on SQL Server Profiler by Brad McGehee

http://www.sqlservercentral.com/articles/books/65797/


Thank you, Kingston. I appreciate that.
Post #1447959
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse