Where can I get the old, free version of Anjlab's SQL Profiler?
I've managed to find the following:
SqlExpressProfiler-1.2.1812.13.zip <-- You have to pay to use the performance dashboard.
SqlExpressProfiler-1.2.1708.7.zip
SqlExpressProfiler-1.2.1708.7.zip
SqlExpressProfiler.1.2.1624.78.zip
SqlExpressProfiler-1.1.1423.75.zip
I'll be testing them out and eliminating the dud ones.
Sql Server Profiler Free Tool
Learn about profiling background, Events, traces and Extended events and in your case you will not need a profiler, since you'll be able to do all there tricks by proper querying the sql server itself.
Take a look also on Dynamic Management Views and Functions
And finally there is one free tool available sqlexpressprofiler and also here is one more from Google code named AnjLab
Some solutions provided by Idera
Profiler in SQL Server 2012 Express
It's possible to run SQL Trace on SQL Server Express. See this link for more info: http://www.codeproject.com/Tips/332293/How-to-trace-SQL-Server-Express-without-using-SQL
Profiler is in Standard Edition. It is also in Developer Edition, which is about £50 but of course you can't use it in production.
How do I view executed queries within SQL Server Management Studio?
Use SQL Profiler and use a filter on it to get the most expensive queries.
Related Topics
Sql Server Left Join and Where Clause
Postgresql Query to Excel Sheet
Joining Multiple Common Table Expressions
Rails Activerecord - How to Fetch Records Between Two Dates
Cannot Connect to Azure SQL Database, Even with Whitelisted Ip
Resources for Database Sharding and Partitioning
Varchar(255) V Tinyblob V Tinytext
Remove Extensions from Filename
Why Is My SQL Server Order by Slow Despite the Ordered Column Being Indexed
Sql Server: Arithmetic Overflow Error Converting Expression to Data Type Int
Creating SQL Table Using Dynamic Variable Name
How to Reuse a Large Query Without Repeating It