Class Method list used by SAP ABAP Class CL_SYB_DOCU (SYB: Simple store of extended documentation texts)
SAP ABAP Class CL_SYB_DOCU (SYB: Simple store of extended documentation texts) is using
# Object Type Object Name Object Description Note
     
1 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 19 seq = 1 text = 'No action necessary. Even with high values for WaitTime, event 19 does not affect overall performance.'(004) ).
2 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 29 seq = 1 text = 'Because this event#s value for monSysWaits.WaitTime is measured in seconds, the value for WaitTime for'(009) ).
3 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 29 seq = 2 text = 'this event should be much less than the value for Waits (an average physical read should be 2#6 milliseconds;'(010) ).
4 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 29 seq = 3 text = 'more than 10 milliseconds is considered slow). A high average physical read value may indicate poor disk'(011) ).
5 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 29 seq = 4 text = 'throughput performance. Query monIOQueue and monDeviceIO to identify slow or overloaded disks.'(012) ).
6 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 29 seq = 5 text = 'A high value for Waits, regardless of the value for WaitTime, may indicate that query plans are not as'(013) ).
7 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 29 seq = 6 text = 'effective as they could be. If you encounter a high value for Waits, a table scan or Cartesian product'(014) ).
8 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 29 seq = 7 text = 'may have occurred, or the optimizer may have selected a bad plan, due to bad, stale, or missing statistics.'(015) ).
9 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 29 seq = 8 text = 'Consider adding an index on specific columns to the table on which this occurred.'(016) ).
10 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 29 seq = 9 text = 'A high value for Waits can also indicate the data caches are too small, with active pages first pushed'(017) ).
11 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 29 seq = 10 text = 'out and then reread. Query monOpenObjectActivity, monProcessActivity, monDataCache, monCachPool, and'(018) ).
12 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 29 seq = 11 text = 'monProcessObject to determine how to proceed.'(019) ).
13 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 30 seq = 1 text = 'You may be able to reduce high wait times by:
  • Increasing the size of the data cache
  • Using'(024) ).
