I'm a bit confused as to whether or not it is possible to use the SQL Profiler on the Web/Express edition of SQL Server.
From what I've read so far people generally say "No - it was removed in SQL Server 2012/2014". But then I read the edition/feature overview page:
It says "No", but with this cryptic note:
SQL Server Web, SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services can be profiled using SQL Server Standard and SQL Server Enterprise editions.
That led me to do an actual test. I installed SQL Server 2014 Express edition on my workstation, including the SQL Profiler, and was able to connect the profiler to the instance and run traces without any apparent problems.
Maybe this is because I'm running both instance and profiler locally, or perhaps because I also have a full developer version SQL Server 2008 installed? Any hints or answers would be appreciated, I would hate to configure my new (upcoming) server with the Web edition, and then find out that I was unable to use the Profiler (which is the only reason I would choose Standard instead of Web edition).