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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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:
|
14 | ![]() |
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 |
15 | ![]() |
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) |
16 | ![]() |
CL_SYB_DOCU - ADD_ACTION_DESCR | SYB: Simple store of extended documentation texts | SOURCE add_action_descr( id = 30 seq = 4 text = 'washmarker |
17 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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:
|
44 | ![]() |
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. |
45 | ![]() |
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 | ![]() |
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 | ![]() |
CL_SYB_DOCU - ADD_ACTION_DESCR | SYB: Simple store of extended documentation texts | SOURCE add_action_descr( id = 41 seq = 8 text = ' |
48 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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:
|
52 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
CL_SYB_DOCU - ADD_ACTION_DESCR | SYB: Simple store of extended documentation texts | SOURCE add_action_descr( id = 46 seq = 5 text = ' |
56 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
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 | ![]() |
CL_SYB_DOCU - CONSTRUCTOR | SYB: Simple store of extended documentation texts | SOURCE create object _instance. |