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,137 reads
Jason Brimhall
Session Action Metadata
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
5 reads
Predicate Order is Critical
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,182 reads
Session Event Metadata
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
1 reads
Deployed Session Settings
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
1 reads
The Extended Event GUI
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
2 reads
Assembling a Session
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
Assembling a Session
Up to this point, I have taken a lot of time to discuss the various components of Extended Events. There is...
2015-09-24
539 reads
Extended Events – Events
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,434 reads
Freecon – Oct 27 in Seattle
Just over a week ago I announced that SQL Solutions Group was getting ready to host a day of training,...
2015-09-23
807 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers