Using DBMonitor

To extend monitoring capabilities of MyDirect .NET applications there is an additional tool called DBMonitor. It is easy-to-use tool to provide visual monitoring of your database applications.

DBMonitor performs per-component tracing of database events such as commit, rollback, SQL statement execute etc.

DBMonitor has following features:

• multiple client processes tracing;
• SQL event filtering (by sender objects);
• SQL parameter and error tracing.

During monitoring you can easy switch between client processes and view hierarchy of objects being traced.

DBMonitor is intended to hamper application being monitored as less as possible.

To trace your application with DBMonitor you should follow these steps:

• Create an instance of MySqlMonitor component in your application. You can do it by dropping MySqlMonitor on form from toolbox or by creating it manually in code. Only one instance of MySqlMonitor is needed in the application.
• Set MySqlMonitor.IsActive property to true to enable monitoring.
• Start DBMonitor application before running your program. If DBMonitor is installed you can start it from MySqlMonitor component designer by clicking "Run DBMonitor" verb or from Tools->MySQL menu.

Monitoring capabilities are accessible at design-time as well.

Using DBMonitor with ASP.NET projects

To trace your ASP.NET applications you must perform some additional steps. As ASP.NET application by default is started under ASP.NET Windows account it can not share information that DBMonitor uses with the account where DBMonitor is running. Therefore you need to follow the next steps:

• Start ASP.NET with the same Windows account where DBMonitor runs.
• Open machine.config file from WindowsDir\Microsoft.NET\Framework\vX.X\config\machine.config.
• Find <processModel> tag.
• Change userName attribute value to your Windows account name and password to your account password.
• Setup ASP.NET service in order that it has access to current user Desktop services. To do it open Service Control Manager and find IIS Admin service. Open its properties dialog. Go to Log On tab and check 'Allow service to interact with desktop' checkbox.
• Restart IIS.

Note: DBMonitor utility is available with MyDirect .NET Professional and Trial editions only.

See Also

MySqlMonitor Class  | CoreLab.MySql Namespace

© 2002-2008 Devart. All rights reserved.