Exception Pop Up

SQLMon 4.3.alpha.6 - Windows 7 64 BIT Client SQL Monitor SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with in...

Id #34364 | Release: None | Updated: Aug 20, 2013 at 8:00 PM by pollusb | Created: Aug 13, 2013 at 3:52 PM by jeferson07

Exception Pop Up

SQL Monitor A Task's exception(s) were not observed either by Waiting on the Task or accessing its Exception property. As a result, the unobserved exception was rethrown by the finalizer thread. O...

Id #33811 | Release: None | Updated: Mar 10, 2013 at 7:15 AM by unruledboy | Created: Feb 22, 2013 at 4:01 PM by DeveloperMax2

AnalsisTab->Type:Performance - Cut and Paste, creating multiple rows per entry now

SQLMon 4.3.0.4 - Windows 7 Client - Windows 2008 R2 64 BIT with Sql 2008 R2 64 BIT. Highlight all by using shift and arror keys. (Might want to add a copy feature) Ctrl-C to copy the data. Cut an...

Id #33810 | Release: None | Updated: Mar 10, 2013 at 7:26 AM by unruledboy | Created: Feb 22, 2013 at 2:47 PM by DeveloperMax2

longest distance reco, find dup code

longest distance reco, find dup code

Id #32510 | Release: None | Updated: Feb 22, 2013 at 12:22 AM by unruledboy | Created: Mar 30, 2012 at 5:40 AM by unruledboy

allow define alarm thresholds according to TOD

allow define alarm thresholds according to TOD

Id #32163 | Release: None | Updated: Feb 22, 2013 at 12:22 AM by unruledboy | Created: Feb 2, 2012 at 1:31 AM by unruledboy

error in perf graph

SQL Monitor Axis Object - The minimum value of the axis is greater than the largest data point value. OK

Id #32057 | Release: None | Updated: Feb 22, 2013 at 12:22 AM by unruledboy | Created: Jan 10, 2012 at 1:37 AM by unruledboy

expensive query cpu order by avg elapsed time

expensive query cpu order by avg elapsed time

Id #32016 | Release: None | Updated: Feb 22, 2013 at 12:22 AM by unruledboy | Created: Dec 30, 2011 at 6:30 AM by unruledboy

query stats

begin try use [EDGE1] ; declare @dbid int; set @dbid = db_id(); declare @grand_total_worker_time float ; declare @grand_total_IO float ; declare @sql_handle_convert_table table( row_id in...

Id #31962 | Release: None | Updated: Feb 22, 2013 at 12:22 AM by unruledboy | Created: Dec 16, 2011 at 4:15 AM by unruledboy

find index usage/unused/duplicated/missing

--unused SELECT OBJECT_SCHEMA_NAME(I.OBJECT_ID) AS SchemaName, OBJECT_NAME(I.OBJECT_ID) AS ObjectName, I.NAME AS IndexName FROM sys.indexes I WHERE -- only get indexes for user created tables ...

Id #31954 | Release: None | Updated: Feb 22, 2013 at 12:22 AM by unruledboy | Created: Dec 15, 2011 at 11:48 PM by unruledboy

new Top n query

select * from sys.sysprocesses p left join sys.dm_exec_query_stats s ON p.sql_handle = s.sql_handle select * from sys.dm_exec_sql_text(0x030011009CD0FB1590680701A99F000001000000)   http://msdn.micr...

Id #31949 | Release: None | Updated: Feb 22, 2013 at 12:22 AM by unruledboy | Created: Dec 14, 2011 at 10:56 PM by unruledboy