1. Home
  2. Troubleshooting
  3. Monitoring Issues
  4. Observer Module
  5. SQL Server Events – No SQL Activity in the Observer Module

SQL Server Events – No SQL Activity in the Observer Module

Verify whether AimBetter is capturing SQL error events. This is useful when no events have been recorded for a long time in the SQL layer. This procedure is intended for environments using Microsoft SQL Server.

SQL Activity Test

  • Open SQL Server Management Studio (SSMS).
  • Click “New Query”.
  • Run the following script to intentionally cause repeated SQL errors:
SELECT 1/0
GO 100

This will generate 100 division-by-zero errors.

In AimBetter, go to:

  • Observer module → Event Log tab.
  • There should be events under the Syntax Exception category.
  • If No Errors Appear, proceed to Extended Events Cleaning as described below.

Extended Events Sessions Cleanup

  • In SSMS, open Object Explorer.
  • Navigate to: ManagementExtended EventsSessions
  • Perform the following cleanup:
    • Delete any sessions that start with Montarget → Right-click → Delete
    • Stop all other running sessions → Right-click on each → Stop
  • Wait 2–3 minutes.
  • Repeat the SQL Activity Test to check if events now appear in AimBetter.

AimBetter folder logs

If all the previous checks and procedures didn’t solve this issue, follow the instructions to send the AimBetter folder logs to our support team.

Was this article helpful?