Database | Proc | Application | Created | Links |
sybsystemprocs | sp_flushmetrics | 31 Aug 14 | Defects 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 |