SQWareRepository:mssql

From wiki_dbSQWare_3.1
Jump to: navigation, search

Presentation

It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqwmsq_% or isqwmsq_% are specific for Mssql.
Installation guide for SQWareRepository™ for Mssql

Naming convention

All specific objects for Mssql are named with prefixes:

  • tsqwmsq_% : for tables
  • isqwmsq_% : for index
  • isqwmsq_%_u : for uniques
  • isqwmsq_%_pk : for primary key


Nuvola apps important.png
Warning:
Do not change the standard tables of the tool. For your custom objects, use another name convention than dbSQWare.

This will facilitate version upgrades.


Specific database content for Mssql

tsqwmsq_DetailDb

This table contains : ...
Desc of tsqwmsq_DetailDb :

Field Type
gather_date datetime
dbalias varchar(80)
database_name varchar(255)
size_db decimal(12,2)
used decimal(12,2)
free decimal(12,2)
log decimal(12,2)


tsqwmsq_Files

This table contains : ...
Desc of tsqwmsq_Files :

Field Type
gather_date datetime
dbalias varchar(80)
database_name varchar(255)
group_name varchar(128)
logical_file_name varchar(128)
physical_file_name varchar(256)
file_type varchar(10)
growth_property varchar(30)
maxsize_property varchar(30)
maxsize bigint(20)
total decimal(12,2)
used decimal(12,2)
free decimal(12,2)


tsqwmsq_GenInfos

This table contains : ...
Desc of tsqwmsq_GenInfos :

Field Type
gather_date datetime
dbalias varchar(80)
nbdatabases int(11)


tsqwmsq_Parameters

This table contains : ...
Desc of tsqwmsq_Parameters :

Field Type
dbalias varchar(80)
gather_date datetime
name varchar(255)
value varchar(255)


tsqwmsq_RepositoryFreeTds

This table contains : ...
Desc of tsqwmsq_RepositoryFreeTds :

Field Type
hostname varchar(255)
username varchar(255)


tsqwmsq_VolDb

This table contains : ...
Desc of tsqwmsq_VolDb :

Field Type
gather_date datetime
dbalias varchar(80)
database_name varchar(255)
size_db decimal(12,2)
owner varchar(30)
options varchar(4000)


tsqwmsq_VolTables

This table contains : ...
Desc of tsqwmsq_VolTables :

Field Type
dbalias varchar(80)
gather_date datetime
database_name varchar(255)
table_schema varchar(255)
name varchar(255)
rows int(11)
reserved decimal(12,2)
data decimal(12,2)
index_size decimal(12,2)
unused decimal(12,2)