MainDatabaseProcsTablesViewsTriggersFunctionsRulesDefaultsUnscanned
indexmaster  21162/1641/4    5/189

Procs

  1. mon_authorize_non_sa    mon_rpc_attach    mon_rpc_connect   
  2. sp_addconf    sp_autoformat    sp_aux_checkroleperm    sp_aux_getsize    sp_check_remote_tempdb    sp_configure    sp_dboption    sp_dboption_flmode    sp_dropdevice    sp_getmessage    sp_instmsg    sp_loaddbupgrade    sp_namecrack    sp_probe_xact    sp_procxmode    sp_prtsybsysmsgs    sp_remotesql    sp_validlang   

Tables

  1. ijdbc_function_escapes    
  2. jdbc_function_escapes    
  3. monCIPC     monCIPCEndpoints     monCIPCLinks     monCIPCMesh     monCLMObjectActivity     monCMSFailover     monCachePool     monCachedObject     monCachedProcedures     monCachedStatement     monClusterCacheManager     monDBRecovery     monDBRecoveryLRTypes     monDataCache     monDeadLock     monDeviceIO     monDeviceSpaceUsage     monEngine     monErrorLog     monFailoverRecovery     monHADRMembers     monIOController     monIOQueue     monInmemoryStorage     monLicense     monLockTimeout     monLocks     monLogicalCluster     monLogicalClusterAction     monLogicalClusterInstance     monLogicalClusterRoute     monMemoryUsage     monNetworkIO     monOpenDatabases     monOpenObjectActivity     monOpenPartitionActivity     monPCIBridge     monPCIEngine     monPCISlots     monPCM     monProcedureCache     monProcedureCacheMemoryUsage     monProcedureCacheModuleUsage     monProcess     monProcessActivity     monProcessLookup     monProcessMigration     monProcessNetIO     monProcessObject     monProcessProcedures     monProcessSQLText     monProcessStatement     monProcessWaits     monProcessWorkerThread     monRepCoordinator     monRepLogActivity     monRepMemoryStatistics     monRepScanners     monRepScannersTotalTime     monRepSchemaCache     monRepSenders     monRepStreamStatistics     monRepSyncTaskStatistics     monRepTruncationPoint     monSQLRepActivity     monSQLRepMisses     monServiceTask     monSpinlockActivity     monState     monStatementCache     monSysExecutionTime     monSysLoad     monSysPlanText     monSysSQLText     monSysStatement     monSysWaits     monSysWorkerThread     monTableColumns     monTableCompression     monTableParameters     monTableTransfer     monTables     monTask     monTempdbActivity     monThread     monThreadPool     monThresholdEvent     monWaitClassInfo     monWaitEventInfo     monWorkQueue     monWorkload     monWorkloadPreview     monWorkloadProfile     monWorkloadRaw    
  4. spt_ijdbc_conversion     spt_ijdbc_mda     spt_ijdbc_table_types     spt_jdbc_conversion     spt_jdbc_table_types     spt_jtext     spt_limit_types     spt_mda     spt_monitor     spt_values     syblicenseslog     sysalternates     sysattributes     syscertificates     syscharsets     syscolumns     syscomments     sysconfigures     sysconstraints     syscurconfigs     sysdatabases     sysdepends     sysdevices     sysencryptkeys     sysengines     sysindexes     sysjars     syskeys     syslanguages     syslisteners     syslocks     sysloginroles     syslogins     syslogs     syslogshold     sysmessages     sysmonitors     sysobjects     sysoptions     syspartitionkeys     syspartitions     sysprocedures     sysprocesses     sysprotects     sysqueryplans     sysreferences     sysremotelogins     sysresourcelimits     sysroles     syssecmechs     syssegments     sysservers     syssessions     sysslices     syssrvroles     sysstatistics     systabstats     systestlog     systhresholds     systimeranges     systransactions     systypes     sysusages     sysusermessages     sysusers     sysxtypes    

Result Sets

  1. mon_rpc_attach_rset_001   
  2. sp_addconf_rset_001     sp_autoformat_rset_001     sp_autoformat_rset_002     sp_autoformat_rset_003     sp_autoformat_rset_004     sp_autoformat_rset_005     sp_configure_rset_001     sp_configure_rset_002     sp_configure_rset_003     sp_configure_rset_004     sp_configure_rset_005     sp_configure_rset_006     sp_dboption_rset_001     sp_dboption_rset_002     sp_dropdevice_rset_001     sp_dropdevice_rset_002     sp_dropdevice_rset_003     sp_probe_xact_rset_001     sp_probe_xact_rset_002     sp_probe_xact_rset_003     sp_probe_xact_rset_004     sp_probe_xact_rset_005     sp_probe_xact_rset_006     sp_procxmode_rset_001     sp_procxmode_rset_002    
Defects
 QCAR 6 Cartesian product2
 QJWI 5 Join or Sarg Without Index6
 MCPC 4 Copy Paste Code34
 MCTR 4 Conditional Begin Tran or Commit Tran3
 MEST 4 Empty String will be replaced by Single Space7
 MINU 4 Unique Index with nullable columns6
 MTYP 4 Assignment type mismatch24
 MULT 4 Using literal database 'tempdb'2
 MUSP 4 Unquoted String Parameter6
 QCSC 4 Costly 'select count()', use 'exists()'2
 QPUI 4 Join or Sarg with Un-Rooted Partial Index Use27
 QTYP 4 Comparison type mismatch164
 TNOI 4 Table with no index39
 TNOU 4 Table with no unique index4
 CUNU 3 Cursor not updated: cursor should contain 'for read only' clause4
 MAW1 3 Warning message on %name%6
 MDYN 3 Proc uses Dynamic SQL but is not flagged with Dynamic Ownership Chain1
 MLCH 3 Char type with length>3046
 MNER 3 No Error Check81
 MUCO 3 Useless Code333
 MUIN 3 Column created using implicit nullability2
 MUOT 3 Updates outside transaction4
 MUPK 3 Update column which is part of a PK or unique index2
 MZMB 3 Zombie: use of non-existent object1
 QAFM 3 Var Assignment from potentially many rows52
 QCRS 3 Conditional Result Set25
 QCTC 3 Conditional Table Creation7
 QDIS 3 Check correct use of 'select distinct'3
 QGWO 3 Group by/Distinct/Union without order by3
 QISO 3 Set isolation level11
 QIWC 3 Insert with not all columns specified1
 QJWT 3 Join or Sarg Without Index on temp table7
 QNAJ 3 Not using ANSI Inner Join30
 QNAM 3 Select expression has no name10
 QNAO 3 Not using ANSI Outer Join6
 QNUA 3 Should use Alias:175
 QPNC 3 No column in condition1
 QPRI 3 Join or Sarg with Rooted Partial Index Use35
 QSWV 3 Sarg with variable12
 QUNI 3 Check Use of 'union' vs 'union all'1
 VNRD 3 Variable is not read15
 VUNU 3 Variable is not used16
 CRDO 2 Read Only Cursor Marker2
 CUPD 2 Updatable Cursor Marker2
 MDYE 2 Dynamic Exec Marker2
 MDYS 2 Dynamic SQL Marker5
 MRST 2 Result Set Marker26
 MSUB 2 Subquery Marker24
 MTR1 2 Metrics: Comments Ratio22
 MTR2 2 Metrics: Cyclomatic Complexity22
 MTR3 2 Metrics: Query Complexity22

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