Some extra parameters are available on the Client Monitor to improve troubleshooting and performance analysis when you are running the SQL Server Option for Microsoft Dynamics NAV. These parameters can be configured dynamically and include status information about caching, SQL statements, and execution plans.
Collecting server statistics is time-consuming. If you are performing benchmarking to get the most accurate value for the Elapsed Time (ms) parameter, you should not collect statistics at the same time.
Similarly, displaying execution plans is extremely time-consuming and should not be done when you are benchmarking. This parameter is useful when you are troubleshooting problematic application areas to determine if a particular SQL statement is a bottleneck, and can be valuable to users who are unable to run the SQL Server Profiler tool.
 Note |
|---|
|
Executing a SQL statement in the SQL Query Analyzer to use its graphical execution plan does not necessarily give the same plan or statistics as when the same statement is executed from within Microsoft Dynamics NAV. This is due to cursor type differences. The SQL Server Profiler or the Client Monitor SQL Plan parameter gives the most accurate plan. |
