DatabaseProcApplicationCreatedLinks
sybsystemprocssp_sysmon_dcache  31 Aug 14Defects 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