Home Dashboard Directory Help
Search

Extended Events Durations by Ola Hallengren


Status: 

Active


11
0
Sign in
to vote
Type: Bug
ID: 786158
Opened: 5/2/2013 2:10:49 PM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description


The durations for some extended events are in milliseconds and some are in microseconds. It is not always documented.

Could I ask to have this made consistent to microseconds or at least clearly documented in the field descriptions.
Details
Sign in to post a comment.
Posted by Microsoft on 4/15/2014 at 6:49 PM
We have reopened the DCR. We are planning to address it in the next release of the product.
Apologies for the confusion.

Thanks,
Jos
Posted by F. Dwarf on 2/28/2014 at 10:55 AM
If not fixed, could it be at least well documented?
Posted by Ola Hallengren on 11/6/2013 at 3:36 PM
Thank you for the answer. I think that it is very confusing for users (especially as it is not documented in the Field Descriptions for all events), and that you should try to get it fixed (it is wait_info and wait_info_external that should be changed from milliseconds to microseconds). I think that Microsoft has invested a lot of resources in Extended Events in the last 2 - 3 releases, and that it is important to fix issues that are reported to make it as easy as possible for users to go from Trace to Extended Events. Maybe it could be fixed in a service pack or a cumulative update package?
Posted by Microsoft on 11/6/2013 at 12:03 PM
Hi Ola,

Thanks for your feedback. Unfortunately we aren't able to include this fix as it doesn't meet our prioritization bar for the next release. If this is an urgent issue that is causing functional problems or causing significant issues using SQL Server, please let us know and we will re-consider.

Thanks.
Posted by Shawn Quillman on 8/29/2013 at 12:38 PM
There is also discrepancy within the same events between SQL Trace and extended events. For example, auto growth durations for SQL trace are reported in milliseconds, as documented at http://technet.microsoft.com/en-us/library/ms187491.aspx. However, XE auto growth duration is clearly reported in microseconds. I can't find a reference for XE autogrowth fields, though. I had to use the difference between StartTime and EndTime to confirm.
Sign in to post a workaround.