February 11, 2015 at 5:20 am
Hi experts,
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 foot 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 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).
Best regards,
Torben
February 19, 2015 at 11:35 am
Profiler should work against any edition and versions. I can profile an express instance without issue( i dont have a web edition to test with). Its just that you can only install Profiler from Enterprise, Business Intelligence, or Standard install media. If you dont have profiler installed then the web edition installation will not include profiler with the tools.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply