Please Share your Product Ideas with us!

The current Debug Log tables only display hours and minutes in their timestamp values.  This can be quickly seen by executing these queries:

--Collect

SELECT * FROM DataGarage.dbo.ttDebugLog

--Common

SELECT * FROM DSPCommon.dbo.ttDebugLog

--dspCompose

SELECT * FROM cMass.dbo.ttDebugLog

--dspConduct

SELECT * FROM DGE.dbo.ttDebugLog

--dspTrack

SELECT * FROM dspTrack.dbo.ttDebugLog

--Integrate

SELECT * FROM Integrate.dbo.ttDebugLog

 

The code which writes to these tables could likely be adjusted to include seconds, because this would be handled fine by the SMALLDATETIME datatype.

 

An example of a debug activity which would benefit greatly from the inclusion of seconds in the timestamps:

• 200 different validation views are executed (and individually logged) by a 'Finish' event in dspConduct.  A user reviewing the debug log wishes to identify any views that took longer than 10 seconds to execute, so that those views can be tuned to increase overall performance.

 

Thank you for considering this enhancement.