Friday, January 6, 2017

Trace/Track CRM SQL Queries using SQL PROFILER

When we use to debug the CRM query using SQL profilers, the followings are important events.
Events
Name
Error And Warning
Blocked Process report
Exeception
TSQL
SQL:Batch completed
SQL:stmt completed
Store Procedure
RPC:Completed
SP:Completed
SP:stmt completed
Locks
Dead Lock graph
Query expression to track/trace SQL query events are Store procedure ->RPC Completed

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.