Some objects, like the dbo.Servers table, are shared across many (or all) modules.
This table provides the retention period and batch size for data archival routines (i.e., the stored procedure Archive.Drive).
|ID||bigint||Primary key row identifier.|
|ArchiveDays||int||Number of days to retain configuration data, for this table.|
|RowsInBatch||int||The number of rows to delete per batch.|
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.
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.
|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.|
|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.|
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.
This procedure archives the dbo.Servers table to Archive.Servers, in case the dbo.Servers table is truncated or otherwise messed up.