SQL Server 2012 Extended Event-Set Session Event Filter

Question

 I am doing an exercise to create a new session using SQL server 2012 extended event feature.

--I am not able to see the drop down menu for 'set session event' filter when using 'new session wizard.

--I found a work around by creating the session first (skipped steps to set session event' field. after the session is created, then I add the filter field back to the session.

-please advise me if there a modification needs to be done on SQL Server so I can see the contents from the create new session Wizard?

image 1 showed the 'filter field' from create session wizard. When I clicked on the field drop down menu, it showed the options on upper left hand corner for short amount of time, then options are disappeared. I can't choose anything. http://www.jshu06.com/tsql/sql-server-set-sessioin-event-filter1.png

image 2 showed the filter field after I created the session. I was able to highlight 'sql_statement_completed' entry, then choose options from the filter field.http://www.jshu06.com/tsql/sql-server-set-sessioin-event-filter.png section

---

Jeff

Answer 1

I was not able to repeat this. What version does SSMS report when you do Help->About? Make sure that you have the most recent service pack installed on your workstation.

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 2

Hello Erland: 

 My SSMS version is 11.0.3156.0.

 My operation system is Windows 7 home premium

 Service pack 1

information from the help section

 Microsoft SQL Server Management Studio 11.0.3156.0
Microsoft Analysis Services Client Tools 11.0.3130.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 6.0 
Microsoft Internet Explorer 9.10.9200.17414
Microsoft .NET Framework 4.0.30319.1026
Operating System 6.1.7601

---

Jeff

Answer 3

That is SP1 of SQL 2012. I suggest that you install SP2. Note sure whether it helps, but installing the latest Service Pack is always a good idea when you run into things like this.

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 4

Hi Jeff,

In addition to other post, please make sure that there are no third-party add-ins in SQL Server Management Studio (SSMS) , also turn off any anti-virus software. If the issue persists after checking the above things, I would suggest uninstalling and reinstalling SSMS  and verify if the 'set session event' filter works properly.

Besides, you can choose to create Extended Events sessions by using T-SQL statement, which is a more flexible method. For more details, please review  this article: https://msdn.microsoft.com/en-us/library/bb677289.aspx?f=255&MSPPError=-2147217396.


Thanks,
Lydia Zhang

---

Lydia Zhang
TechNet Community Support