Viewing 15 posts - 2,266 through 2,280 (of 22,220 total)
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
Good article (and yeah, I know it's older, I just saw it). I'm a huge proponent of Extended Events, so it's awesome to see them getting promoted.
One note, the deadlock...
"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:20 pm
That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / 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
December 5, 2019 at 4:11 pm
That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / 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
December 5, 2019 at 4:10 pm
That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said...
"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 5, 2019 at 3:36 pm
Viewing 15 posts - 2,266 through 2,280 (of 22,220 total)