Viewing 15 posts - 16,966 through 16,980 (of 22,226 total)
I'd suspect pretty strongly you're getting blocking. If you have a blocking script, I'd run it (if not search for one in the SSC scripts over on the left), 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
July 20, 2009 at 10:58 am
Assuming a reasonable distribution of data, I would have expected to see a seek on this...
You're only accessing a few columns on the Pupil table, you might try using...
"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
July 20, 2009 at 8:24 am
GilaMonster (7/20/2009)
I can't see anything that's forcing the scan. Makes no sense...
Whew! That makes me feel better. I'm digging through this trying to spot something. I figured you were going...
"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
July 20, 2009 at 8:14 am
Thanks. I'm glad the book was useful. Post a review on Amazon!
😀
As to this, it does look like the statistics are up to date. I'm not sure what's happening precisely....
"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
July 20, 2009 at 8:01 am
There's only been a few posts this weekend. 4-6 at most.
"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
July 20, 2009 at 7:17 am
I can't see the .sqlplan file. Can you post it again?
It sounds like you might be seeing parameter sniffing.
"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
July 20, 2009 at 7:14 am
Yes, the Profiler gui is great for browsing already captured data, but it is a dangerous place to try to capture original data. Here's an explanation of why[/url].
"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
July 20, 2009 at 7:12 am
MAX works well in that situation, but depending on your indexes, TOP 1 with an ORDER BY can work consistently better. You might try that too.
"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
July 20, 2009 at 6:30 am
Another option as opposed to traveling to your training is to bring a trainer to you. My company has worked for several years with Solid Quality Mentors. They have some...
"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
July 20, 2009 at 6:27 am
And, if you're backing up a production system, if that system is using differential backups, you should backup using the COPY ONLY option so that you're not interferring with the...
"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
July 20, 2009 at 6:23 am
erictyrrell (7/17/2009)
"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
July 20, 2009 at 6:20 am
GilaMonster (7/20/2009)
Dave Ballantyne (7/20/2009)
Is it just me who internally screams , UNDERSTAND WHAT YOU ARE DOING.
Nope, not at all.
Some people want to be spoon-fed and not have to (horror) actually...
"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
July 20, 2009 at 6:11 am
Did you try updating the statisitics with a FULL SCAN? They're pretty widely out of line. That's frequently an indication that they're out of date.
You're getting a loop join on...
"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
July 17, 2009 at 11:51 am
I've never heard of anyone recovering a dropped database.
You usually can't recover from the OS because SQL Server database files are locked while SQL Server is running (and in most...
"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
July 17, 2009 at 10:45 am
You can use the information from the missing indexes DMV as a starting point for tuning. You need to carefully assess the recommendations though because they're frequently weak. I've seen...
"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
July 17, 2009 at 10:43 am
Viewing 15 posts - 16,966 through 16,980 (of 22,226 total)