DatabaseProcApplicationCreatedLinks
sybsystemprocssp_flushmetrics  31 Aug 14Defects Dependencies

1     
2     /*
3     ** sp_flushmetrics
4     **
5     ** Dump metrics in memory to system catalog
6     ** Requires Galaxy or later
7     **
8     */
9     
10    create procedure sp_flushmetrics
11    as
12    
13        if @@trancount = 0
14        begin
15            set chained off
16        end
17    
18        set transaction isolation level 1
19    
20        dbcc traceon(3604)
21        dbcc flushmetrics
22        dbcc traceoff(3604)
23    
24        return (0)
25    


exec sp_procxmode 'sp_flushmetrics', 'AnyMode'
go

Grant Execute on sp_flushmetrics to public
go
DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_flushmetrics  
 MUCO 3 Useless Code Useless Brackets 24
 QISO 3 Set isolation level 18
 MTR1 2 Metrics: Comments Ratio Comments: 19% 10
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 10
 MTR3 2 Metrics: Query Complexity Complexity: 9 10

DEPENDENCIES
CALLERS
called by proc sybsystemprocs..sp_metrics