Batch Analysis Report

www.sqlbrowser.com

SQLBrowserSQLBrowser 1496 Registered Ngx @ DELL SINGLE
DateSun May 13 16:21:57 CEST 2018
ASE NameHPH8NGX_157_ISO1NOCASE (HP_H8_NGX:5700)
ASE VersionAdaptive Server Enterprise/15.7.0/EBF 19498 SMP /P/NT (IX86)/Windows 2008 R2/ase157/2820/32-bit/OPT/Thu Sep 15 21:23:19 2011
JConnectjConnect (TM) for JDBC(TM)/7.07 SP130 (Build 27074)/P/EBF23283/JDK 1.6.0/jdbcmain/OPT/Mon Jul 21 12:39:01 PDT 2014
Java1.8.0_102
DB Scanned[sybsystemprocs]
Object Count1,599
Object CRDatenull
Defect Count30,289
Analysis Time1 minutes (20 s)
Memory24 Mb / 457 Mb

DatabaseProcsTablesViewsTriggersFunctionsRulesDefaultsUnscanned
master   59/152     117/176
sybsystemdb   2/32     31/33
sybsystemprocs  599/60835/361 1  10/646
tempdb   532/29     27/30


Defects
 MBPA 6 Not a parameter of this proc21
 MURC 6 Unreachable Code42
 PERR 6 Parsing Error83
 QBGB 6 Bad group by8
 QCAR 6 Cartesian product40
 MRIT 5 Return in Transaction19
 QJWI 5 Join or Sarg Without Index326
 MBRV 4 Bad return value [-1-99]14
 MCPC 4 Copy Paste Code668
 MCTR 4 Conditional Begin Tran or Commit Tran124
 MEST 4 Empty String will be replaced by Single Space578
 MINU 4 Unique Index with nullable columns13
 MMCN 4 Potentially Misleading Column Naming1
 MPSI 4 Possible SQL Injection8
 MTYP 4 Assignment type mismatch575
 MULT 4 Using literal database 'tempdb'88
 MUSP 4 Unquoted String Parameter229
 QCAS 4 Cartesian product with single row57
 QCSC 4 Costly 'select count()', use 'exists()'40
 QPR1 4 Potential Recompilation: index creation after access to table1
 QPUI 4 Join or Sarg with Un-Rooted Partial Index Use457
 QTYP 4 Comparison type mismatch2712
 QUDW 4 Update or delete with no where clause3
 TNOI 4 Table with no index47
 TNOU 4 Table with no unique index6
 VOVR 4 Variable is an input param and is overwritten1
 VRUN 4 Variable is read and not initialized25
 VUWR 4 Variable is an output param and is not written to3
 CUNU 3 Cursor not updated: cursor should contain 'for read only' clause91
 CUSU 3 Cursor updated through 'searched update': risk of halloween rows11
 CUUP 3 Cursor updated: cursor should contain 'for update' clause2
 MBLI 3 Integer Value of Binary Literal is Platform Dependant210
 MDYN 3 Proc uses Dynamic SQL but is not flagged with Dynamic Ownership Chain31
 MGTP 3 Grant to public622
 MLCH 3 Char type with length>30213
 MNAC 3 Not using ANSI 'is null'84
 MNEJ 3 'Not Equal' join13
 MNER 3 No Error Check4155
 MUBC 3 Unbalanced begin tran/commit tran3
 MUCO 3 Useless Code7955
 MUIN 3 Column created using implicit nullability171
 MUOT 3 Updates outside transaction41
 MUPK 3 Update column which is part of a PK or unique index21
 MUTI 3 Update temptable with identity - 12.5.4 Regression13
 MUUF 3 Update or Delete with Useless From Clause24
 MZMB 3 Zombie: use of non-existent object103
 QAFM 3 Var Assignment from potentially many rows924
 QAPT 3 Access to Proxy Table60
 QCRS 3 Conditional Result Set282
 QCTC 3 Conditional Table Creation230
 QDIS 3 Check correct use of 'select distinct'64
 QFAP 3 Force abstract plan21
 QFID 3 Force index18
 QGWO 3 Group by/Distinct/Union without order by105
 QISO 3 Set isolation level327
 QIWC 3 Insert with not all columns specified145
 QJWT 3 Join or Sarg Without Index on temp table258
 QMTB 3 From clause with many tables1
 QNAJ 3 Not using ANSI Inner Join689
 QNAM 3 Select expression has no name60
 QNAO 3 Not using ANSI Outer Join71
 QNCO 3 No column in result set2
 QNUA 3 Should use Alias:875
 QPNC 3 No column in condition134
 QPRI 3 Join or Sarg with Rooted Partial Index Use937
 QPSC 3 Join on same column2
 QRPR 3 Repeated predicate5
 QSWV 3 Sarg with variable242
 QTJ1 3 Table only appears in inner join clause44
 QTLO 3 Top-Level OR40
 QUNI 3 Check Use of 'union' vs 'union all'38
 VNRD 3 Variable is not read360
 VUNU 3 Variable is not used481
 CRDO 2 Read Only Cursor Marker70
 CUPD 2 Updatable Cursor Marker101
 MDRV 2 Derived Table Marker10
 MDYE 2 Dynamic Exec Marker65
 MDYS 2 Dynamic SQL Marker80
 MRST 2 Result Set Marker369
 MSTT 2 Shared Temptable Marker270
 MSUB 2 Subquery Marker1033
 MSUC 2 Correlated Subquery Marker121
 MTR1 2 Metrics: Comments Ratio601
 MTR2 2 Metrics: Cyclomatic Complexity601
 MTR3 2 Metrics: Query Complexity601

Statistics per
Database
DB
Size
Table
Count
Avg
Size
Tot
Size
Avg
Rows
Tot
Rows
Avg
Cols
Tot
Cols
Proc
Count
Avg
Lines
Tot
Lines
Avg
Bytes
Tot
Bytes
Avg
Cyclo
Avg
Cmplx
Tot
Exec
Tot
Sel
Tot
Ins
Tot
Upd
Tot
Del
Tot
If
Tot
While
master  13 MB59 27 KB1.5 MB222 13 K14 845               
sybsystemdb  6 MB2 2 KB4 KB  14 28               
sybsystemprocs  172 MB35 2.5 MB88 MB2.6 K92 K15 525 600 271 159 K7.6 K4.5 M21 115 2.7 K369 948 490 179 7.8 K340
tempdb  104 MB                     
TOTAL295 MB96 956 K90 M1.1 K105 K15 1.4 K600 271 159 K7.6 K4.5 M21 67 K2.7 K369 948 669  7.8 K340

Timings
Directories0 s 31 ms
Procs Params0 s 47 ms
Pass 118 s 282 ms
Copy Paste0 s 193 ms
Database Switch Detector0 s 60 ms
Dependencies.txt0 s 36 ms
Dependencies2.txt0 s 18 ms
Dependencies3.txt0 s 15 ms
Patching TempTables0 s 62 ms
Schema.xml0 s 36 ms
Drawings1 s 140 ms
Tables0 s 371 ms
Dependencies0 s 266 ms
Main Indexes0 s 619 ms
Dumping Text Files0 s 0 ms

Dependencies Depth Counters Applications
All Objects Referenced Unreferenced
Tables Column Usage Sargs
Dependecies ZIP
SchemaFK ZIP
Defects
Log File