SQL Server Events – No SQL Activity in the Observer Module

If no events have been recorded for a long time in the SQL layer (there is zero SQL Activity in the Observer Overview tab), it may be related to a problem in capturing SQL error events. In this scenario, proceed with the following verifications. This procedure is intended for environments using Microsoft SQL Server.

SQL Activity Test

• Open SQL Server Management Studio (SSMS) in the monitored server.
• 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: Management → Extended Events → Sessions

• 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.