Viewing 15 posts - 2,266 through 2,280 (of 22,224 total)
The information put into the missing index DMVs is taken from the information put into execution plans. So, yes. they are directly correlated.
I strongly recommend you abandon the missing index...
"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, 2019 at 12:53 pm
A strong suggestion.
Listen to what Lynn has said. Your best bet would be to get someone who knows what they're doing in to teach you. Not to have them do...
"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, 2019 at 12:21 pm
I suspect that they are someone who is way in over their head, and uses places such as here to "do their job".
Just to be a contrarian, I'm ok...
"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, 2019 at 12:16 pm
Different Ways to Improve SQL Query Performance
Avoid Multiple Joins in a Single Query. ...
Whoa!
No. Absolutely not. You structure your data as is appropriate with primary keys and enforced referential...
"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, 2019 at 12:03 pm
Which version of SQL Server are we talking about because CXPACKET waits either mean nothing at all, or are strong indicators of CPU use.
Regardless, if I were you, you know...
"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, 2019 at 11:49 am
if at any point they said " did you try turning it off and on again" I would have died laughing.
I have actually received that as an answer before....
"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 6, 2019 at 4:25 pm
p.s. I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies". It there's not a well documented ticket to support the urgency, 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 6, 2019 at 3:35 pm
there is absolutely no excuse for shoddy code. Just freakin' doit! 😀
Words to live by.
"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 6, 2019 at 3:31 pm
I just don't like the user interface or scripting for extended events - that's the only reason I go back to profiler traces #ineedtogetoutofmycomfortzone
The scripts are better in ExEvents....
"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 6, 2019 at 3:25 pm
Yes, and a history of the changes that have been made (date, person, description of change).
John
Oh, I hate disagreeing with people, but
NOOOOOOO!!!!!
Don't do this. Your procs (and all 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
December 6, 2019 at 3:20 pm
Is the index unique? That can change the choices made by the optimizer even though the index isn't used in the plan. Otherwise, I'm with Lynn, test it, post 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
December 6, 2019 at 3:11 pm
"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 6, 2019 at 3:08 pm
I'm not sure how far I'd go beyond:
Name
This is what it does, in short, clear, descriptive phrases
These are the parameters
These parameters are required
These parameters have default values and here they...
"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 6, 2019 at 2:59 pm
So, for actively running queries, I recommend the DMVs, sys.dm_exec_requests is a good starting point. You can join that to other DMVs to get the execution plan, the SQL statement...
"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 6, 2019 at 2:55 pm
Well, just in case you have more issues like this, I'd like to recommend my books. Query tuning is a pretty vast topic. Follow the links below.
"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 6, 2019 at 2:46 pm
Viewing 15 posts - 2,266 through 2,280 (of 22,224 total)