In this video you will learn how to create an Extended Event in SQL Server using SQL Server Management studio as well as using T-SQL Script. It also shows step by step process of creating a New Session, choosing events that you would like to capture, filtering the events data (fields) and saving the output to a disk location. It also demonstrates how to get list of Extended Events in SQL Server, how to watch Live Data of a session, how to analyze captured data and how to start and stop a session in extended events in SQL Server.
Script used in the video to Create Extended Event in SQL Server
Script used in the video to Create Extended Event in SQL Server
CREATE EVENT SESSION [DatabaseEvent] ON SERVER ADD EVENT sqlserver.database_attached( ACTION(sqlserver.database_name,sqlserver.nt_username,sqlserver.username)), ADD EVENT sqlserver.database_created( ACTION(sqlserver.database_name,sqlserver.nt_username,sqlserver.username)), ADD EVENT sqlserver.database_detached( ACTION(sqlserver.database_name,sqlserver.nt_username,sqlserver.username)), ADD EVENT sqlserver.database_started( ACTION(sqlserver.database_name,sqlserver.nt_username,sqlserver.username)) ADD TARGET package0.event_file(SET filename=N'C:\SQLSysBackup\DatabaseEvents.xel') WITH (STARTUP_STATE=OFF) GO
How to Create an Extended Event in SQL Server - SQL Server DBA Tutorial
It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
ReplyDeletehttp://chennaitraining.in/oracle-training-in-chennai/
http://chennaitraining.in/oracle-dba-training-in-chennai/
http://chennaitraining.in/odi-training-in-chennai/
http://chennaitraining.in/oracle-soa-training-in-chennai/
http://chennaitraining.in/teradata-training-in-chennai/
http://chennaitraining.in/informix-training-in-chennai/
http://chennaitraining.in/sybase-training-in-chennai/
http://chennaitraining.in/sql-server-dba-training-in-chennai/
This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. Shisha Hire
ReplyDeleteI invite you to the page where you can read with interesting information on similar topics. Shisha Hire
ReplyDeleteIs this a paid topic or do you change it yourself?
ReplyDeleteHowever, stopping by with great quality writing, it's hard to see any good blog today.
Active Data Studio Crack
Clip Studio Paint EX Crack
I really enjoyed reading this article! I would like to learn more about the benefits of event services.Visual Merchandising in Bangalore
ReplyDelete