Hi All,
I am looking at a way of tracking deletions to the dbo.nodes table and have tried this by using a SQL User Experience Monitor and set the critical statistic threshold to any value less than 0, but the difference is not returning a negative integer value when a node is deleted.
Here is a screen shot of my application monitor:
The SQL query "SELECT COUNT (*) FROM dbo.Nodes" returns an integer value. I have copied the UX Monitor and configured this not to count the statistic as a difference to confirm that the value returned increase or decreases.
I poll, note the value e.g. 23 and difference = 0 then add a node and poll (values return 24 & 1). I poll again and the values return are 24 & 0 - no difference between 2 polls as expected.
I remove the node, poll again and the values return 23 & 0. This I would expect to return as -1 and then trigger the critical threshold but it doesn't.
Has anyone else tried to achieve this and if they have, is there a better way of doing this?
Many thanks
Garreth