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 (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)

Group: Administrators
Points: 619764 Visits: 21258
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 (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14719 Visits: 2461
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 (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)

Group: Administrators
Points: 619764 Visits: 21258
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 (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 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 (20 views, 979 bytes)
XE.sql.txt (36 views, 4.00 KB)
Steve Jones
Steve Jones
SSC Guru
SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)SSC Guru (619K reputation)

Group: Administrators
Points: 619764 Visits: 21258
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
SSCrazy Eights
SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)

Group: General Forum Members
Points: 9352 Visits: 1691
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.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8765 Visits: 2088
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 (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14719 Visits: 2461
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