Database Call
ashokkumar
Posts: 2
Hi,
I was trying to get the database call details using ANTS performance profiler 9 in trail version. once I stooped the profiler for sample applcation, and try to view the database call option for SQL query plan, I am not able to get the execution plan.
I enable the "Enable SQL Query profiling" option also as true. The error and setting screenshot has been attached.
[img]D:ANTS_Sql_Profile_Issue.png[/img]
[img]D:ANTS_Sql_Profile_Settings.png[/img]
Please let me know, what I am missing to get the result.
Currently I am using trail version to validate the tool. If tool will give the desired result for database query with time, I can go for licenses version.
Thanks,
Ashok
I was trying to get the database call details using ANTS performance profiler 9 in trail version. once I stooped the profiler for sample applcation, and try to view the database call option for SQL query plan, I am not able to get the execution plan.
I enable the "Enable SQL Query profiling" option also as true. The error and setting screenshot has been attached.
[img]D:ANTS_Sql_Profile_Issue.png[/img]
[img]D:ANTS_Sql_Profile_Settings.png[/img]
Please let me know, what I am missing to get the result.
Currently I am using trail version to validate the tool. If tool will give the desired result for database query with time, I can go for licenses version.
Thanks,
Ashok
Comments
Can I confirm if you've already run the SQL Query within SSMS? APP accesses cached query plans, so can only display something if you've already run it. There's more information on this here: https://documentation.red-gate.com/disp ... an+diagram.