Batch Analysis Report

www.sqlbrowser.com

SQLBrowserSQLBrowser 1404 Registered Ngx1 (1/3) 3 USERS DEC2015 @ SQLBrowser HP8 V3 F
DateFri Jan 08 20:01:22 CET 2016
ASE NameHPH8NGX_160 (HP_H8_NGX:6100)
ASE VersionAdaptive Server Enterprise/16.0 GA PL01/EBF 22540 SMP/P/X64/Windows Server/ase160sp00pl01/3523/64-bit/FBO/Tue Apr 15 19:04:17 2014
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.7.0_80
DB Scanned[master, sybsystemdb, sybsystemprocs, tempdb]
Object Count1'893
Object CRDatenull
Defect Count36'171
Analysis Time1 minutes (25 s)
Memory128 Mb / 375 Mb

DatabaseProcsTablesViewsTriggersFunctionsRulesDefaultsUnscanned
master  21162/1641/4    5/189
sybsystemdb   30/321    2/33
sybsystemprocs  632/64334/361 1/8  20/688
tempdb   596/301    2/31


Defects
 MBPA 6 Not a parameter of this proc21
 MURC 6 Unreachable Code42
 PERR 6 Parsing Error90
 QBGB 6 Bad group by4
 QCAR 6 Cartesian product39
 MRIT 5 Return in Transaction24
 QJWI 5 Join or Sarg Without Index385
 MBRV 4 Bad return value [-1-99]14
 MCPC 4 Copy Paste Code701
 MCTR 4 Conditional Begin Tran or Commit Tran146
 MEST 4 Empty String will be replaced by Single Space653
 MINU 4 Unique Index with nullable columns14
 MMCN 4 Potentially Misleading Column Naming1
 MPSI 4 Possible SQL Injection8
 MTYP 4 Assignment type mismatch654
 MULT 4 Using literal database 'tempdb'86
 MUSP 4 Unquoted String Parameter260
 QCAS 4 Cartesian product with single row57
 QCSC 4 Costly 'select count()', use 'exists()'47
 QPR1 4 Potential Recompilation: index creation after access to table1
 QPUI 4 Join or Sarg with Un-Rooted Partial Index Use519
 QTYP 4 Comparison type mismatch3157
 QUDW 4 Update or delete with no where clause3
 TNOI 4 Table with no index122
 TNOU 4 Table with no unique index6
 VOVR 4 Variable is an input param and is overwritten1
 VRUN 4 Variable is read and not initialized33
 VUWR 4 Variable is an output param and is not written to3
 CUNU 3 Cursor not updated: cursor should contain 'for read only' clause103
 CUSU 3 Cursor updated through 'searched update': risk of halloween rows11
 CUUP 3 Cursor updated: cursor should contain 'for update' clause2
 MAW1 3 Warning message on %name%1775
 MBLI 3 Integer Value of Binary Literal is Platform Dependant175
 MDYN 3 Proc uses Dynamic SQL but is not flagged with Dynamic Ownership Chain33
 MGTP 3 Grant to public617
 MLCH 3 Char type with length>30271
 MNAC 3 Not using ANSI 'is null'111
 MNEJ 3 'Not Equal' join13
 MNER 3 No Error Check4408
 MUBC 3 Unbalanced begin tran/commit tran4
 MUCO 3 Useless Code9486
 MUIN 3 Column created using implicit nullability172
 MUOT 3 Updates outside transaction50
 MUPK 3 Update column which is part of a PK or unique index28
 MUTI 3 Update temptable with identity - 12.5.4 Regression13
 MUUF 3 Update or Delete with Useless From Clause29
 MZMB 3 Zombie: use of non-existent object98
 QAFM 3 Var Assignment from potentially many rows999
 QAPT 3 Access to Proxy Table73
 QCRS 3 Conditional Result Set323
 QCTC 3 Conditional Table Creation274
 QDIS 3 Check correct use of 'select distinct'68
 QFAP 3 Force abstract plan25
 QFID 3 Force index18
 QGWO 3 Group by/Distinct/Union without order by130
 QISO 3 Set isolation level337
 QIWC 3 Insert with not all columns specified158
 QJWT 3 Join or Sarg Without Index on temp table139
 QMTB 3 From clause with many tables2
 QNAJ 3 Not using ANSI Inner Join749
 QNAM 3 Select expression has no name76
 QNAO 3 Not using ANSI Outer Join78
 QNCO 3 No column in result set2
 QNUA 3 Should use Alias:1117
 QPNC 3 No column in condition146
 QPRI 3 Join or Sarg with Rooted Partial Index Use1059
 QPSC 3 Join on same column6
 QRPR 3 Repeated predicate5
 QSWV 3 Sarg with variable259
 QTJ1 3 Table only appears in inner join clause43
 QTLO 3 Top-Level OR39
 QUNI 3 Check Use of 'union' vs 'union all'58
 VNRD 3 Variable is not read608
 VUNU 3 Variable is not used483
 CRDO 2 Read Only Cursor Marker76
 CUPD 2 Updatable Cursor Marker99
 MDRV 2 Derived Table Marker90
 MDYE 2 Dynamic Exec Marker72
 MDYS 2 Dynamic SQL Marker179
 MRST 2 Result Set Marker412
 MSTA 2 Use of Star Marker1
 MSTT 2 Shared Temptable Marker278
 MSUB 2 Subquery Marker1071
 MSUC 2 Correlated Subquery Marker155
 MTR1 2 Metrics: Comments Ratio658
 MTR2 2 Metrics: Cyclomatic Complexity658
 MTR3 2 Metrics: Query Complexity658

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  18 MB162 29 KB4.6 MB101 16 K15 2.3 K21 279 5.7 K7.8 K163 K30 119 59 26 10 18 3 349 7
sybsystemdb  9 MB30 4.4 KB132 KB29 862 16 475               
sybsystemprocs  196 MB34 2.8 MB96 MB3 K101 K16 527 633 283 175 K7.9 K4.9 M23 121 3.1 K386 1 K483 198 8.8 K347
tempdb  104 MB                     
TOTAL327 MB226 456 K101 M534 118 K17 3.7 K654 283 180 K7.9 K5.1 M23 77 K3.1 K412 1 K702  9.2 K354

Timings
Directories0 s 19 ms
Procs Params0 s 47 ms
Pass 114 s 753 ms
Copy Paste0 s 881 ms
Database Switch Detector0 s 337 ms
Dependencies.txt0 s 20 ms
Dependencies2.txt0 s 162 ms
Dependencies3.txt0 s 94 ms
Patching TempTables0 s 612 ms
Finding Writers0 s 4 ms
Finding Leaves0 s 18 ms
Write Analysis2 s 159 ms
Transitive Closure0 s 39 ms
Propagating Apps0 s 63 ms
Sorted Event Array0 s 93 ms
Schema.xml0 s 72 ms
Drawings2 s 923 ms
Tables0 s 834 ms
Column Writes0 s 325 ms
Propagation Map0 s 24 ms
Propagations0 s 325 ms
Dependencies0 s 252 ms

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