Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


SQL SERVER | SSMS 17.3 New Feature – XE Profiler

In this post we shall understand a new feature added in SSMS by Microsoft caleld XEvent Profiler. It displays a live viewer window of extended events.

XE Profiler
Connect to SQL Server -> Go to object explorer -> then at the below you can get XE profiler

Double-click Standard if you want to view all extended events in this session. Click T-SQL if you want to view the logged SQL statements. If a session is not already created, a session is created for you.

Notes from MS

1. XEvent profiler is directly integrated into SSMS and is built on top of the scalable Extended Events technology in the SQL engine.

2. This feature enables quick access to a live streaming view of diagnostics events on the SQL server.

3. This view can be customized and those customizations can be shared with other SSMS users as a .viewsettings file. The session created by XE Profiler is less intrusive to the running SQL server than a similar SQL trace would be when using SQL Profiler. This session can be customized by the user as well, using the existing XE session properties UI or by TSQL.

Note – It is only available on SQL Server Management Studio (SSMS) v17.3 or later

Reference –

https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/use-the-ssms-xe-profiler

Other new features in SQL SERVER 2017

# New Feature URL
1 1 https://msbiskills.com/2018/02/02/new-features-in-sql-server-2017-complete-list/

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Advertisements