Tag: Xevents
This tag groups together all the posts and articles related to SQL Server Extended Events.
-
Too many Extended Events sessions? Take control, see what’s running and stop unnecessary sessions
Have you got too many extended events sessions running on your production server? Not sure which ones are running and which ones are needed? Read this article and learn how to take control of your extended events sessions
-
Audit SQL Server login activity with Extended Events: Who connected, when, from where, how often & verify connection pooling
This article provides you with a stored procedure that sets up an Extended Events session in SQL Server to track all the successful logins. It then summarises the data from the .XEL file into usable format, so you can see which logins are connecting from where, via which application, how often they connect, is connection…
-
Using Extended Events, how to track who is using a table/view/stored procedure etc. in my SQL Server database?
This article will show you how to identify which user, application or login is using a database object (table/view/stored procedure etc.) in your database. This technique uses the lock_acquired event via extended events. Very useful if you are looking to find out is anyone is using a database object, before dropping it.
Latest Articles
