Difference between revisions of "SQWareProduction:mssql:etc:sqwmsq GlobalVar.cfg"
m (Updated by BatchUser) (Tag: Replaced) |
m (Updated by BatchUser) |
||
Line 1: | Line 1: | ||
Configuration file $gvsqw_MsqBin/../etc/sqwmsq_GlobalVar.cfg:<br> | Configuration file $gvsqw_MsqBin/../etc/sqwmsq_GlobalVar.cfg:<br> | ||
{{SQWareProduction_sqwmsq_GlobalVar.cfg_presentation}} | {{SQWareProduction_sqwmsq_GlobalVar.cfg_presentation}} | ||
− | { | + | <br> |
− | + | <br> | |
+ | File content: | ||
+ | <pre> | ||
+ | export gvsqw_SqwVersionDbms=2024.02 | ||
+ | export gvsqw_MssqlPassFile=$gvsqw_DistPasswdFile | ||
+ | export gvsqw_DistPasswdFile="$HOME/.passwd_mssql" | ||
+ | export gvsqw_MssqlSaUser='sa' | ||
+ | export gvsqw_RootAdmin='$HOME/admin/${lvsqw_InstanceParam}' | ||
+ | export gvsqw_RootAdminDisable='$HOME' | ||
+ | export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig' | ||
+ | export gvsqw_WhereClauseGenDatabaseList="and name not like 'tempdb%' and name not like 'ReportServer%TempDb'" | ||
+ | export gvsqw_DbAlias='$lvsqw_InstanceParam' | ||
+ | export gvsqw_SuppAlert=90 | ||
+ | #export gvsqw_MsSqlErrorMsg='^Msg 3014, Level 0, State 1|^Msg 3211, Level 0, State 1|^Msg 4035, Level 0, State 1|^Server ..*, Line 1|@@rowcount' | ||
+ | export gvsqw_MsSqlErrorMsg='^Msg [0-9][0-9]*, Level 0, State 1|^Server ..*, Line 1|@@rowcount' | ||
+ | export gvsqw_XpCmdShellWaitTimeOut=300 | ||
+ | export gvsqw_Collate='Latin1_General_CI_AI' | ||
+ | export gvsqw_NbThreadBackup=4 | ||
+ | export gvsqw_DefAGR_Backup=5 | ||
+ | export gvsqw_DefAGE_Backup=20 | ||
+ | export gvsqw_BackupNbGeneration=2 | ||
+ | export gvsqw_SizeMaxStripe=40000 | ||
+ | export gvsqw_NbMaxStripe=5 | ||
+ | export gvsqw_BackupStatSize=10 | ||
+ | export gvsqw_NbThreadRebuild=4 | ||
+ | export gvsqw_DefAGR_Rebuild=5 | ||
+ | export gvsqw_DefAGE_Rebuild=20 | ||
+ | export gvsqw_SetOptionsRebuild='set ansi_defaults, concat_null_yields_null on | ||
+ | export gvsqw_RebuildType='index' #Rebuild type, 'all' for tables, 'index' for indexes | ||
+ | export gvsqw_MinRatioReb=30 #Min avg_fragmentation_in_percent before rebuild | ||
+ | export gvsqw_MinRatioRgz=10 #Min avg_fragmentation_in_percent before reorganize | ||
+ | export gvsqw_SizeMinIndexRebuild=1 #Min size of index in Mb to take into account | ||
+ | export gvsqw_SizeMaxIndexRebuild=50000 #Max size of index in Mb to take into account | ||
+ | export gvsqw_NbThreadStatistics=4 | ||
+ | export gvsqw_DefAGR_Statistics=5 | ||
+ | export gvsqw_DefAGE_Statistics=20 | ||
+ | export gvsqw_NbThreadRestore=4 | ||
+ | export gvsqw_DefAGR_Restore=5 | ||
+ | export gvsqw_DefAGE_Restore=20 | ||
+ | export gvsqw_RestoreStatSize=5 | ||
+ | export gvsqw_NbThreadCheckdb=4 | ||
+ | export gvsqw_DefAGR_Checkdb=5 | ||
+ | export gvsqw_DefAGE_Checkdb=20 | ||
+ | export gvsqw_SizeMinTableIndicators=10 | ||
+ | export gvsqw_BackupsIndicatorsDays=2 | ||
+ | export gvsqw_ExcludeDatabaseStatus="'OFFLINE','RESTORING'" | ||
+ | export gvsqw_GenExcludeDatabasesObjects="^master$|^msdb$|^model$|^ReportServer" | ||
+ | export gvsqw_GenExcludeDatabasesObjectsExtra="" | ||
+ | export gvsqw_StringReplaceSch="tr -d '\015'|tr '\311' 'E'" | ||
+ | export gvsqw_UserTypeList="'SQL_LOGIN','WINDOWS_LOGIN'" | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_BackupAllDatabases=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_BackupDatabase=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbAllDatabases=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbDatabase=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckIndicators=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_GatherIndicators=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_ParallelRun=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexAllDatabases=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexDatabase=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreAllDatabases=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreDatabase=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_RotateErrorLog=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsAllDatabases=0 | ||
+ | #export gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsDatabase=0 | ||
+ | </pre> | ||
+ | <br> | ||
+ | <br> | ||
+ | Variables explanation: | ||
+ | <pre> | ||
+ | gvsqw_BackupNbGeneration => | ||
+ | gvsqw_BackupsIndicatorsDays => | ||
+ | gvsqw_BackupStatSize => | ||
+ | gvsqw_Collate => | ||
+ | gvsqw_DbAlias => | ||
+ | gvsqw_DefAGE_Backup => | ||
+ | gvsqw_DefAGE_Checkdb => | ||
+ | gvsqw_DefAGE_Rebuild => | ||
+ | gvsqw_DefAGE_Restore => | ||
+ | gvsqw_DefAGE_Statistics => | ||
+ | gvsqw_DefAGR_Backup => | ||
+ | gvsqw_DefAGR_Checkdb => | ||
+ | gvsqw_DefAGR_Rebuild => | ||
+ | gvsqw_DefAGR_Restore => | ||
+ | gvsqw_DefAGR_Statistics => | ||
+ | gvsqw_DistPasswdFile => | ||
+ | gvsqw_ExcludeDatabaseStatus => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_BackupAllDatabases => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_BackupDatabase => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbAllDatabases => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbDatabase => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_CheckIndicators => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_GatherIndicators => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_ParallelRun => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexAllDatabases => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexDatabase => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreAllDatabases => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreDatabase => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_RotateErrorLog => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsAllDatabases => | ||
+ | #gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsDatabase => | ||
+ | gvsqw_GenExcludeDatabasesObjectsExtra => | ||
+ | gvsqw_GenExcludeDatabasesObjects => | ||
+ | gvsqw_MinRatioReb => | ||
+ | gvsqw_MinRatioRgz => | ||
+ | gvsqw_MsSqlErrorMsg => | ||
+ | #gvsqw_MsSqlErrorMsg => | ||
+ | gvsqw_MssqlPassFile => | ||
+ | gvsqw_MssqlSaUser => | ||
+ | gvsqw_NbMaxStripe => | ||
+ | gvsqw_NbThreadBackup => | ||
+ | gvsqw_NbThreadCheckdb => | ||
+ | gvsqw_NbThreadRebuild => | ||
+ | gvsqw_NbThreadRestore => | ||
+ | gvsqw_NbThreadStatistics => | ||
+ | gvsqw_RebuildType => | ||
+ | gvsqw_RestoreStatSize => | ||
+ | gvsqw_RootAdmin => | ||
+ | gvsqw_RootAdminDisable => | ||
+ | gvsqw_RootCfg => | ||
+ | gvsqw_SetOptionsRebuild => | ||
+ | gvsqw_SizeMaxIndexRebuild => | ||
+ | gvsqw_SizeMaxStripe => | ||
+ | gvsqw_SizeMinIndexRebuild => | ||
+ | gvsqw_SizeMinTableIndicators => | ||
+ | gvsqw_SqwVersionDbms => | ||
+ | gvsqw_StringReplaceSch => | ||
+ | gvsqw_SuppAlert => | ||
+ | gvsqw_UserTypeList => | ||
+ | gvsqw_WhereClauseGenDatabaseList => | ||
+ | gvsqw_XpCmdShellWaitTimeOut => | ||
+ | </pre> | ||
{{SQWareProductionSurchargeVar|mssql|Msq|sqwmsq_GlobalVar.cfg}} | {{SQWareProductionSurchargeVar|mssql|Msq|sqwmsq_GlobalVar.cfg}} | ||
<br> | <br> |
Revision as of 16:06, 7 April 2024
Configuration file $gvsqw_MsqBin/../etc/sqwmsq_GlobalVar.cfg:
Global var for Mssql
It contains the operating variables of SQWareProduction.
File content:
export gvsqw_SqwVersionDbms=2024.02 export gvsqw_MssqlPassFile=$gvsqw_DistPasswdFile export gvsqw_DistPasswdFile="$HOME/.passwd_mssql" export gvsqw_MssqlSaUser='sa' export gvsqw_RootAdmin='$HOME/admin/${lvsqw_InstanceParam}' export gvsqw_RootAdminDisable='$HOME' export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig' export gvsqw_WhereClauseGenDatabaseList="and name not like 'tempdb%' and name not like 'ReportServer%TempDb'" export gvsqw_DbAlias='$lvsqw_InstanceParam' export gvsqw_SuppAlert=90 #export gvsqw_MsSqlErrorMsg='^Msg 3014, Level 0, State 1|^Msg 3211, Level 0, State 1|^Msg 4035, Level 0, State 1|^Server ..*, Line 1|@@rowcount' export gvsqw_MsSqlErrorMsg='^Msg [0-9][0-9]*, Level 0, State 1|^Server ..*, Line 1|@@rowcount' export gvsqw_XpCmdShellWaitTimeOut=300 export gvsqw_Collate='Latin1_General_CI_AI' export gvsqw_NbThreadBackup=4 export gvsqw_DefAGR_Backup=5 export gvsqw_DefAGE_Backup=20 export gvsqw_BackupNbGeneration=2 export gvsqw_SizeMaxStripe=40000 export gvsqw_NbMaxStripe=5 export gvsqw_BackupStatSize=10 export gvsqw_NbThreadRebuild=4 export gvsqw_DefAGR_Rebuild=5 export gvsqw_DefAGE_Rebuild=20 export gvsqw_SetOptionsRebuild='set ansi_defaults, concat_null_yields_null on export gvsqw_RebuildType='index' #Rebuild type, 'all' for tables, 'index' for indexes export gvsqw_MinRatioReb=30 #Min avg_fragmentation_in_percent before rebuild export gvsqw_MinRatioRgz=10 #Min avg_fragmentation_in_percent before reorganize export gvsqw_SizeMinIndexRebuild=1 #Min size of index in Mb to take into account export gvsqw_SizeMaxIndexRebuild=50000 #Max size of index in Mb to take into account export gvsqw_NbThreadStatistics=4 export gvsqw_DefAGR_Statistics=5 export gvsqw_DefAGE_Statistics=20 export gvsqw_NbThreadRestore=4 export gvsqw_DefAGR_Restore=5 export gvsqw_DefAGE_Restore=20 export gvsqw_RestoreStatSize=5 export gvsqw_NbThreadCheckdb=4 export gvsqw_DefAGR_Checkdb=5 export gvsqw_DefAGE_Checkdb=20 export gvsqw_SizeMinTableIndicators=10 export gvsqw_BackupsIndicatorsDays=2 export gvsqw_ExcludeDatabaseStatus="'OFFLINE','RESTORING'" export gvsqw_GenExcludeDatabasesObjects="^master$|^msdb$|^model$|^ReportServer" export gvsqw_GenExcludeDatabasesObjectsExtra="" export gvsqw_StringReplaceSch="tr -d '\015'|tr '\311' 'E'" export gvsqw_UserTypeList="'SQL_LOGIN','WINDOWS_LOGIN'" #export gvsqw_ForcedReturnCodeScript_sqwmsq_BackupAllDatabases=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_BackupDatabase=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbAllDatabases=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbDatabase=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_CheckIndicators=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_GatherIndicators=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_ParallelRun=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexAllDatabases=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexDatabase=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreAllDatabases=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreDatabase=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_RotateErrorLog=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsAllDatabases=0 #export gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsDatabase=0
Variables explanation:
gvsqw_BackupNbGeneration => gvsqw_BackupsIndicatorsDays => gvsqw_BackupStatSize => gvsqw_Collate => gvsqw_DbAlias => gvsqw_DefAGE_Backup => gvsqw_DefAGE_Checkdb => gvsqw_DefAGE_Rebuild => gvsqw_DefAGE_Restore => gvsqw_DefAGE_Statistics => gvsqw_DefAGR_Backup => gvsqw_DefAGR_Checkdb => gvsqw_DefAGR_Rebuild => gvsqw_DefAGR_Restore => gvsqw_DefAGR_Statistics => gvsqw_DistPasswdFile => gvsqw_ExcludeDatabaseStatus => #gvsqw_ForcedReturnCodeScript_sqwmsq_BackupAllDatabases => #gvsqw_ForcedReturnCodeScript_sqwmsq_BackupDatabase => #gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbAllDatabases => #gvsqw_ForcedReturnCodeScript_sqwmsq_CheckdbDatabase => #gvsqw_ForcedReturnCodeScript_sqwmsq_CheckIndicators => #gvsqw_ForcedReturnCodeScript_sqwmsq_GatherIndicators => #gvsqw_ForcedReturnCodeScript_sqwmsq_ParallelRun => #gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexAllDatabases => #gvsqw_ForcedReturnCodeScript_sqwmsq_RebuildIndexDatabase => #gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreAllDatabases => #gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreDatabase => #gvsqw_ForcedReturnCodeScript_sqwmsq_RotateErrorLog => #gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsAllDatabases => #gvsqw_ForcedReturnCodeScript_sqwmsq_StatisticsDatabase => gvsqw_GenExcludeDatabasesObjectsExtra => gvsqw_GenExcludeDatabasesObjects => gvsqw_MinRatioReb => gvsqw_MinRatioRgz => gvsqw_MsSqlErrorMsg => #gvsqw_MsSqlErrorMsg => gvsqw_MssqlPassFile => gvsqw_MssqlSaUser => gvsqw_NbMaxStripe => gvsqw_NbThreadBackup => gvsqw_NbThreadCheckdb => gvsqw_NbThreadRebuild => gvsqw_NbThreadRestore => gvsqw_NbThreadStatistics => gvsqw_RebuildType => gvsqw_RestoreStatSize => gvsqw_RootAdmin => gvsqw_RootAdminDisable => gvsqw_RootCfg => gvsqw_SetOptionsRebuild => gvsqw_SizeMaxIndexRebuild => gvsqw_SizeMaxStripe => gvsqw_SizeMinIndexRebuild => gvsqw_SizeMinTableIndicators => gvsqw_SqwVersionDbms => gvsqw_StringReplaceSch => gvsqw_SuppAlert => gvsqw_UserTypeList => gvsqw_WhereClauseGenDatabaseList => gvsqw_XpCmdShellWaitTimeOut =>