Forum Discussion
MS SQL Health Monitor Using Dummy Database
I am attempting to set up a MS SQL health monitor that authenticates with a SharePoint database, issues a query, and looks for a certain return string. I have applied the health monitor to a server pool that contains the SharePoint database. The database being monitored is called Test and it contains one table called Test_Table, which has a single column called Value. I have inserted one entry in the first column and row of this table with a value of NULL. The health monitor is currently resolving to a down state. I tried to upload an image of the health monitor, but it didn't work. Here is a text description of the health monitor:
- Type: MSSQL (parent = mssql)
- Send String: SELECT CASE WHEN Value IS NULL THEN 'UP' ELSE '' END FROM Test_Table
- Receive String: UP
- Username and password belongs to the same account that SharePoint uses to interact with the database
- Database: Test
- Receive Row and Column each set to 1
Recent Discussions
Related Content
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com