Template Configuration

存储架构 2018-02-16 阅读原文

One of my goals this year is to really spend some time learning more about Extended Events (XE). I’m somewhat embarassed that almost a decade after their introduction in SQL Server 2008, I have a fairly rudimentary grasp of the system. I’ve watched talks from Jonathan Kehayias and Erin Stellato and others. I recognize the value in a lightweight system, but for some reason I haven’t done much with XE.

As part of my learning, I’m going back to the basics with videos, articles, and documentation. In one section, I ran across the templates and how they can be used to greatly simplify the creation of new sessions. I’m a bit fan of templates, and I love the ones I use for T-SQL in SQL Prompt. I know templates are incredibly useful in plenty of other areas.

XE is more complex system. The verbiage, the complexity of filtering, and the variety of targets make this a very flexible system, but also one that can overwhelm people. When do you use the histogram target v the ring buffer? What events make the most sense to solve or diagnose your system?

Today I wonder if some of you out there can share some knowledge. Are there built in templates that you find useful for certain situations? Have you created your own that speed up your analysis of an issue? If so, it would be great if you could share some code and explain why you find certain session settings useful. If you find some templates to be problematic, perhaps share that.

As I’m learning, I think that it’s likely I’ll have my own set of events and settings that I lean on heavily. Since I can save these on an instance, and not just a workstation, that’s a huge improvement over trace. These sessions can be shared with other DBAs in my organization, which is helpful and handy. Maybe one of you will give me a new template that I can add to my toolbox.

Steve Jones

The Voice of the DBA Podcast

Listen to the MP3 Audio
( 2.7MB) podcast or subscribe to the feed at iTunes
and Libsyn

Voice of the DBA

责编内容by:Voice of the DBA阅读原文】。感谢您的支持!


Cloud databases debased: AI.type virtual keyboard ... Once again,it’s time to play “spot the unsecured cloud data.” In this week’s ep...
Networking 101: DNS Forward and Reverse Lookup ... The DNS stands for the Domain Name Server. It is an important part of the Intern...
NodeJs之数据库异常处理 数据库异常 NodeJs版本:4.4.4 数据库链接错误 使用nodejs处理异常最麻烦不过,这里我抛开nodejs提供的 domain 和...
When is a senior engineer not a senior engineer? The technology industry has been overloading the term ‘senior engineer’. A senio...
【技术实验】Elasticsearch 做数据库系列之一:表结构定义... Elaticsearch 有非常好的查询性能,以及强大的查询语法。在一定场合下可以替代RDBMS做为OLAP的用途。但是其官方查询语法并不是SQL,而是一种El...