Tag Info

New answers tagged

0

'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 ...


0

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.


2

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 ...


2

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