I have 2 sybase database:
one is production
one is restored from production for dev.
I try to run following
select "Procedure Cache Hit Ratio" = (Requests-Loads)*100/Requests from master..monProcedureCache
on dev, it is fine. I got Hit Ratio percentage.
But when I run it on production, I got error:
Arithmetic overflow occurred
Both production and dev has same ASE 12.5.4. How to find out the reason and fix it?