Session Action Metadata
In a previous article, I introduced the core concept of Actions. In that article, I explained that an Action is...
2015-09-30
1,144 reads
In a previous article, I introduced the core concept of Actions. In that article, I explained that an Action is...
2015-09-30
1,144 reads
Knowing how to access the deployed session metadata and the event metadata attached to that session, I will now begin the dive into how to find the same relevant...
2015-09-30
9 reads
I have mentioned predicate order previously and wanted to make sure I drive home the importance of the predicate order...
2015-09-29 (first published: 2015-09-23)
3,192 reads
There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to know where and how to find it. In this...
2015-09-29
3 reads
Deployed Session Settings are stored within the system databases and then exposed via system catalog views. These settings help define a session. This article shows how to access those...
2015-09-28
8 reads
The Extended Events GUI provides a visual access to the Extended Events engine that can help to better understand the XEvents Engine and how a Session is built.
Related Posts:
Profiler...
2015-09-25
5 reads
With the core concepts in place as a good foundation to Extended Events, we start pushing these things together to help with assembling a session in Extended Events.
Related Posts:
Short...
2015-09-24
2 reads
Up to this point, I have taken a lot of time to discuss the various components of Extended Events. There is...
2015-09-24
543 reads
After thrilling dives into the XEvent Core Concepts of packages, channels and objects, today we have the core concept of...
2015-09-23 (first published: 2015-09-10)
1,441 reads
Just over a week ago I announced that SQL Solutions Group was getting ready to host a day of training,...
2015-09-23
811 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers