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.