Database | Proc | Application | Created | Links |
sybsystemprocs | sp_sysmon_dcache | 31 Aug 14 | Defects Dependencies |
1 2 /* This stored procedure produces a report containing a summary of 3 ** of how user defined caches and buffer pools are being used. 4 */ 5 6 create procedure sp_sysmon_dcache 7 @NumEngines tinyint, /* number of engines online */ 8 @NumElapsedMs int, /* for "per Elapsed second" calculations */ 9 @NumXacts int, /* for per transactions calculations */ 10 @Reco char(1), /* Flag for recommendations */ 11 @instid smallint = NULL /* optional SDC instance id */ 12 13 as 14 15 exec sp_sysmon_dcache_sum @NumEngines, @NumElapsedMs, @NumXacts, @Reco, @instid 16 17 exec sp_sysmon_dcache_dtl @NumEngines, @NumElapsedMs, @NumXacts, @Reco 18 19 return 0 20
exec sp_procxmode 'sp_sysmon_dcache', 'AnyMode' go Grant Execute on sp_sysmon_dcache to public go
DEFECTS | |
MGTP 3 Grant to public sybsystemprocs..sp_sysmon_dcache | |
MNER 3 No Error Check should check return value of exec | 15 |
MNER 3 No Error Check should check return value of exec | 17 |
MTR1 2 Metrics: Comments Ratio Comments: 39% | 6 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2 | 6 |
MTR3 2 Metrics: Query Complexity Complexity: 4 | 6 |
DEPENDENCIES |
PROCS AND TABLES USED calls proc sybsystemprocs..sp_sysmon_dcache_dtl reads table tempdb..#tempmonitors (1) reads table tempdb..#cachemap (1) reads table tempdb..#pool_detail_per_cache (1) read_writes table tempdb..#foo (1) calls proc sybsystemprocs..sp_sysmon_dcache_sum reads table tempdb..#tempmonitors (1) reads table master..sysconfigures (1) CALLERS called by proc sybsystemprocs..sp_sysmon_analyze called by proc sybsystemprocs..sp_sysmon |