New answers tagged profiler
'Creating sort index' is the database figuring out the order of your returned values based on your 'order by' clause. Main limiters here would be available CPU/CPU speed, and memory bandwidth. The sort wont be done until the data is already all in memory, at least for a query this small. If you profile the query, do you see any waits for any resources? As ...
First, if you're using SQL Server 2008 or higher, the Profiler is deprecated - look into using Extended Events instead. The ## marks serve as a placeholder for the value of the variables being used in the query.
Let's get one thing straight first - is the application Profiler running, or is it a server-side trace running? If it's the former, then stop doing that and just run the server-side trace instead. Writing 20GB of trace file per day is not necessarily awful, but it's a lot of information to try to analyse, and some harsher filtering could be useful. For ...
You've got a few different questions in here. Q: Is it really a good practice to run Profiler on a production system? Generally, you want to avoid doing it, but there can be situations where it's the most efficient way to solve a problem. For example, if you've got a SQL Server 2005 box, and every query comes in with OPTION RECOMPILE so it doesn't stick ...
Top 50 recent answers are included