Wenn du dich für Plugins (oder OMD oder allgemein Monitoring) interessierst oder von deiner Installation erzählen willst...die Tradition der deutschsprachigen Monitoring-Workshops wird wiederbelebt: https://discord.gg/jDfPZ63FcJ A plugin, which checks various parameters of Microsoft SQL database servers.
it seems that the mode "database-online" is not functional if the database option "auto close" is set. I get this message "DBNAME is online but not accepting connections". Connecting to this database works fine and after doing any select query the state changes to "OK" for a certain time.
This is the query used in the script to check if the database is accepting connections: SELECT name, state, state_desc, collation_name FROM master.sys.databases
If collation_name is NULL the check jumps to this error. But in the offical documentation of Microsoft the variable state NULL means "Database is not online or AUTO_CLOSE is set to ON and the database is closed." Wouldn't it be better to check it with the state column in master.sys.databases?
Hello,
it seems that the mode "database-online" is not functional if the database option "auto close" is set. I get this message "DBNAME is online but not accepting connections". Connecting to this database works fine and after doing any select query the state changes to "OK" for a certain time.
This is the query used in the script to check if the database is accepting connections: SELECT name, state, state_desc, collation_name FROM master.sys.databases If collation_name is NULL the check jumps to this error. But in the offical documentation of Microsoft the variable state NULL means "Database is not online or AUTO_CLOSE is set to ON and the database is closed." Wouldn't it be better to check it with the state column in master.sys.databases?
Regards Marcel