14 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 30 seq = 2 text = 'cache partitions or named caches to separate memory-intensive objects
  • Tuning the housekeeper,'(025) ).
  • 15 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 30 seq = 3 text = 'washmarker position, or schema implications (such as sequential key tables)
  • Positioning the'(026) ).
  • 16 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 30 seq = 4 text = 'washmarker
  • Adjusting the schema (such as sequential key tables)
  • '(027) ).
    17 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 31 seq = 1 text = 'Generally, the value for WaitTime for event 31 should be less than the value for Waits.'(032) ).
    18 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 31 seq = 2 text = 'High values for WaitTime may indicate disk contention or slow performance.'(033) ).
    19 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 31 seq = 3 text = 'Query monIOQueue and monDeviceIO to identify overloaded or slow disks.'(034) ).
    20 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 31 seq = 4 text = 'A high value for WaitTime for event 31 may also indicate that the data cache is too small, causing pages'(035) ).
    21 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 31 seq = 5 text = 'in the data cache to reach the wash area frequently and forcing the checkpoint process to perform'(036) ).
    22 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 31 seq = 6 text = 'more writes than necessary.'(037) ).
    23 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 32 seq = 1 text = 'A high value for Waits may indicate that Adaptive Server is using asynchronous prefetch too often.'(040) ).
    24 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 32 seq = 2 text = 'Tuning the local APF limit for cache pools may reduce contention for APF pages.'(041) ).
    25 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 32 seq = 3 text = 'Since Adaptive Server often uses APF for table scans, contention involving APF reads may indicate that'(042) ).
    26 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 32 seq = 4 text = 'an application is performing too many table scans because of factors such as missing indexes.'(043) ).
    27 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 35 seq = 1 text = 'The value for WaitTime for event 35 should be quite small. If the value is large, many processes are'(048) ).
    28 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 35 seq = 2 text = 'accessing the same page at the same time, or there is CPU contention. Query monEngine to determine if'(049) ).
    29 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 35 seq = 3 text = 'the engines are overloaded, and run system-level utilities to determine if there is overall CPU contention.'(050) ).
    30 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 36 seq = 1 text = 'A high value for WaitTime indicates that some condition may be causing diminished I/O or data cache manager'(053) ).
    31 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 36 seq = 2 text = 'performance. Normally, the value for Waits should be higher than the value for WaitTime.'(054) ).
    32 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 36 seq = 3 text = 'Query monIOQueue and monDeviceIO to determine if a disk device is slow or overloaded.'(055) ).
    33 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 36 seq = 4 text = 'If event 36 occurs because of an update to a page, partitioning th cache has not effect.'(056) ).
    34 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 36 seq = 5 text = 'However, if event 36 occurs when page updates are not taking place, partitioning the cache may expedite'(057) ).
    35 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 36 seq = 6 text = 'the writes.'(058) ).
    36 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 37 seq = 1 text = 'Typically, the values for Waits for event 37 should be much higher than the values for WaitTime.'(061) ).
    37 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 37 seq = 2 text = 'If the values are not higher for Waits, either many processes are accessing the same MASS at once, or'(062) ).
    38 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 37 seq = 3 text = 'there is CPU contention. Query monEngine to determine if the engines are overloaded.'(063) ).
    39 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 37 seq = 4 text = 'Run system-level utilities to determine if there is overall CPU contention.'(064) ).
    40 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 41 seq = 1 text = 'Consider reducing contention for pages by changing index definitions in a way that alters the physical'(067) ).
    41 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 41 seq = 2 text = 'distribution of data across the data and index pages within your table, or modifying your application'(068) ).
    42 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 41 seq = 3 text = 'to reduce contention. If the average value for WaitTime is high, event 41 may occur because of an Adaptive'(069) ).
    43 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 41 seq = 4 text = 'Server resource shortage, resulting from:
    • A hash table that is too small for a lock, resulting'(070) ).
    44 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 41 seq = 5 text = 'in very long hash chains that Adaptive Server must search.
  • An operating system issue during'(071) ).
  • 45 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 41 seq = 6 text = 'which calls that should be quick are a bottle neck (for example, starting asynchronous I/O, which should'(072) ).
    46 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 41 seq = 7 text = 'return immediately, blocks because of operating system resource limitations.'(073) ).
    47 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 41 seq = 8 text = '
  • Extremely high inserts and expanding updates. Page allocations take place frequently, and contention'(074) ).
  • 48 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 41 seq = 9 text = 'for the allocation page latch results in a high number of Waits. Use dbcc tune(des_greedyalloc)'(075) ).
    49 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 41 seq = 10 text = 'to reduce this contention. For information about latch contention, see Performance and Tuning Series:'(076) ).
    50 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 41 seq = 11 text = 'Monitoring Adaptive Server with sp_sysmon. '(077) ).
    51 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 46 seq = 1 text = 'Event 46 may indicate that:
    • A cache is so busy that the buffer at the end of the LRU chain is'(081) ).
    52 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 46 seq = 2 text = 'still processing. Query monDataCache and monCachePool to determine which cache is busy.'(082) ).
    53 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 46 seq = 3 text = 'Possible resolutions include: increasing the size of the cache, using sp_poolconfig to increase'(083) ).
    54 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 46 seq = 4 text = 'the wash size, and increasing the housekeeper activity by retuning enable housekeeper GC.'(084) ).
    55 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 46 seq = 5 text = '
  • Disk writes are taking a long time to complete. Query monIOQueue and monDeviceIO to determine'(085) ).
  • 56 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 46 seq = 6 text = 'if there is a slow or overloaded disk device. '(086) ).
    57 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 51 seq = 1 text = 'A high value for WaitTime indicates that writes may be taking a long time to complete.'(091) ).
    58 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 51 seq = 2 text = 'Typically, the value for Waits should be much higher than the value for WaitTime.'(092) ).
    59 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 51 seq = 3 text = 'Query monIOQueue and monDeviceIO to determine if there is a slow or overloaded disk device.'(093) ).
    60 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 52 seq = 1 text = 'A high value for WaitTime for this event indicates that writes may be taking too long to complete.'(097) ).
    61 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 52 seq = 2 text = 'Typically, the value for Waits should be much higher than the value for WaitTime.'(098) ).
    62 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 52 seq = 3 text = 'Query monIOQueue and monDeviceIO to determine if there is a slow or overloaded disk device.'(099) ).
    63 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 53 seq = 1 text = 'Normally, the value for Waits for event 53 should be higher than the value for WaitTime.'(102) ).
    64 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 53 seq = 2 text = 'If it is not higher, either many processes are simultaneously accessing the same MASS, or there is CPU'(103) ).
    65 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 53 seq = 3 text = 'contention. Query monEngine to determine if the engines are overloaded.'(104) ).
    66 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 53 seq = 4 text = 'Run system-level utilities to determine if there is overall CPU contention.'(105) ).
    67 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 54 seq = 1 text = 'A high average value for WaitTime for event 54 indicates that writes are taking a long time to complete.'(109) ).
    68 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 54 seq = 2 text = 'Typically, the value for Waits should be much higher than the value for WaitTime.'(110) ).
    69 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 54 seq = 3 text = 'Query monIOQueue and monDeviceIO to determine if there is a slow or overloaded disk device.'(111) ).
    70 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 54 seq = 4 text = 'High values for Waits, regardless of the average time, may indicate contention for the last log page.'(112) ).
    71 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 54 seq = 5 text = 'Increase the size of the user log cache to reduce contention, or group operations for applications to'(113) ).
    72 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 54 seq = 6 text = 'avoid committing every row.'(114) ).
    73 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 55 seq = 1 text = 'A high value for WaitTime for event 55 indicates that writes may be taking a long time to complete.'(119) ).
    74 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 55 seq = 2 text = 'Typically, the value for Waits should be much higher than the value for WaitTime'(120) ).
    75 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 57 seq = 1 text = 'Event 57 may accumulate large amounts of time since the checkpoint process starts when the server starts.'(122) ).
    76 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 57 seq = 2 text = 'However, you need not perform any actions based on this event.'(123) ).
    77 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 61 seq = 1 text = 'Event 61 is expected, and may show large values on servers that have run for along time.'(125) ).
    78 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 61 seq = 2 text = 'Typically, you need not perform any actions based on this event.'(126) ).
    79 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 70 seq = 1 text = 'If you are not using Adaptive Server mirroring, set disable disk mirroring to 1.'(130) ).
    80 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 70 seq = 2 text = 'If you are using mirroring, high values for WaitTime may indicate a loss of performance from device contention.'(131) ).
    81 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 70 seq = 3 text = 'Query monIOQueue and monDeviceIO to determine if there is a slow or overloaded disk device.'(132) ).
    82 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 70 seq = 4 text = 'Evaluate the results to determine if you can shift some of the load to other devices.'(133) ).
    83 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 83 seq = 1 text = 'A high value for Waits for event 83 may indicate a shortage of object descriptors.'(138) ).
    84 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 83 seq = 2 text = 'You may need to increase the number of open objects.'(139) ).
    85 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 84 seq = 1 text = 'Although it is unlikely that the Waits value is high for event 84, a high value may indicate that many'(142) ).
    86 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 84 seq = 2 text = 'drops are occurring simultaneously, or that the checkpoint process is taking a long time.'(143) ).
    87 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 84 seq = 3 text = 'If the checkpoints are running for an excessive amount of time, try decreasing the recovery interval'(144) ).
    88 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 84 seq = 4 text = '(in minutes).'(145) ).
    89 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 85 seq = 1 text = 'This event is normal during a dump database. If the average value for WaitTime is exceptionally'(149) ).
    90 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 85 seq = 2 text = 'high (higher than 2), check other events to determine what is slowing down the flusher processes.'(150) ).
    91 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 91 seq = 1 text = 'Generally, the value for WaitTime for event 91 should be much lower than the value for Waits.'(153) ).
    92 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 91 seq = 2 text = 'High values for WaitTime indicate possible disk contention or slowness.'(154) ).
    93 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 91 seq = 3 text = 'Query monIOQueue and monDeviceIO to determine if there is a slow or overloaded disk device.'(155) ).
    94 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 99 seq = 1 text = 'A high average value for WaitTime for event 99 indicates slow communication with the remote server.'(158) ).
    95 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 99 seq = 2 text = 'This may be due to complex RPC calls that take a long time to complete, performance issues in the remote'(159) ).
    96 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 99 seq = 3 text = 'server, or a slow or overloaded network.'(160) ).
    97 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 104 seq = 1 text = 'The average value for WaitTime for event 104 should be very close to 30.'(164) ).
    98 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 104 seq = 2 text = 'If engines are frequently taken offline, this value may be slightly lower.'(165) ).
    99 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 104 seq = 3 text = 'If the average value for WaitTime is significantly higher or lower than 30, contact Sybase Technical'(166) ).
    100 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 104 seq = 4 text = 'Support.'(167) ).
    101 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 124 seq = 1 text = 'The value for WaitTime for event 124 should be much lower than the value for Waits.'(170) ).
    102 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 124 seq = 2 text = 'The average value for WaitTime is high if disk performance is poor. Query monIOQueue and monDeviceIO'(171) ).
    103 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 124 seq = 3 text = 'to determine if there is a slow or overloaded disk device.'(172) ).
    104 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 142 seq = 1 text = 'Event 142 should normally have a very low average value for WaitTime. A high value for WaitTime may indicate'(175) ).
    105 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 142 seq = 2 text = 'there is a problem communicating with the remote server.'(176) ).
    106 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 143 seq = 1 text = 'A high average value for WaitTime for event 143 may indicate performance issues on the remote server'(180) ).
    107 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 143 seq = 2 text = 'or a slow or overloaded network. Query monProcessWaits for WaitEventID 143 to determine which spids have'(181) ).
    108 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 143 seq = 3 text = 'high wait times.'(182) ).
    109 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 150 seq = 1 text = 'The value for WaitTime for this event can be high if there is contention for a particular table or page'(187) ).
    110 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 150 seq = 2 text = '(such as a high number of heap inserts). Query monLocks and monOpenObjectActivity to identify objects'(188) ).
    111 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 150 seq = 3 text = 'that are experiencing heavy lock contention. In some situations, you can reduce the amount of lock contention'(189) ).
    112 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 150 seq = 4 text = 'by changing the table#s locking scheme from allpages locking to data-only locking.'(190) ).
    113 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 150 seq = 5 text = 'Application or database design typically causes lock contention; evaluate your application design to'(191) ).
    114 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 150 seq = 6 text = 'determine the best method to reduce lock contention, while still considering other application requirements.'(192) ).
    115 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 157 seq = 1 text = 'If the average value for WaitTime for event 157 is low, performance may not noticeably degrade.'(197) ).
    116 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 157 seq = 2 text = 'However, any Waits on this event indicate a condition you can correct by increasing the configured number'(198) ).
    117 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 157 seq = 3 text = 'of structures for which Adaptive Server is waiting. Use sp_countmetadata and sp_monitorconfig'(199) ).
    118 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 157 seq = 4 text = 'to identify which structures are using the maximum configuration to determine which resources you should'(200) ).
    119 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 157 seq = 5 text = 'increase.'(201) ).
    120 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 169 seq = 1 text = 'Typically, the average value for WaitTime for event 169 is very small.'(205) ).
    121 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 169 seq = 2 text = 'However, if the value for WaitTime is large, query monProcessWaits for rows with WaitEventID value of'(206) ).
    122 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 169 seq = 3 text = '169 to determine which jobs have long wait times for this event.'(207) ).
    123 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 171 seq = 1 text = 'A high average value for WaitTime for this event may indicate remote CIS server performance issues or'(210) ).
    124 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 171 seq = 2 text = 'a slow or overloaded network. Query monProcessWaits for WaitEventID 171 to determine which spids have'(211) ).
    125 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 171 seq = 3 text = 'high wait times for this event.'(212) ).
    126 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 178 seq = 1 text = 'You need not perform any actions based on event 178. However, you can use some of its information for'(215) ).
    127 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 178 seq = 2 text = 'analysis. The value for WaitTime is roughly equivalent to the amount of time the server has been running.'(216) ).
    128 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 178 seq = 3 text = 'The values for Waits is a measure of how many connection attempts have been made since the server started.'(217) ).
    129 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 179 seq = 1 text = 'High values for event 179 indicate high levels of network activity. If the network activity is unexpectedly'(221) ).
    130 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 179 seq = 2 text = 'high, query other monitoring tables#such as monNetworkIO and monProcessNetIO#to determine which jobs'(222) ).
    131 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 179 seq = 3 text = 'are slowing network performance. A high value for the Waits column for event 179 may indicate that dbcc'(223) ).
    132 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 179 seq = 4 text = 'checkstorage identified a large number of possible consistency faults.'(224) ).
    133 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 179 seq = 5 text = 'Check the reports from dbcc checkstorage for more information.'(225) ).
    134 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 197 seq = 1 text = 'Generally, the value for WaitTime for event 197 should be much lower than the value for Waits.'(229) ).
    135 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 197 seq = 2 text = 'A high average value for WaitTime may indicate poor disk throughput performance.'(230) ).
    136 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 197 seq = 3 text = 'Query monIOQueue and monDeviceIO to determine if there is a slow or overloaded disk device.'(231) ).
    137 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 200 seq = 1 text = 'Generally, the value for WaitTime for event 200 should be much lower than the value for Waits.'(234) ).
    138 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 200 seq = 2 text = 'A high average value for WaitTime may indicate poor disk throughput performance.'(235) ).
    139 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 200 seq = 3 text = 'Query monIOQueue and monDeviceIO to determine if there is a slow or overloaded disk device.'(236) ).
    140 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 201 seq = 1 text = 'Generally, the value for WaitTime for event 201 should be much lower than the value for Waits.'(240) ).
    141 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 201 seq = 2 text = 'A high average value for WaitTime may indicate poor disk throughput. Query monIOQueue and monDeviceIO'(241) ).
    142 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 201 seq = 3 text = 'to determine if there is a slow or overloaded disk device.'(242) ).
    143 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 202 seq = 1 text = 'Generally, the value for WaitTime for event 202 should be much lower than the value for Waits.'(246) ).
    144 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 202 seq = 2 text = 'A high average value for WaitTime may indicate poor disk throughput. Query monIOQueue and monDeviceIO'(247) ).
    145 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 202 seq = 3 text = 'to determine if there is a slow or overloaded disk device.'(248) ).
    146 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 203 seq = 1 text = 'Generally, the value for WaitTime for event 203 should be much lower than the value for Waits.'(252) ).
    147 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 203 seq = 2 text = 'A high average value for WaitTime may indicate poor disk throughput. Query monIOQueue and monDeviceIO'(253) ).
    148 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 203 seq = 3 text = 'to determine if there is a slow or overloaded disk device.'(254) ).
    149 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 205 seq = 1 text = 'The frequency of event 205 depends on how many text and image columns are contained in the tables you'(258) ).
    150 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 205 seq = 2 text = 'are checking. An exceptionally high average value for WaitTime may indicate some resource contention'(259) ).
    151 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 205 seq = 3 text = 'for the worker thread holding the lock. Check CPU and disk metrics to determine if there is contention.'(260) ).
    152 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 207 seq = 1 text = 'Event 207 is typically caused by Adaptive Server reporting a large number of faults.'(265) ).
    153 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 207 seq = 2 text = 'You need not take any actions for this event, other than to follow the normal process of running dbcc'(266) ).
    154 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 207 seq = 3 text = 'checkverify to verify and analyze the faults.'(267) ).
    155 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 209 seq = 1 text = 'The average value for WaitTime for event 209 should be very low. High average values for WaitTime may'(271) ).
    156 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 209 seq = 2 text = 'indicate that the sort manager producer processes cannot generate data fast enough to keep the consumer'(272) ).
    157 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 209 seq = 3 text = 'processes busy. Check the overall system performance to determine if Adaptive Server has sufficient CPU'(273) ).
    158 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 209 seq = 4 text = 'and IO bandwidth.'(274) ).
    159 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 210 seq = 1 text = 'The average value for WaitTime for event 210 should be very low. High average values for WaitTime may'(278) ).
    160 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 210 seq = 2 text = 'indicate that Adaptive Server has some resource contention. Run sp_monitor or sp_sysmon,'(279) ).
    161 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 210 seq = 3 text = 'or query monEngine to determine if Adaptive Server has sufficient CPU resources.'(280) ).
    162 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 214 seq = 1 text = 'Busy servers typically have high values for Waits. However, high values for WaitTime or the time slice'(285) ).
    163 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 214 seq = 2 text = 'setting may indicate that Adaptive Server has a large number of spids waiting to execute, or that is'(286) ).
    164 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 214 seq = 3 text = 'has spids running which were heavily CPU bound and are not readily yielding their CPU.'(287) ).
    165 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 214 seq = 4 text = 'Query monProcessActivity to identify jobs that have high CPUTime.'(288) ).
    166 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 215 seq = 1 text = 'Event 215 is a common wait event. The value for Waits for event 215 is typically large.'(292) ).
    167 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 215 seq = 2 text = 'Busy servers have high values for WaitTime because processes are waiting for the Adaptive Server runnable'(293) ).
    168 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 215 seq = 3 text = 'queue for a long time. Reduce the value for time slice to allow more processes to access CPU (this'(294) ).
    169 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 215 seq = 4 text = 'also reduces the average time some processes spend in the CPU) or, if there are sufficient CPUs available'(295) ).
    170 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 215 seq = 5 text = 'on the host machine, increase the number of online engines.'(296) ).
    171 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 222 seq = 1 text = 'Depending on the level of activity within a replicated database, event 222 may typically have high values'(300) ).
    172 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 222 seq = 2 text = 'for WaitTime. Typically, you need not perform any actions for this event.'(301) ).
    173 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 250 seq = 1 text = 'Because event 250 occurs before Adaptive Server processes each command from a client, the number of Waits'(304) ).
    174 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 250 seq = 2 text = 'and WaitTime may typically be high. You can use event 250 to estimate how many requests the server has'(305) ).
    175 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 250 seq = 3 text = 'handled from clients. A high WaitTime value for this event can indicate a large number of idle client'(306) ).
    176 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 250 seq = 4 text = 'connections, or that some client connections remain idle for a long period of time.'(307) ).
    177 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 250 seq = 5 text = 'This wait event can occur between batches or commands sent by the client application, so the Waits value'(308) ).
    178 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 250 seq = 6 text = 'may be high if applications submit a large number of separate commands or batches.'(309) ).
    179 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 251 seq = 1 text = 'Event 251 may indicate that Adaptive Server is sending large reply sets to clients, or it may indicate'(311) ).
    180 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 251 seq = 2 text = 'a slow or overloaded network. Check the average packet size in the monNetworkIO and monProcessNetIO tables.'(312) ).
    181 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 251 seq = 3 text = 'In each of these tables, the average size is: (BytesSent) / (PacketsSent) Increasing the client application#s'(313) ).
    182 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 251 seq = 4 text = 'network packet size may improve network performance.'(314) ).
    183 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 259 seq = 1 text = 'A high value for Waits for this event may indicate that some databases need larger log segments.'(318) ).
    184 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 259 seq = 2 text = 'A high value for the average WaitTime may indicate that you have not defined a threshold procedure, or'(319) ).
    185 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 259 seq = 3 text = 'that a procedure is taking a long time to free log space. Increasing the frequency of transaction dumps'(320) ).
    186 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 259 seq = 4 text = 'on the database or allocating more space to the log segment may reduce the value for WaitTime.'(321) ).
    187 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 260 seq = 1 text = 'When a process uses a waitfor command, Adaptive Server puts it to sleep until the requested time'(323) ).
    188 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 260 seq = 2 text = 'expires. Event 260 measures this amount of sleep time.'(324) ).
    189 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 266 seq = 1 text = 'To evaluate event 266, determine the number of parallel queries that were run from monSysWorkerThread.ParallelQueries.'(328) ).
    190 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 266 seq = 2 text = 'If the value for WaitTime is high per query, Adaptive Server may have a resource shortage (generally,'(329) ).
    191 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 266 seq = 3 text = 'CPU time). A high WaitTime value may also indicate unbalanced partitions on objects, causing some worker'(330) ).
    192 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 266 seq = 4 text = 'threads to wait for others to complete.'(331) ).
    193 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 272 seq = 1 text = 'Typically, the average value for WaitTime for event 272 is quite low. A high value for average WaitTime'(335) ).
    194 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 272 seq = 2 text = 'may indicate high wait times for other events, forcing the ULC lock holder to wait.'(336) ).
    195 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 272 seq = 3 text = 'You can analyze other wait events to determine what is causing these waits.'(337) ).
    196 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 334 seq = 1 text = 'The value for WaitTime should be low when processes execute properly. If this is not the case, contact'(342) ).
    197 Class Method  CL_SYB_DOCU - ADD_ACTION_DESCR SYB: Simple store of extended documentation texts SOURCE add_action_descr( id = 334 seq = 2 text = 'Sybase Technical Support.'(343) ).
    198 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 19 seq = 1 text = 'The Adaptive Server transaction coordinator (ASTC) sleeps, waiting for an alarm or a server task to wake'(001) ).
    199 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 19 seq = 2 text = 'it (ASTC handles transactions involving multiple database servers). If the server does not perform many'(002) ).
    200 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 19 seq = 3 text = 'distributed transactions, the time per wait for this event is close to 60 seconds.'(003) ).
    201 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 29 seq = 1 text = 'A wait caused by a physical read (most likely a cache miss) which occurs when Adaptive Server does not'(005) ).
    202 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 29 seq = 2 text = 'find a page in the data cache and must read it from disk. The number of Waits is the number of physical'(006) ).
    203 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 29 seq = 3 text = 'reads that occurred because of a cache miss. Use the monSysWaits.WaitTime value to derive I/O response'(007) ).
    204 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 29 seq = 4 text = 'times'(008) ).
    205 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 30 seq = 1 text = 'Adaptive Server is attempting to write to a memory address space segment (MASS).'(020) ).
    206 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 30 seq = 2 text = 'A MASS is one or more contiguous pages Adaptive Server keeps in a data cache.'(021) ).
    207 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 30 seq = 3 text = 'However, in this event, the status of the MASS is #changing, # meaning another spid is updating the MASS.'(022) ).
    208 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 30 seq = 4 text = 'The spid initiating the write cannot write to the MASS until the MASS is no longer in use.'(023) ).
    209 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 31 seq = 1 text = 'A server process responsible for writing data pages to the disk (for example, a checkpoint) has determined'(028) ).
    210 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 31 seq = 2 text = 'that it must write a MASS. However, an earlier write operation involving the same page has not'(029) ).
    211 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 31 seq = 3 text = 'finished, so the second process must wait until the first write completes before initiating its'(030) ).
    212 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 31 seq = 4 text = 'write operation.'(031) ).
    213 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 32 seq = 1 text = 'When Adaptive Server issues an asynchronous prefetch (APF) on a page, another process is reading the'(038) ).
    214 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 32 seq = 2 text = 'MASS to which this page belongs. Adaptive Server must wait for the read to complete before continuing.'(039) ).
    215 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 35 seq = 1 text = 'Indicates that a process is attempting to read data in a page that another process has read into cache.'(044) ).
    216 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 35 seq = 2 text = 'After reading a page into a data cache, Adaptive Server validates the success of the read operation.'(045) ).
    217 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 35 seq = 3 text = 'Because Adaptive Server is validating whether the read was successful, the second process must'(046) ).
    218 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 35 seq = 4 text = 'wait for this to complete before accessing the data.'(047) ).
    219 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 36 seq = 1 text = 'A spid must make changes to a MASS, but another spid is currently writing the MASS.'(051) ).
    220 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 36 seq = 2 text = 'The second spid must wait until the write completes.'(052) ).
    221 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 37 seq = 1 text = 'A spid attempts to make changes to the MASS, but another spid is currently changing the MASS.'(059) ).
    222 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 37 seq = 2 text = 'The first spid must wait until the changes are complete before it can make changes to the MASS.'(060) ).
    223 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 41 seq = 1 text = 'Event 41 often indicates that multiple processes are simultaneously attempting to update rows on a single'(065) ).
    224 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 41 seq = 2 text = 'page.'(066) ).
    225 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 46 seq = 1 text = 'A spid attempts to acquire a buffer from the least recently used (LRU) chain.'(078) ).
    226 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 46 seq = 2 text = 'However, the buffer has an outstanding write that must finish before Adaptive Server can use the buffer'(079) ).
    227 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 46 seq = 3 text = 'for a different page.'(080) ).
    228 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 51 seq = 1 text = 'Occurs when a process is writing a range of pages for an object to disk because of a change to the object'(087) ).
    229 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 51 seq = 2 text = 'or because the object is removed from the metadata cache. Because it is important to complete the I/O'(088) ).
    230 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 51 seq = 3 text = 'operations on some pages before other pages are written, the process must wait until it is notified that'(089) ).
    231 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 51 seq = 4 text = 'the I/O that was initiated has completed its task.'(090) ).
    232 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 52 seq = 1 text = 'A process writes a range of pages for an object to disk because of a change to the object, or because'(094) ).
    233 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 52 seq = 2 text = 'the object was removed from the metadata cache. However, another spid has an I/O outstanding on the MASS,'(095) ).
    234 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 52 seq = 3 text = 'and the second process must sleep until the first process#s finish writing.'(096) ).
    235 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 53 seq = 1 text = 'A spid attempts to write to a MASS, but another spid is already changing the MASS, so the first spid'(100) ).
    236 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 53 seq = 2 text = 'must wait until the changes are complete.'(101) ).
    237 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 54 seq = 1 text = 'Event 54 occurs when a process is about to initiate a write of the last log page but discovers another'(106) ).
    238 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 54 seq = 2 text = 'process is already scheduled to perform write. The second process waits until the first process'(107) ).
    239 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 54 seq = 3 text = 'finishes its I/O, but the second process does not initiate the I/O operation.'(108) ).
    240 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 55 seq = 1 text = 'Indicates a process has initiated a write operation on the last page of the transaction log, and'(115) ).
    241 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 55 seq = 2 text = 'must sleep until the I/O completes. A high value for the Waits column for event 55 indicates that Adaptive'(116) ).
    242 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 55 seq = 3 text = 'Server is making a large number of updates to the transaction log because of committed transactions or'(117) ).
    243 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 55 seq = 4 text = 'other operations that requiring writing the transasction log to disk.'(118) ).
    244 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 57 seq = 1 text = 'The checkpoint process sleeps between runs to prevent the checkpoint from monopolizing CPU time.'(121) ).
    245 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 61 seq = 1 text = 'The housekeeper pauses occasionally to keep housekeeper functions from monopolizing CPU time.'(124) ).
    246 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 70 seq = 1 text = 'If you are using Adaptive Server mirroring (that is, disable disk mirroring is set to 0), each'(127) ).
    247 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 70 seq = 2 text = 'disk device access must first hold the semaphore for that device. Event 70 measures the time spent waiting'(128) ).
    248 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 70 seq = 3 text = 'for that semaphore and can occur if disk I/O structures are too low.'(129) ).
    249 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 83 seq = 1 text = 'A object descriptor (called a #DES#) is allocated for every open object (temporary tables, cached query'(134) ).
    250 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 83 seq = 2 text = 'plans and statement cache, stored procedures, triggers, defaults, rules, tables, and so on).'(135) ).
    251 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 83 seq = 3 text = 'Event 83 occurs when Adaptive Server is releasing an allocated descriptor, which typically happens when'(136) ).
    252 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 83 seq = 4 text = 'Adaptive Server is dropping an object.'(137) ).
    253 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 84 seq = 1 text = 'Adaptive Server is dropping a DES, which typically occurs when Adaptive Server is dropping an object.'(140) ).
    254 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 84 seq = 2 text = 'Event 84 indicates that the drop must wait for a checkpoint to complete on the database.'(141) ).
    255 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 85 seq = 1 text = 'When Adaptive Server runs dump database, it uses the #flusher# process to create lists of pages'(146) ).
    256 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 85 seq = 2 text = '(which includes a structure called DFLPIECE) that are in a data cache and have been changed.'(147) ).
    257 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 85 seq = 3 text = 'Adaptive Server sends the Backup Server a list of pages to include in the dump.'(148) ).
    258 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 91 seq = 1 text = 'When Adaptive Server runs load database, it may require the load process to verify that a disk'(151) ).
    259 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 91 seq = 2 text = 'I/O has completed before continuing. Event 91 measures the time Adaptive Server spends waiting for verification.'(152) ).
    260 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 99 seq = 1 text = 'When a process uses a site handler to connect to a remote server, it must occasionally wait for the server'(156) ).
    261 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 99 seq = 2 text = 'to return the data. Event 99 measures the time the process must wait.'(157) ).
    262 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 104 seq = 1 text = 'Adaptive Server has a service process that cleans up issues after an engine goes offline.'(161) ).
    263 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 104 seq = 2 text = 'This process typically sleeps, waking up every 30 seconds to check for work to do.'(162) ).
    264 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 104 seq = 3 text = 'Event 10 4 measures that sleep time.'(163) ).
    265 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 124 seq = 1 text = 'Event 124 occurs when a process attempts to perform a physical read but another process has already performed'(168) ).
    266 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 124 seq = 2 text = 'the read request (this also counts as a #cache miss#).'(169) ).
    267 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 142 seq = 1 text = 'When Adaptive Server executes an RPC on a remote serer using the site handler mechanism, it creates logical'(173) ).
    268 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 142 seq = 2 text = 'connections.'(174) ).
    269 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 143 seq = 1 text = 'Adaptive Server communicates with a remote server using a site manager, but of another process is attempting'(177) ).
    270 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 143 seq = 2 text = 'to connect to that remote server. Event 143 measures the amount of time Adaptive Server waits to establish'(178) ).
    271 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 143 seq = 3 text = 'the connection to the remote server.'(179) ).
    272 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 150 seq = 1 text = 'A process attempts to obtain a logical lock on an object but another process is already holding a conflicting'(183) ).
    273 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 150 seq = 2 text = 'lock on this object. Event 150 is a common event that occurs when Adaptive Server performs an operation'(184) ).
    274 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 150 seq = 3 text = 'that requires locks to protect data that is being read or updated. The locks involved may be at various'(185) ).
    275 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 150 seq = 4 text = 'levels, including table, page, or row.'(186) ).
    276 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 157 seq = 1 text = 'The Adaptive Server memory manager allocates memory for storing data describing a wide range of internal'(193) ).
    277 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 157 seq = 2 text = 'objects from separate memory #pools.# When a pool#s available memory is low, requests for additional'(194) ).
    278 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 157 seq = 3 text = 'memory may be delayed until another operation returns memory to the pool.'(195) ).
    279 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 157 seq = 4 text = 'When this occurs, the requesting process must wait until more memory is available.'(196) ).
    280 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 169 seq = 1 text = 'Some Adaptive Server processes (for example, worker threads, auditing, disk mirroring, and so on) use'(202) ).
    281 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 169 seq = 2 text = 'a structure called a #mailbox# to pass messages. Event 169 measures the time Adaptive Server spends waiting'(203) ).
    282 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 169 seq = 3 text = 'for a message in a mailbox.'(204) ).
    283 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 171 seq = 1 text = 'Indicates that Adaptive Server is waiting for the remote server to respond.'(208) ).
    284 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 171 seq = 2 text = 'Event 171 appears if you use Component Integration Services (CIS) for proxy tables and RPC calls.'(209) ).
    285 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 178 seq = 1 text = 'A network listener is an Adaptive Server process that handles a client#s incoming connection requests.'(213) ).
    286 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 178 seq = 2 text = 'Event 178 measures the time Adaptive Server spends waiting for new connection requests.'(214) ).
    287 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 179 seq = 1 text = 'The Adaptive Server network task sleeps on event 179 if there is no network I/O the server must send'(218) ).
    288 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 179 seq = 2 text = 'or receive. When there is network activity, the server task wakes, handles the requests, and then goes'(219) ).
    289 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 179 seq = 3 text = 'back to sleep.'(220) ).
    290 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 197 seq = 1 text = 'When you run dbcc checkstorage, Adaptive Server must occasionally perform asynchronous I/O on'(226) ).
    291 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 197 seq = 2 text = 'the workspace to read or write a single reserved buffer. Event 197 measures the time Adaptive Server'(227) ).
    292 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 197 seq = 3 text = 'waits for those disk I/Os.'(228) ).
    293 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 200 seq = 1 text = 'Event 200 occurs when you run dbcc checkstorage using multiple worker processes.'(232) ).
    294 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 200 seq = 2 text = 'This event measures the time spent waiting for reads to complete on pages that dbcc checks.'(233) ).
    295 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 201 seq = 1 text = 'When you run dbcc checkverify, Adaptive Server performs a disk read to verify whether a potential'(237) ).
    296 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 201 seq = 2 text = 'fault exists in the disk copy of a page; event 201 measures the time spent waiting for those reads to'(238) ).
    297 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 201 seq = 3 text = 'complete.'(239) ).
    298 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 202 seq = 1 text = 'When you run dbcc checkstorage, Adaptive Server determines whether it needs to perform a disk'(243) ).
    299 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 202 seq = 2 text = 'read to verify whether a potential fault exists in the disk copy of a page; event 202 measures the time'(244) ).
    300 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 202 seq = 3 text = 'spent waiting for those reads to complete.'(245) ).
    301 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 203 seq = 1 text = 'When you run dbcc checkstorage, Adaptive Server determines whether it needs to perform a disk'(249) ).
    302 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 203 seq = 2 text = 'read to verify whether a fault exists in the disk copy of the MASS. However, another process may have'(250) ).
    303 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 203 seq = 3 text = 'already started that read. Event 203 measures the time spent waiting for those reads to complete.'(251) ).
    304 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 205 seq = 1 text = 'When you run dbcc checkstorage to check text and image pages, Adaptive Server must hold a lock'(255) ).
    305 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 205 seq = 2 text = 'to prevent multiple worker threads from accessing the page links at the same time.'(256) ).
    306 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 205 seq = 3 text = 'Event 205 measures the time spent waiting for those locks.'(257) ).
    307 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 207 seq = 1 text = 'When you run dbcc checkstorage, each worker process reports possible faults to the parent process'(261) ).
    308 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 207 seq = 2 text = 'by queuing messages to the parent spid. If the mailbox of the parent process is full, the worker process'(262) ).
    309 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 207 seq = 3 text = 'must wait for more room in the mailbox before it can queue the next message.'(263) ).
    310 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 207 seq = 4 text = 'Event 207 measures the time the worker process spends waiting.'(264) ).
    311 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 209 seq = 1 text = 'When Adaptive Server performs a sort in parallel (for example, create index that specifies a consumers'(268) ).
    312 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 209 seq = 2 text = 'clause), it uses an internal mechanism to send data between the various tasks.'(269) ).
    313 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 209 seq = 3 text = 'Event 209 measures the amount of time the tasks spend waiting for other tasks to add data to a pipe.'(270) ).
    314 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 210 seq = 1 text = 'When Adaptive Server performs a sort in parallel (for example, create index that specifies a consumers'(275) ).
    315 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 210 seq = 2 text = 'clause), it uses an internal mechanism, called a pipe, to send data between the various tasks.'(276) ).
    316 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 210 seq = 3 text = 'Event 210 measures the amount of time a process waits for Adaptive Server to allocate a free pipe buffer.'(277) ).
    317 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 214 seq = 1 text = 'Event 214 measures the amount of time a process waits on the run queue after yielding to allow other'(281) ).
    318 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 214 seq = 2 text = 'processes to run. This process is #runnable, # not waiting on a lock, physical I/O, or any other wait'(282) ).
    319 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 214 seq = 3 text = 'condition. This event may be caused by insufficient CPU (that is, the server is CPU bound) or table scans'(283) ).
    320 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 214 seq = 4 text = 'in memory.'(284) ).
    321 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 215 seq = 1 text = 'Event 215 occurs when a process is no longer waiting for another wait event (for example, a logical lock,'(289) ).
    322 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 215 seq = 2 text = 'disk I/O, or another wait event) and is placed on the server#s runnable queue.'(290) ).
    323 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 215 seq = 3 text = 'The process must wait until the scheduler allocates CPU time before continuing its task.'(291) ).
    324 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 222 seq = 1 text = 'If Adaptive Server is a primary server performing replication, the RepAgent process sleeps, waiting for'(297) ).
    325 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 222 seq = 2 text = 'work to do (for example, when rows are added to the log for a database).'(298) ).
    326 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 222 seq = 3 text = 'Event 222 measures the amount of time RepAgent spends asleep.'(299) ).
    327 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 250 seq = 1 text = 'This event measures the time that application processes are active, but waiting for the next request'(302) ).
    328 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 250 seq = 2 text = 'from a client (that is, when jobs are in the AWAITING COMMAND state).'(303) ).
    329 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 251 seq = 1 text = 'Event 251 measures the amount of time a job waits while sending a reply packet back to a client.'(310) ).
    330 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 259 seq = 1 text = 'When Adaptive Server crosses a last-chance threshold for a database log, every process trying to allocate'(315) ).
    331 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 259 seq = 2 text = 'more log space receives message 7415, and is put to sleep, or suspended, while it waits for available'(316) ).
    332 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 259 seq = 3 text = 'log space. Event 259 measures the amount of time the process waits for this space.'(317) ).
    333 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 260 seq = 1 text = 'Event 260 is normal and expected when processes use the waitfor command.'(322) ).
    334 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 266 seq = 1 text = 'Adaptive Server worker threads communicate with each other and the parent spid through an internal Adaptive'(325) ).
    335 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 266 seq = 2 text = 'Server mechanism called a mailbox. Event 266 measures the amount of time a worker process spends waiting'(326) ).
    336 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 266 seq = 3 text = 'for its mailbox to add a message.'(327) ).
    337 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 272 seq = 1 text = 'Each process allocates a user log cache (ULC) area, which is used to reduce contention on the last log'(332) ).
    338 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 272 seq = 2 text = 'page. Adaptive Server uses a lock to protect the ULC since more than one process can access the records'(333) ).
    339 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 272 seq = 3 text = 'of a ULC and force a flush. Event 272 measures the time the ULC spends waiting for that lock.'(334) ).
    340 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 334 seq = 1 text = 'Adaptive Server version 15.0 introduced the lava query execution engine.'(338) ).
    341 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 334 seq = 2 text = 'When this engine executes a parallel query, it uses an internal structure called a #pipe buffer# to pass'(339) ).
    342 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 334 seq = 3 text = 'data between the worker processes. Event 334 measures the amount of time Adaptive Server spends waiting'(340) ).
    343 Class Method  CL_SYB_DOCU - ADD_EVENT_DESCR SYB: Simple store of extended documentation texts SOURCE add_event_descr( id = 334 seq = 4 text = 'for a pipe buffer to be available.'(341) ).
    344 Class Method  CL_SYB_DOCU - CONSTRUCTOR SYB: Simple store of extended documentation texts SOURCE create object _instance.