Monday, 5 January 2009

sp_monitor Error

sp_monitor returns information on cpu, network, disk activity and connections.
Sometimes when sp_monitor is run (EXEC sp_monitor;), it errors!

"Arithmetic overflow error converting expression to data type int."

Given it is an internal sql function, it's a bit bizarre.

This chap has a theory...

"I think this might be due to the fact that sp_monitor displays the interval between runs in seconds and if there has been too long a period between runs the amount of seconds is too large to be stored as an int."

No comments: