Support Center

Objects Shared Across Modules

Last Updated: Oct 06, 2017 01:25PM CDT

Some objects, like the dbo.Servers table, are shared across many (or all) modules.

Tables

Archive.Config

This table provides the retention period and batch size for data archival routines (i.e., the stored procedure Archive.Drive).

Name Type Description
ID bigint Primary key row identifier.
SchemaName sysname Schema name.
TableName sysname Table name.
ArchiveDays int Number of days to retain configuration data, for this table.
RowsInBatch int The number of rows to delete per batch.
 

Archive.Servers

This table keeps a record of the dbo.Servers table, in case the dbo.Servers table is truncated or otherwise messed up. It is populated by the Archive.Servers stored procedure, which is run by the job ArchiveServersInsert.

The columns in Archive.Servers are the same as the columns in dbo.Servers, with the addition of the ExecutionDateTime column, which marks the date that the data was collected from dbo.Servers.

dbo.Servers

The dbo.Servers table is the central axis point of the entire system. You must insert a bare minimum of information about servers that you wish to manage: ServerName, ServiceLevel, Port, IsSQL, and IsActive. 

Once this is done, Minion Enterprise automated processes will start according to their schedules, to fill in the rest of the dbo.Servers table and to begin collection, alerts, and reporting on the active instances.

Name Type Description
InstanceID Int The instance ID of the instance in question. This is the instance ID of record throughout Minion Enterprise tables and objects.
LocID int The location ID, as defined in the table dbo.Location.
ServerName varchar The name of the SQL Server instance; or, if it is a cluster, the name of the SQL Server virtual instance; or, if SQL Server is not installed, the name of the computer.
 
Note that Minion Enterprise can monitor Windows servers that do not have an instance of SQL Server installed.
 
Example values: “Server1”, “Server3\NewInstance”.
DNS varchar DNS address of the server.
IP char IP address of the server.
Port int The port to be used for the connection to the target SQL Server.
Descr varchar A description of the server, as provided by the user.
Role Varchar Server role.
ServiceLevel varchar A simple label for the level of the server’s importance, which determines the level of service that Minion Enterprise provides.
 
Valid values: Gold, Silver, Bronze.
IsSQL Bit Denotes whether the server (the row) in question is an instance of SQL Server, or not.
SQLVersion varchar The current version of SQL Server. Example: 2014.
SQLEdition Varchar The current edition of SQL Server. Example: Ent.
SQLServicePack Varchar The current SQL Server service pack. Examples: RTM, SP1.
SQLBuild Varchar The current SQL Server build. Example: 12.0.2000.
IsCluster bit Denotes whether the server in question is a clustered instance, or not.
IsNew bit Determines whether the current row is a new (to Minion Enterprise) server, or not.
To be used in future editions of Minion Enterprise.
IsActive bit Determines whether the current row is active, and should be used.
IsActiveDate date The date that the server was first active. Like “Descr”, this column is for the DBA’s use; the system itself doesn’t fill in or use this column.
InstanceMemInMB int Not in use. See Collector.ServersOSDetail.
OSVersion varchar The operating system version. Example: “  2012 R2 Standard”.
OSServicePack varchar Not in use.
OSBuild Varchar Not in use.
OSArchitecture tinyint The operating system architecture (32 bit or 64 bit).
CPUSockets tinyint Number of physical processors.
CPUCores tinyint Number of cores.
CPULogicalTotal int Number of logical CPUs.
ServerMemInMB varchar The amount of physical memory, measured in MB.
Manufacturer nchar The manufacturer of the virtual platform, if any. Examples: “Hyper-V”, “VMWare”
ServerModel varchar Not in use.
ServerOrder int Specifies an order the servers will be processed in.  This is essentially a group of servers to be processed before any others.  It is a weighted list so higher numbers get processed first.  For more info: https://minionware.desk.com/customer/portal/articles/2885612
ServerGroupOrder int Specifies an order withing the ServerOrder group that the servers will be processed in. It is a weighted list so higher numbers get processed first.  For more info: https://minionware.desk.com/customer/portal/articles/2885612
CollectionZone tinyint The zone that the current server is being collected for.  For more info: https://minionware.desk.com/customer/portal/articles/2885588-collection-zones
Comment Varchar For your reference only. Label each row with a short description and/or purpose.
 

Stored Procedures

Archive.Data

The job “ArchiveServersInsert” runs this procedure, which performs data archival to remove outdated data from “Collector” tables. The retention period for each Collector table is configured in the Archive.Config table.

Archive.Servers

 

This procedure archives the dbo.Servers table to Archive.Servers, in case the dbo.Servers table is truncated or otherwise messed up.

 

556ca399015f31edc97a62de2771be1a@minionware.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete