Viewing 15 posts - 3,841 through 3,855 (of 22,224 total)
Please, do what Lowell says. Normally, I wouldn't bother answering since he's already provided the correct path. However, I sense the need to pile on.
You're working with a...
"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
May 10, 2017 at 6:46 am
In addition to the other checks listed (blocking, waits, execution plan), are these delete statements deleting varying amounts of data? If the data changes, so will the behavior, sometimes radically...
"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
May 10, 2017 at 6:37 am
I'm pretty sure this is utterly impossible. About the only tool you have at your disposal around stuff like this are plan guides. You can force behaviors through hints 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
May 10, 2017 at 6:17 am
Both statements are part of a transaction. It's not that the SELECT is holding the UPDATE, it's that the UPDATE and the SELECT are executing as a set of operations.
"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
May 8, 2017 at 6:00 am
If you want to monitor for specific security changes, I'd suggest using extended events and then you'll need to filter for statements that are changing the permission on the user....
"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
May 8, 2017 at 5:57 am
"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
May 8, 2017 at 4:51 am
"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
May 5, 2017 at 11:47 am
"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
May 5, 2017 at 10:05 am
"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
May 5, 2017 at 8:50 am
I hate to say it, but I don't know that I want to get tied down to doing it the same way every time regardless.
I mean, for stored...
"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
May 5, 2017 at 7:55 am
You want to use the function sp_create_plan_guide. The basics are pretty simple. Copy your query, and it has to be a perfect copy, including all the white space...
"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
May 5, 2017 at 7:05 am
Actually one other thing does come to mind. You could try using Plan Guides to force the good plan. On a query this complex and a plan this big... 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
May 5, 2017 at 6:43 am
These queries are pretty huge. Trying to unpack it all will take a lot of time. I'll focus on one thing. Both plans are timing out in the optimizer. Timeouts...
"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
May 5, 2017 at 6:42 am
Linked servers are, unfortunately, a very widely used practice. They're not a very widely recommended practice because of all the issues that they cause. However, they're so very convenient, making...
"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
May 5, 2017 at 6:30 am
Which, it's worth noting, will rollback open transactions. Not the end of the world or anything, but worth noting.
"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
May 5, 2017 at 6:19 am
Viewing 15 posts - 3,841 through 3,855 (of 22,224 total)