Date | Thu Jan 03 17:13:55 CET 2013 |
Server Name | AMD1_PAR_PPD_SQL (tiths320.fr.net.intra:5500) |
Server Version | Adaptive 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 Version | jConnect (TM) for JDBC(TM)/6.05(Build 26676)/P/EBF19092/JDK14/Fri May 13 9:49:49 2011 |
Java Version | 1.6.0_17 |
DB Scanned | [AMANDA, AMANDA_HISTO] |
Objects Count | 4330 |
Objects CRDate | null |
Defects Count | 31660 |
Analysis Time | 3 minutes (129 s) |
Memory Used | 287 MB |
Database | Procs | Tables | Views | Triggers | Functions | Rules | Defaults | Unscanned |
AMANDA | 1142/1143 | 435/436 | 5 | 11 | 1 | 139 | 2/1735 | |
AMANDA_HISTO | 1/2 | 32/33 | 2 | 2 | 2/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 |
AMANDA | 315 GB | 435 | 228 MB | 1 M | 10 | 1 K | 214 | 8 K | 19 | 404 | 3 K | 1 K | 4 K | 4 K | 1 K | 10 K | 448 |
AMANDA_HISTO | 299 GB | 32 | 7 GB | 20 M | 17 | 3 | 238 | 10 K | 19 | 178 | 6 | 11 | 3 | 4 | 26 | 4 | |
PLANNING | 500 MB | ||||||||||||||||
dbccdb | 12 GB | ||||||||||||||||
master | 150 MB | 9 | 32 KB | 412 | 16 | ||||||||||||
sybsecurity | 1000 MB | ||||||||||||||||
sybsystemdb | 82 MB | ||||||||||||||||
sybsystemprocs | 298 MB | 1 | 82 KB | 760 | 25 | ||||||||||||
tempdb | 15 GB | ||||||||||||||||
tempdb_sarole | 528 MB | ||||||||||||||||
tempdb_usr | 20 GB | ||||||||||||||||
tempdb_usr1 | 20 GB | ||||||||||||||||
TOTAL | 682 GB | 477 | 666 M | 3 M | 51 | 1 K | 214 | 8 K | 19 | 403 | 3 K | 1 K | 4 K | 4 K | 1 K | 10 K | 452 |
Files relative to the 2 databases scanned | |
Objects Dependencies | Dependencies |
Roots Objects | AllObjects |
Objects Referenced from the Roots | Referenced |
Unreferenced Root Objects | Unreferenced |
Tables and FKs | Schema |
Column Usage | Columns Usage |
SARGs | Sargs |
Defects Found | Defects |
Log File | LogFile |