How can we help you today? How can we help you today?

Monitoring Error clustered SQL instance

Hello
We're getting a monitoring error on one of our SQL instances which is hosted on a classic Windows Failover cluster.
The error repeats every 2 minutes:
Event: QueryInstanceSampler
Outcome: Internal Redgate Monitor error
Exception: SqlException
Exception message: Arithmetic overflow error converting expression to data type bigint.

I have had a look and there are no errors in the SQL log or the server's event logs. I believe the issue is the attached query that runs from the monitor...any advice please?

Thanks


Sebastiano Quattrocchi
0

Comments

3 comments

Sort by
  • Tom Claringbold
    Official comment

    Hi Sebastiano Quattrocchi,

    Apologies for the delayed response on your question, we'd migrated from our previous forum and solution and a small number of these posts weren't properly migrated.

    For the issue you're seeing I think it would be helpful to request a copy of your log files so I'll be reaching out via an internal ticket and we'll go from there.

    Kind regards,
    Tom

    Tom Claringbold
  • Tom Claringbold

    Hi Sebastiano Quattrocchi,

    Many thanks for your patience on this, our development team have just merged a fix that should resolve this issue.

    This will be included in our next release (14.0.53) which is expected next week. Will let you know when this version is made available.

    Kind regards,
    Tom

    Tom Claringbold
    0
  • Tom Claringbold

    Hi Sebastiano Quattrocchi,

    As mentioned, a fix has now been released as part of 14.0.53 to address this, any issues updating or post update please let us know.
     
    https://documentation.red-gate.com/monitor14/redgate-monitor-14-0-release-notes-240977444.html
     

    Fixes

    • Fixed an arithmetic overflow issue when sampling query executions.

    Kind regards,
    Tom

    Tom Claringbold
    1

Add comment

Please sign in to leave a comment.