Setting up Sybase for use with the DBOptimizer SQL Profiler feature
· Enabling Monitoring· Wait Event Timing
This is the maximum length for SQL text stored by Sybase, but we suggest 4096 as a good starting point.
2. Grant the user mon_role.
· If the monProcess table is missing, the user will not be able to see currently connected sessions.
Ex: sp_configure "allow resource limits", 1
This will enable resource limits (requires server restart). When executing the statements, DBO will also send “set showplan on” command. This will cause Sybase to display the explain plan and also the I/O costs when running statements (if the resource limits are disabled, no costs will be displayed).
Engines and CPUs
The number of "engines" is displayed as a red horizontal line on the load chart. The number of engines is the maximum number of concurrent users. If the number of concurrent, ie active, users in the load chart is higher than the number of engines then there is a bottleneck.
THe number of engines is limited by the number of CPUs on the machine and the what the license from Sybase allows.The usual recommendation is number of engines should never exceed the number of physical CPUs as performance will be worse. On a Sybase server with many CPUs “8 or more”, the recommended formula is Engines = CPUs – 1