Arithmetic overflow error for data type tinyint, value = 256.

Hi
this morning i has some problems in monitoring one of our server with Idera Check.
As suggested I updated to the new version of Idera SQL Check, but still i have the following error when I try to connect
“Arithmetic overflow error for data type tinyint, value = 256.”

Can you give me some hits of how to solve this problem?

Parents
  • Please change this:

    CAST((@@CPU_BUSY + @@IO_BUSY + @@IDLE) AS BIGINT) as TotalCPU, 

    to this:

     ,CAST(@@CPU_BUSY AS BIGINT) + CAST(@@IO_BUSY AS BIGINT) + CAST(@@IDLE AS BIGINT) AS TotalCPU

    and the error is gone.

    Thx!

Reply Children
No Data