Question : Is there any option to show “Include Actual Execution Plan” plus query cost and recommended indexes in SQL […]
Tag: profiler
What exactly is SQL Server doing?
Question : We have a control table called Generators which has a NextID and varchar label. I found some bad […]
Profiler: Only want to see Provider Errors
Question : I’m replaying a trace in Profiler, and I’d like to only see the Provider Errors. Granted, there are […]
Capture live stored procedure calls (as per Query Profiler) in SQL Azure
Question : TL;DR – Is it possible to capture live procedure calls (with parameter names/values) in SQL Azure, to replicate […]
Capture and Replay workload
Question : We have a new server which we are migrating too and want to see the potential benefits of […]
Duration Field in Profiler
Question : I would like to monitor the script which takes more than 25 Sec. When i use filter i […]
Is SQL Server Profiler different from SQL Trace?
Question : In this source it is written something like this I want to know what is SQL Trace? Does […]
Slow SSRS Report in production
Question : I have an SSRS report which gets its data by firing a series of stored procedures. Now the […]
Is this considered a “light load” trace to run on SQL Server Profiler
Question : This is my first experience of using SQL Server (2012 Enterprise Edition) Profiler. I’ve set up a trace […]
SQL Profiler filter trace that is currently recording
Question : As title, If I forgot to set the filter before run. Is there a way to filter column […]