This is the derivation service. Its most useful attributes are:
Search the file for: with .* derivation rulettes. The results should resemble the following:
DATA_DRIVEN with 115 derivation rulettes
DATA_DRIVEN with 115 derivation rulettes
DATA_DRIVEN with 187230 derivation rulettes
DATA_DRIVEN with 97 derivation rulettes
DATA_DRIVEN with 115 derivation rulettes
The third line (187230 derivation rulettes) indicates an issue because the number of derivation rulettes is significantly larger than any other rulettes listed. Locate the complex derivation definition (located above the with .* derivation rulettes section in the file), and make a note of the topology type and metric name. For example:
where DBSS_Top_Sql is the topology type and DBSS_Total_Elapsed_Time_Per_Exec is the metric name.
The topology table has the following six columns:
For example, consider the sample rows of the topology table below:
| DBO_Alert_Log | 76 | 2 | 38 | 76 | 38 |
| DBO_Datafile | 5816 | 2 | 2908 | 2 | 1 |
| DBO_Undo_Activity_Info | 393761 | 16810 | 39 | 0 | 0 |
| HostNetwork | 238231 | 4472 | 846 | 234543 | 42 |
| VMWESXServerPhysicalDisk | 28652 | 3 | 3530 | 10590 | 5295 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center