Using Profilers

To monitor the state of your MYOB Advanced server at any given moment, you can use the following profilers and related tools, each of which is described in a section in this topic:

MYOB Advanced Request Profiler

On the Request Profiler (SM205070) form, you can monitor the performance of MYOB Advanced and find out which requests are taking too much time. By using the filters on the form, you can identify periods of slow performance and isolate the root causes. For details, see System Health: Request Profiler.

Tip: For a simple operation (such as opening a screen, adding a new record, or deleting a record), the standard duration of the execution of the request on the server (server time) is about 500 milliseconds.

By selecting the Log Exceptions check box in the Exception Logging section of the Summary area of the form, you can turn on the logging of exceptions. The system displays the list of the logged exceptions on the Exceptions tab of the form.

By selecting the Log Events (Apply Filter) check box in the Event Logging section of the Summary area of the form, you can turn on the logging of events. You can specify a specific severity level of events by selecting this level in the Log Level box. You can filter the events that the system should log by category by selecting the needed options in the Category box. The system displays the list of the logged events on the Event Log tab of the form.
Attention: We recommend that you activate the logging of events by selecting the Log Events (Apply Filter) check box for only a limited period, because leaving this check box selected can degrade system performance.

MYOB Advanced SQL Profiler

You can analyze SQL queries by using the built-in SQL profiler of MYOB Advanced. To activate the SQL profiler, select the Log SQL (Apply Filter) check box on the Request Profiler (SM205070) form. To view the SQL queries for a particular URL request, click the row with the request, and then click View SQL on the table toolbar of the Requests tab of the form. To view aggregated information for each SQL query, open the SQL tab of the form. For details, see System Health: Request Profiler.
Attention: We recommend that you activate the logging of SQL queries by selecting the Log SQL (Apply Filter) check box for only a limited period, because leaving this check box selected can degrade system performance.

MYOB Advanced Running Processes

On the Running Processes tab of the System Monitor (SM201530) form, you can monitor all batch processing operations that are currently being performed in the system, such as the release of multiple transactions at once, the preparation of dunning letters, the generation of a report, the creation of a tenant snapshot, or the use of an import or export scenario. Your server may be slow because of a large number of these operations running simultaneously.

For details, see System Health: General Information.

SQL Server Profiler

Microsoft SQL Server Profiler is a tool for tracing SQL queries. To find problematic queries more easily, you can select only particular events to be traced and use various filters.

Sometimes it may be helpful to identify the actual SQL query by using the profiler and then execute the query in Microsoft SQL Server Management Studio to investigate the problem.

Browser Profilers

Most modern browsers offer debugging tools, which you can use to monitor requests, catch JavaScript errors, and obtain network timing data. Combined with the MYOB Advanced Request Profiler, these tools can help you analyze the network latency.

Stack Trace Snapshot

If your site is unresponsive and you are unable to establish the reason, you can create a dump of the stack trace of the running process. To do this, right-click the IIS worker process (w3wp.exe) in Windows Task Manager and select Create Dump File. You can then open the dump file in Visual Studio and analyze all threads and their stack traces.