How to Start or Enable and Stop or Disable Extended Event Session in SQL Server - MS SQL Server DBA Tutorial

In this video you will learn how to Start and Stop session in Extended Events of SQL Server, how to navigate to Extended Events in SQL Server using SQL Server management studio. It also explains how to start or enable and stop or disable Extended event session using T-SQL Script. How to view Package data of a session in Extended Events in SQL Server.

Script to Start/Stop Extended Event

--Stop event session
ALTER EVENT SESSION [DatabaseEvent] ON SERVER 
 STATE=STOP

--Start Event Session
ALTER EVENT SESSION [DatabaseEvent] ON SERVER 
 STATE=START


How to Start or Enable and Stop or Disable Extended Event Session in SQL Server

No comments:

Post a Comment