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:
Post a Comment