Database | Proc | Application | Created | Links |
sybsystemprocs | sp_monitor_procstack_usage | 31 Aug 14 | Defects Dependencies |
1 2 /* 3 ** sp_monitor_procstack_usage 4 ** 5 ** Generate help/usage information in terse/verbose mode. 6 { 7 */ 8 create procedure sp_monitor_procstack_usage(@output_type varchar(8) 9 ) as 10 begin 11 declare @sp_command varchar(80) 12 , @msg varchar(200) 13 , @indent varchar(5) 14 , @nl_indent varchar(6) -- newline followed by indent 15 16 print " " 17 exec sp_getmessage 18954, @msg output 18 19 select @sp_command = @msg + " sp_monitor 'procstack' [, '<spid>'] [, '<contextblock>' ]" 20 print @sp_command 21 if (@output_type = 'terse') 22 return 23 24 select @indent = " -- " 25 select @nl_indent = char(10) + @indent 26 27 print " " 28 exec sp_getmessage 19494, @msg output 29 select @sp_command = "sp_monitor 'enable', " + "'procstack'" 30 print @msg, @sp_command 31 32 print " " 33 exec sp_getmessage 19495, @msg output 34 print @msg, @indent, @nl_indent 35 print " sp_monitor 'procstack', '<spid>'" 36 37 print " " 38 exec sp_getmessage 19496, @msg output 39 print @msg, @indent 40 print " declare @spid_str varchar(5)" 41 print " select @spid_str = convert(varchar, @@spid)" 42 print " exec sp_monitor 'procstack', @spid_str, '10'" 43 end 44
exec sp_procxmode 'sp_monitor_procstack_usage', 'AnyMode' go Grant Execute on sp_monitor_procstack_usage to public go
DEFECTS | |
MGTP 3 Grant to public sybsystemprocs..sp_monitor_procstack_usage | |
MNER 3 No Error Check should check return value of exec | 17 |
MNER 3 No Error Check should check return value of exec | 28 |
MNER 3 No Error Check should check return value of exec | 33 |
MNER 3 No Error Check should check return value of exec | 38 |
MUCO 3 Useless Code Useless Brackets in create proc | 8 |
MUCO 3 Useless Code Useless Begin-End Pair | 10 |
MUCO 3 Useless Code Useless Brackets | 21 |
MTR1 2 Metrics: Comments Ratio Comments: 9% | 8 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 | 8 |
MTR3 2 Metrics: Query Complexity Complexity: 25 | 8 |
DEPENDENCIES |
PROCS AND TABLES USED calls proc sybsystemprocs..sp_getmessage reads table sybsystemprocs..sysusermessages reads table master..sysmessages (1) reads table master..syslanguages (1) calls proc sybsystemprocs..sp_validlang reads table master..syslanguages (1) |