Batch Analysis Report

www.sqlbrowser.com
SQLBrowser 2012_02 844 Release 28-02-2012 Registered to BNP PARIBAS SECURITIES SERVICES @ LICENCE 20 UTILISATEURS

DateThu Jan 03 17:13:55 CET 2013
Server NameAMD1_PAR_PPD_SQL (tiths320.fr.net.intra:5500)
Server VersionAdaptive Server Enterprise/15.5/EBF 19397 SMP ESD#5/P/ia64/HP-UX B.11.23/asear155/2568/64-bit/FBO/Fri Dec 9 02:34:21 2011
Server Driver VersionjConnect (TM) for JDBC(TM)/6.05(Build 26676)/P/EBF19092/JDK14/Fri May 13 9:49:49 2011
Java Version1.6.0_17
DB Scanned[AMANDA, AMANDA_HISTO]
Objects Count4330
Objects CRDatenull
Defects Count31660
Analysis Time3 minutes (129 s)
Memory Used287 MB

DatabaseProcsTablesViewsTriggersFunctionsRulesDefaultsUnscanned
AMANDA1142/1143435/4365111 1392/1735
AMANDA_HISTO1/232/332   22/39
PLANNING       107
dbccdb       73
master 9/549     702/711
sybsecurity       35
sybsystemdb       32
sybsystemprocs 1/35     757/758
tempdb 2545/2616     72/74
tempdb_sarole       30
tempdb_usr       98
tempdb_usr1       116

Satistics per
Database
DB
Size
Table
Count
Avg
Size
Avg
Rows
Avg
Cols
Proc
Count
Avg
Lines
Avg
Bytes
Avg
Cyclo
Avg
Cmplx
Tot
Exec
Tot
Sel
Tot
Ins
Tot
Upd
Tot
Del
Tot
If
Tot
While
AMANDA315 GB435 228 MB1 M10 1 K214 8 K19 404 3 K1 K4 K4 K1 K10 K448
AMANDA_HISTO299 GB32 7 GB20 M17 3 238 10 K19 178 6  11 3 4 26 4
PLANNING500 MB                
dbccdb12 GB                
master150 MB9 32 KB412 16             
sybsecurity1000 MB                
sybsystemdb82 MB                
sybsystemprocs298 MB1 82 KB760 25             
tempdb15 GB                
tempdb_sarole528 MB                
tempdb_usr20 GB                
tempdb_usr120 GB                
TOTAL682 GB477 666 M3 M51 1 K214 8 K19 403 3 K1 K4 K4 K1 K10 K452

Defects
 QCAR - 6 - Cartesian product86
 QFIB - 6 - Force index with bad index3
 MBPA - 6 - Not a parameter of this proc23
 MURC - 6 - Unreachable Code19
 QBGB - 6 - Bad group by128
 PERR - 6 - Parsing Error180
 QJWI - 5 - Join/Sarg Without Index10
 QCAS - 4 - Cartesian product with single row26
 QCSC - 4 - Costly 'select count()', use 'exists()'30
 QFPU - 4 - Unclosed Force plan1
 QTYP - 4 - Comparison type mismatch3245
 MBRV - 4 - Bad return value [-1-99]135
 MEST - 4 - Empty String will be replaced by Single Space1542
 MINU - 4 - Unique Index with nullable columns40
 MMCN - 4 - Potentially Misleading Column Naming1318
 MTYP - 4 - Assignment type mismatch1576
 MULT - 4 - Using literal database 'tempdb'197
 MUSP - 4 - Unquoted String Parameter3
 Q123 - 4 - V12 Compat #3: Conjunct with inner table and join order independent table2
 QUDW - 4 - Update or delete with no where clause7
 TNOI - 4 - Table with no index60
 TNOU - 4 - Table with no unique index116
 VOVR - 4 - Variable is an input param and is overwritten49
 VUWR - 4 - Variable is an output param and is not written to2
 QFID - 3 - Force index345
 QFPL - 3 - Force plan78
 QHNT - 3 - Optimizer Hint82
 QISO - 3 - Set isolation level1
 QJWT - 3 - Join/Sarg Without Index involving temp table303
 QMTB - 3 - From clause with many tables13
 QPRI - 3 - Join/Sarg with Rooted Partial Index Use444
 QPUI - 3 - Join/Sarg with Un-Rooted Partial Index Use356
 QTLO - 3 - Top-Level OR78
 QUNI - 3 - Check Use of 'union' vs 'union all'208
 CSBI - 3 - Updated Cursor with 'Distinct/Union/GroupBy/OrderBy/Aggregate/SubQueries/Isolation' should contain 'insensitive' clause (V15)1
 CUNU - 3 - Cursor not updated: cursor should contain 'for read only' clause92
 CUSU - 3 - Cursor updated through 'searched update': risk of halloween rows8
 CUUP - 3 - Cursor updated: cursor should contain 'for update' clause7
 MAW1 - 3 - Ad-hoc Warning Message 13688
 MDYN - 3 - Proc uses Dynamic SQL but is not flagged with 'Dynamic Ownership Chain'12
 MIIO - 3 - Index overlap5
 MLCH - 3 - Char type with length>3065
 MNAC - 3 - Not using ANSI 'is null'446
 MNEJ - 3 - 'Not Equal' join135
 MUBC - 3 - Unbalanced begin tran/commit tran50
 MUCO - 3 - Useless Code4081
 MUIN - 3 - Column created using implicit nullability535
 MUOT - 3 - Updates outside transaction301
 MUPK - 3 - Update column which is part of a PK or unique index184
 MUTI - 3 - Update temptable with identity - 12.5.4 Regression81
 MZMB - 3 - Zombie: use of non-existent object226
 QAFM - 3 - Var Assignment from potentially many rows2428
 QAPT - 3 - Access to Proxy Table2
 QCRS - 3 - Conditional Result Set260
 QGWO - 3 - Group by without order by1
 QIWC - 3 - Insert with not all columns specified1653
 QNAM - 3 - Select expression has no name469
 QNCO - 3 - No column in result set178
 QRPR - 3 - Repeated predicate11
 VUNU - 3 - Variable is not used2089
 MCWR - 2 - Create Proc With Recompile Marker14
 MEWR - 2 - Exec With Recompile Marker23
 MTR1 - 2 - Metrics: Comments Ratio1303
 MTR2 - 2 - Metrics: Cyclomatic Complexity1303
 MTR3 - 2 - Metrics: Query Complexity1303

Files relative to the 2 databases scanned
Objects DependenciesDependencies
Roots ObjectsAllObjects
Objects Referenced from the RootsReferenced
Unreferenced Root ObjectsUnreferenced
Tables and FKsSchema
Column UsageColumns Usage
SARGsSargs
Defects FoundDefects
Log FileLogFile