Viewing 15 posts - 8,476 through 8,490 (of 22,232 total)
If you have the clustered index key value in the WHERE clause and you're still getting a scan, the suggestion is that you must have one of two situations, your...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 4, 2014 at 5:52 am
MyDoggieJessie (4/3/2014)
Grant, what would be the best way to achieve that? SET STATISTICS TIME ON?
That's one way, sure. I'd probably use extended events, or, on a 2008 system, trace....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 4, 2014 at 3:31 am
But you can see an aggregation of the queries currently in cache in sys.dm_exec_query_stats. It shows execution times, counts, other stuff like that, but not who did the executing or...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2014 at 5:06 pm
It goes back to the histogram on the statistics. That is only build on the first column in the index key. The others are used to help establish the density...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2014 at 4:56 pm
Query performance measures alone won't show you what is blocking or being blocked. Since you're on 2012 you can use the blocked_process_report extended event. That will tell you what is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2014 at 4:08 pm
Best thing to do is get that thing local. Any cross network process you go through is going to be extremely painful.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2014 at 3:59 pm
You measure the speed at which queries that access that index are performing before and after you defragment the indexes.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2014 at 3:50 pm
patrickmcginnis59 10839 (4/3/2014)
Grant Fritchey (4/3/2014)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2014 at 8:34 am
Cody K (4/3/2014)
- XML is a first-class citizen in SQL Server and as far as validation goes that's what DTDs are for. Right?
- I'm not...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2014 at 8:33 am
Not a problem. Happy to pitch in.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2014 at 5:32 am
It's an approach taken by a developer or development team that doesn't understand SQL Server, or, just didn't want to take the time to do things correctly. It's very fast...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2014 at 4:38 am
Hard to tell for sure what's going on without seeing the execution plan. Chk001 sounds like a column derived somewhere else within the plan. A key lookup suggests that you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2014 at 4:35 am
Probably not. You'll note that the leading edge of the key, the first column, is different between the two indexes. That's one of the bigger driving factors for index selection...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2014 at 4:33 am
It wouldn't "elect" to. Some script at some point had to declare that it should.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 2, 2014 at 12:33 pm
Just remember, SQL Server will always use every bit of memory that let it have. It's very normal and by design to see all the memory in use. You've done...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 2, 2014 at 11:04 am
Viewing 15 posts - 8,476 through 8,490 (of 22,232 total)