Viewing 15 posts - 4,531 through 4,545 (of 22,227 total)
GilaMonster (8/19/2016)
!!!!https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing
And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.
Congrats!
"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
August 19, 2016 at 10:49 am
BLOB_EATER (8/18/2016)
Grant Fritchey (8/18/2016)
Jeff Moden (8/18/2016)
It also names the stats in a fashion almost identical to how SQL Server does it
BWA-HA-HA!
I was just having a conversation about statistics 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
August 18, 2016 at 10:02 am
Jeff Moden (8/18/2016)
It also names the stats in a fashion almost identical to how SQL Server does it
BWA-HA-HA!
I was just having a conversation about statistics in India last week...
"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
August 18, 2016 at 8:36 am
Using extended events, you can capture all the connection information and suss out if there is any information that might lead to the individual user in that way. However, 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
August 18, 2016 at 7:55 am
Brandie, go home.
"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
August 18, 2016 at 7:53 am
ChrisM@Work (8/18/2016)
Brandie Tarvin (8/18/2016)
Brandie Tarvin (8/18/2016)
Ed Wagner (8/17/2016)
"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
August 18, 2016 at 5:34 am
It means that while inserts/updates/deletes are occurring, the processing necessary to add/modify that data in that index is causing blocking of other processes. That's all. Based on this, we don't...
"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
August 18, 2016 at 4:11 am
Yes to everything Gail says. Plus, we're not even addressing whether or not we need to worry about sample size or Full Scan on the statistics updates. Different statistics and...
"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
August 18, 2016 at 3:59 am
Josh B (8/17/2016)
"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
August 17, 2016 at 11:32 am
Lots of different standards on this. My one suggestion, regardless of the method you arrive at, be consistent in applying it. Doing some stuff one way, other stuff another, 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
August 17, 2016 at 9:29 am
Yep, and could come from a number of causes. One of the easiest to explain is that you have a Spool operation which is writing out to tempdb. Another 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
August 17, 2016 at 7:34 am
Chris is also offering good advice. It just wasn't there when I started typing.
"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
August 17, 2016 at 7:31 am
Everything Lowell says.
I'm assuming that you're getting a LOOPS join, hence the estimated number of rows is 1? If so, that estimate isn't necessarily off. You need to combine 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
August 17, 2016 at 7:29 am
Brandie Tarvin (8/17/2016)
Steve Jones - SSC Editor (8/16/2016)
Brandie Tarvin (8/16/2016)
If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I...
"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
August 17, 2016 at 6:32 am
JarJar (8/17/2016)
...i've added missing indexes for all the joins possible...
based on an evaluation of the execution plans to understand where indexes are needed... I hope. Not just a blanket,...
"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
August 17, 2016 at 6:02 am
Viewing 15 posts - 4,531 through 4,545 (of 22,227 total)