用 DumbMonit 监控 SQL Server

1. Connect to the instance with SQL Server Management Studio or sqlcmd, with a login allowed to create logins, and create the login DumbMonit will use.

   CREATE LOGIN dumbmonit WITH PASSWORD = 'choose-a-long-password', CHECK_POLICY = ON;

2. Give it the server-wide read rights it needs to see the state of the engine, and nothing else.

   GRANT VIEW SERVER STATE TO dumbmonit;
   GRANT VIEW ANY DEFINITION TO dumbmonit;

3. Optional, for the SQL Server Agent jobs: let it read the job history in msdb.

   USE msdb;
   CREATE USER dumbmonit FOR LOGIN dumbmonit;
   ALTER ROLE SQLAgentReaderRole ADD MEMBER dumbmonit;

4. Check that the instance accepts SQL Server authentication (mixed mode) and listens on a fixed TCP port: SQL Server Configuration Manager, Network Configuration, TCP/IP.

5. In DumbMonit, enter the server address, for example sql.lan, or sql.lan:1444 for another port, then the login and its password.

6. Tick Accept an unverifiable certificate while the server still presents its self-signed certificate.

注意. Windows authentication is not supported: use a SQL Server login, on an instance that allows SQL Server authentication (mixed mode). Named instances need their fixed TCP port in the address.