Difference between revisions of "SQWareRepository:mssql"
Expdbtools (talk | contribs) (Replaced content with '{{SQWareRepositoryPresSgbd|Mssql|database|alias FreeTds|msq}} == Specific database content for Mssql ==') |
Expdbtools (talk | contribs) |
||
| Line 1: | Line 1: | ||
{{SQWareRepositoryPresSgbd|Mssql|database|alias FreeTds|msq}} | {{SQWareRepositoryPresSgbd|Mssql|database|alias FreeTds|msq}} | ||
== Specific database content for Mssql == | == Specific database content for Mssql == | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwmsq_DetailDb| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwmsq_Files| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwmsq_GenInfos| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | Field Type | ||
| + | gather_date datetime | ||
| + | dbalias varchar(80) | ||
| + | nbdatabases int(11) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwmsq_Parameters| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | Field Type | ||
| + | dbalias varchar(80) | ||
| + | gather_date datetime | ||
| + | name varchar(255) | ||
| + | value varchar(255) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwmsq_RepositoryFreeTds| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | Field Type | ||
| + | hostname varchar(255) | ||
| + | username varchar(255) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwmsq_VolDb| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | Field Type | ||
| + | gather_date datetime | ||
| + | dbalias varchar(80) | ||
| + | database_name varchar(255) | ||
| + | size_db decimal(12,2) | ||
| + | owner varchar(30) | ||
| + | options varchar(4000) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwmsq_VolTables| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
Latest revision as of 18:12, 8 August 2015
Contents
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
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)
