October 31, 2002 at 10:49 am
I'm running sql 7 sp3
Is there a fix for this?
last_run current_run seconds
--------------------------- --------------------------- -----------
2002-10-31 12:24:39.687 2002-10-31 12:29:31.077 292
Server: Msg 8115, Level 16, State 2, Procedure sp_monitor, Line 94
Arithmetic overflow error converting expression to data type int.
packets_received packets_sent packet_errors
------------------------ ------------------------ ------------------------
1517969(202) 799639(101) 1(0)
total_read total_write total_errors connections
------------------- ------------------- ------------------- ------------------
1073015(211) 4126404(550) 0(0) 1687865(626)
John Zacharkan
John Zacharkan
October 31, 2002 at 11:33 am
We are also getting this on our machine. The problem seems to be because out @@IDLE value is quite large. Of course our machine has been up for quite a while. If your machine has a high @@IDLE value then I would think if, you rebooted the box it might fix your problem. Of course you could also rewrite the sp_monitor sp to support large @@IDLE setting. Possibly that is why SQL 200) supports BIGINT values.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
October 31, 2002 at 2:49 pm
or just change this code:
/*
** Set @mspertick. This is just used to make the numbers easier to handle
** and avoid overflow.
*/
select @mspertick = convert(int, @@timeticks / 1000.0)
to be: select @mspertick = convert(int, @@timeticks / 10000.0)
John Zacharkan
John Zacharkan
March 11, 2021 at 5:10 pm
How /where can i obtain DDL for sp_Monitor?
Likes to play Chess
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy