October 14, 2009 at 9:11 pm
Comments posted to this topic are about the item SQL Server Information
October 15, 2009 at 3:25 am
This was removed by the editor as SPAM
October 15, 2009 at 3:45 am
Not an easy one for me but I managed to get the correct answer
October 15, 2009 at 10:02 pm
very nice
October 16, 2009 at 7:19 am
Hmm, really got me interested, but when I ran it on our production OLTP server (24x7), I received an error (below) as well as the total numbers were almost too large to really comprehend.
last_run current_run seconds
----------------------- ----------------------- -----------
2009-10-16 08:09:22.080 2009-10-16 08:10:44.320 82
cpu_busy io_busy idle
------------------------- ------------------------- -------------------------
Msg 8115, Level 16, State 2, Procedure sp_monitor, Line 99
Arithmetic overflow error converting expression to data type int.
packets_received packets_sent packet_errors
------------------------ ------------------------ ------------------------
-825425941(33688) -613013560(33864) 38(0)
total_read total_write total_errors connections
------------------- ------------------- ------------------- ------------------
225040132(71) 288797707(2561) 0(0) -1069451257(32852)
Mike Byrd
October 16, 2009 at 8:28 am
Mike Byrd (10/16/2009)
cpu_busy io_busy idle------------------------- ------------------------- -------------------------
Msg 8115, Level 16, State 2, Procedure sp_monitor, Line 99
Arithmetic overflow error converting expression to data type int.
The next time you run this (if you don't wait year), you won't get the overflow.
October 16, 2009 at 9:37 am
I ran it several times this morning -- everytime getting same error.
Mike Byrd
October 16, 2009 at 10:15 am
Mike Byrd (10/16/2009)
I ran it several times this morning -- everytime getting same error.
Mike, do you get an overflow error if you run
select @@cpu_busy
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply