I want to use SQL Profiler to trace the queries executed agains my database, track performance, etc. However it seems that the SQL Profiler is only available in the Enterprise edition of SQL Server 2005. Is this the case indeed, and can I do something about it?
A:
The SQL Profiler tool is only available with the Standard and Enterprise version of SQL Server, however, all version can be profiled using the tool.
Source: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
GateKiller
2008-09-04 13:22:49
+2
A:
If you are open to using third party profilers, I have used xSQL Profiler and it performed well enough.
Jon Limjap
2008-09-04 13:25:25
+7
A:
You don't need any SQL license to run the client tools (Management Studio, Profiler, etc). If your organization has a copy of the installation media for Developer, Standard, or Enterprise, you can install the client tools on your local machine under the same license.
If you're working solo, I would recommend purchasing SQL Developer edition, it's only $50.
Portman
2008-09-04 13:29:17
I always assumed the use of the client tools required some kind of license, and I'm excited at the prospect that it doesn't! Do you have a link to a MS licensing statement that confirms this?
rwmnau
2009-06-26 16:24:59
http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20Overview%20final.docx
Portman
2009-06-28 01:57:19