Forums

In a former life using SQL Server Profiler I could setup a trace that logged specific events against my production DB.

By selecting very specific events, Profiler would not place a crippling burden on the production server and the specific events would not result in an obscenely large trace file. I could run this trace for a day or so, log back in, stop the trace and export to excel to analyze.

My trace would target events;

1) Transactions taking longer than x seconds
2) Deadlocks - both sides
3) Slow Queries

How do achieve something similar with Jade Monitor? I have use method analysis, but I want to trace my database as a whole across all processes but only these specific events? and be assured that I do not bring down a production server currently running at 320 GB and growing?

In JADE systems, routine transaction monitoring is usually done with JADE Care Start (aka CardSchema). If your system is managed by JADE Care, this is already in place.

Transaction times are captured from calls in your code to CardSchema::Object::cnStartTransaction and CardSchema::Object::cnEndTransaction. These times are accumulated in a csv file that can be used for analysis. If your system is managed by JADE Care, analysis tools are also provided.

Deadlocks are usually captured and logged by the JADE Care Start exception handlers.

For specific checks for known or suspected problems, JADE Monitor can be configured to log out information at time intervals. For example, basic system statistics logged out per node every 30 seconds would not put a significant load on the system. There are a number of additional tools in Monitor - such as Method Analysis that you mentioned - that give you a lot more specific information, but cause more load. You would use these once you encounter a problem and want to find out more about it.

You may want to check the performance whitepapers on the JADE website:

https://www.jadeworld.com/docs/jade-71/ ... /title.htm
https://www.jadeworld.com/docs/jade-71/ ... /title.htm

JADE Care Start is available here:

https://www.jadeworld.com/developer-cen ... /jade-care