Monday, January 5, 2009

sp_monitor Error

WTF!
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."

http://sql-server-performance.com/Community/forums/p/24546/137439.aspx

No comments: