DBAmon dbc Configuration - MSSQL Parameters

dbc Configuration - MSSQL Parameters

MSSQL Parameters
Parameter Description Example Value Default Value

Backup_Age: (Optional) The maximum tolerable age of the most recent DB backup in hours. See below for details on which databases are checked. 32

Backup_Check_DBs: (Optional) The MSSQL databases that you want to preform Backup_Age: checking on. If you specify the Backup_Age: parameter, the master and msdb databases will automatically be checked. Specify here any additional databases for which you want to check backup age. The name must be specified in lower case and if there is more than 1 name, the names must be separated by commas with no spaces.
If you specify ALL, then all DB's will be checked for backup age.
northwind,mydb,crud

Backup_Command: (Optional) Specifies an NT command to invoke anytime a backup age event occurs for any database names in Backup_Check_DBs:. Note that you have to provide your own backup script which is invoked. You can specify predefined strings that will be translated at run-time:

{PERLPATH} - Translated to the ActivePerl Home Dir
{SQLPATH} - Translated to the MSSQL Home Dir
{DB} - Translated to the name of the DB that created this Backup Age event
DBAmon will choose the method for invoking this command based on the total size of all databases. If the size exceeds 200MB, the command will be invoked with the NT "start/b" command in the background. If the size is <= 200MB, then the command will be run in the foreground. When the command is invoked in the background, the output will not be logged (NT limitation).
{PERLPATH}/perl.exe {SQLPATH}/dba_scripts/call_backup.pl {DB} LVL0
(No Default)

Perl_Path: If the ActivePerl executable is not in the default "Path", you will need to specify this parameter which needs to point to the actual ActivePerl executable. e:\perl\bin\perl

NT_RCP_Bug: We have found an NT bug where RCP from a Unix server (the DBAmon Master server) has a permission problem. Coding this parameter Y will cause a workaround to this problem to be used. If you get persistent \temp\dbamon* Permission Denied errors, then you may be experiencing this problem. Y

MSSQL_Agent_Mon: If you do not wish to monitor to ensure that the MSSQL agent is running, specify N here. N Y

T_TLog_Full: ww/cc
-or-
T_TLog_Full: N The warning (ww) and critical (cc) thresholds when checking the transaction logs. If you do not want this check to occur, specify N. 80/85 95/99

T_Disk_Full: ww/cc
-or-
T_Disk_Full: N The warning (ww) and critical (cc) thresholds when checking the fullness of any Windows disk which contains at least 1 MSSQL database file. If you do not want this check to occur, specify N. 80/85 95/99

MSSQL Parameters
Parameter	Description	Example Value	Default Value
Backup_Age:	(Optional) The maximum tolerable age of the most recent DB backup in hours. See below for details on which databases are checked.	32
Backup_Check_DBs:	(Optional) The MSSQL databases that you want to preform Backup_Age: checking on. If you specify the Backup_Age: parameter, the master and msdb databases will automatically be checked. Specify here any additional databases for which you want to check backup age. The name must be specified in lower case and if there is more than 1 name, the names must be separated by commas with no spaces. If you specify ALL, then all DB's will be checked for backup age.	northwind,mydb,crud
Backup_Command:	(Optional) Specifies an NT command to invoke anytime a backup age event occurs for any database names in Backup_Check_DBs:. Note that you have to provide your own backup script which is invoked. You can specify predefined strings that will be translated at run-time: {PERLPATH} - Translated to the ActivePerl Home Dir {SQLPATH} - Translated to the MSSQL Home Dir {DB} - Translated to the name of the DB that created this Backup Age event DBAmon will choose the method for invoking this command based on the total size of all databases. If the size exceeds 200MB, the command will be invoked with the NT "start/b" command in the background. If the size is <= 200MB, then the command will be run in the foreground. When the command is invoked in the background, the output will not be logged (NT limitation).	{PERLPATH}/perl.exe {SQLPATH}/dba_scripts/call_backup.pl {DB} LVL0	(No Default)
Perl_Path:	If the ActivePerl executable is not in the default "Path", you will need to specify this parameter which needs to point to the actual ActivePerl executable.	e:\perl\bin\perl
NT_RCP_Bug:	We have found an NT bug where RCP from a Unix server (the DBAmon Master server) has a permission problem. Coding this parameter Y will cause a workaround to this problem to be used. If you get persistent *\temp\dbamon Permission Denied** errors, then you may be experiencing this problem.	Y
MSSQL_Agent_Mon:	If you do not wish to monitor to ensure that the MSSQL agent is running, specify N here.	N	Y
T_TLog_Full: ww/cc -or- T_TLog_Full: N	The warning (ww) and critical (cc) thresholds when checking the transaction logs. If you do not want this check to occur, specify N.	80/85	95/99
T_Disk_Full: ww/cc -or- T_Disk_Full: N	The warning (ww) and critical (cc) thresholds when checking the fullness of any Windows disk which contains at least 1 MSSQL database file. If you do not want this check to occur, specify N.	80/85	95/99

DBAmon.com
This Document: http://dbamon.com/config/dbc_mssql.shtml