SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Template Configuration


Template Configuration

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)

Group: Administrators
Points: 547234 Visits: 20703
Comments posted to this topic are about the item Template Configuration

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
call.copse
call.copse
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12726 Visits: 2301
Has anyone got a decent, plain English explanation of what XE can do for you? My eyes glaze over somewhat reading the below:
https://technet.microsoft.com/en-us/library/bb630354(v=sql.105).aspx

It sounds like it may be useful but I've really no way of knowing from that...for instance the heading 'Correlating request activity with Windows ETW logs' the example is in English but I'm buggered if I know what it means, it seems to be saying XE can help you find out that slow disk reads are a physical I/O problem. Which solves what? Sorry to be dense and all.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)

Group: Administrators
Points: 547234 Visits: 20703
XE is a tracing system that can capture all activity occurring in SQL Server. This replaces SQL Trace/Profiler, which is a more heavyweight way of gathering activity. SQL Trace also lacks many of the events added post SQL 2008R2.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jon Brune
Jon Brune
SSC Veteran
SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)

Group: General Forum Members
Points: 207 Visits: 323
I find XE easy to hate. Sure it's lightweight, but it's tougher to deal with and a pain to get into a table so you can sort through the data using good ole SQL. Sure, I could dust off my XML querying skills, but I use SQL day in and day out so I'm much more familiar with it. In any case, here's SQL I use to create an XE Session and then I usually just look at live data. I also included the viewsettings I use in case you would be interested.
Attachments
Application Tuning.viewsetting.txt (18 views, 979 bytes)
XE.sql.txt (23 views, 4.00 KB)
Steve Jones
Steve Jones
SSC Guru
SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)SSC Guru (547K reputation)

Group: Administrators
Points: 547234 Visits: 20703
Thanks. I find XE cumbersome, but I am trying to fix that, or at least learn how to work with it better.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
robert.sterbal 56890
robert.sterbal 56890
SSCertifiable
SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)

Group: General Forum Members
Points: 7943 Visits: 1550
Jon Brune - Friday, February 16, 2018 1:31 PM
I find XE easy to hate. Sure it's lightweight, but it's tougher to deal with and a pain to get into a table so you can sort through the data using good ole SQL. Sure, I could dust off my XML querying skills, but I use SQL day in and day out so I'm much more familiar with it. In any case, here's SQL I use to create an XE Session and then I usually just look at live data. I also included the viewsettings I use in case you would be interested.

I find excel helpful to read an xml file. It does a good job of putting the file in a tabular format.

Peter Schott
Peter Schott
SSCrazy Eights
SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)

Group: General Forum Members
Points: 8075 Visits: 2053
Been trying to use XE, but they're not nearly as friendly w/ Azure SQL as they are w/ on-prem SQL. Trying to see real-time results just gives a bunch of XML. Anything else seems to require saving to Azure storage and not sure how well that parses. Sadly XE seems to be the only way to trace activity in Azure SQL unless you have a complete admin account. Profiler hasn't been updated to work with Azure AD MFA yet.

Overall, I do like what I've seen w/ XE so far, but it's still cumbersome for the cloud.
call.copse
call.copse
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12726 Visits: 2301
Thanks John, Steve and Robert. I have fiddled around now and have a basic understanding at least. Not for me right now, Profiler is going to be fine for me for the meantime, but I'm happy to know what it's about.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search