Viewing 15 posts - 11,521 through 11,535 (of 22,219 total)
Lots of key lookup operations. I'd be concerned that my clustered indexes are not useful. And that SORT operator is the main cost currently. See if you can modify that...
"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
December 13, 2011 at 8:23 am
ashanair70 (12/12/2011)
"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
December 12, 2011 at 7:22 am
And after copying the files use ATTACH to get the database set up on the new server.
"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
December 12, 2011 at 6:48 am
And there is the problem with the DTA in a nutshell. How important are the suggestions it has, not even worrying about whether or not those suggestions are helpful.
Unfortunately, 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
December 12, 2011 at 6:12 am
What do you mean by "refresh"? There's not a command or process that specifically defines this, so you could be referring to a lot of different things.
"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
December 12, 2011 at 6:06 am
Looking at the query, we're really going about it the hard way. A little searching brought up this, and Isaac Kunen's solution. Try that instead.
"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
December 9, 2011 at 10:53 am
Nuts. I wasn't paying attention... again...
Yeah, 2008 is problematic. They fixed stuff in R2. If you're doing spatial, you really need to move. That's the only good solution. Sorry.
"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
December 9, 2011 at 9:26 am
Hmmm.... I'd try low too. The density stuff seems counter-intuitive sometimes.
"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
December 9, 2011 at 8:14 am
Do you have an index in place? If so, start messing with the density on the index. I found that changing[/url] that has interesting impact. The key to 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
December 9, 2011 at 7:25 am
Hmmm... I'm stumped. I'm not sure why that TOP is in there. But, I don't know that I'd sweat it at the moment with all those clustered index scans to...
"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
December 8, 2011 at 12:39 pm
Stefan Krzywicki (12/8/2011)
Grant Fritchey (12/8/2011)
Stefan Krzywicki (12/8/2011)
Grant Fritchey (12/8/2011)
Stefan Krzywicki (12/8/2011)
Brandie Tarvin (12/8/2011)
"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
December 8, 2011 at 12:23 pm
Stefan Krzywicki (12/8/2011)
Grant Fritchey (12/8/2011)
Stefan Krzywicki (12/8/2011)
Brandie Tarvin (12/8/2011)
Have you cleared the cache to make sure it isn't still trying to pull info from the cached copy of the proc?
It...
"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
December 8, 2011 at 12:00 pm
Stefan Krzywicki (12/8/2011)
GilaMonster (12/8/2011)
RECOMPILE means that the plans will never be cached and hence will have to be recreated on each execution. Grant has a blog...
"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
December 8, 2011 at 9:36 am
Stefan Krzywicki (12/8/2011)
Brandie Tarvin (12/8/2011)
Have you cleared the cache to make sure it isn't still trying to pull info from the cached copy of the proc?
It is a production server,...
"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
December 8, 2011 at 9:34 am
What you need to do is set up a design where the tables define the screen. That's going to be hard to build and hard to program. No way around...
"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
December 8, 2011 at 5:35 am
Viewing 15 posts - 11,521 through 11,535 (of 22,219 total)