Viewing 15 posts - 2,791 through 2,805 (of 22,227 total)
"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
January 17, 2019 at 12:50 pm
Please, please, please, do not dog pile. However, you need to go and look at this execution plan. It's a doozy.
"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
January 17, 2019 at 12:48 pm
One more thing, because you seem to be reusing views, the data is getting duplicated and move multiple times. Those views are the first candidates for loading into a temporary...
"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
January 17, 2019 at 12:42 pm
Wow.
Well, I can see how a server had a problem. So, in the query, you have 10 objects. In the execution plan you have... more than 10. So,...
"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
January 17, 2019 at 12:38 pm
Nope.
The only current "alternative" is to go to a Managed Instance. These allow for traditional three part naming to do cross database queries.
"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
January 17, 2019 at 7:03 am
Ooh, that's very rare. I'd love to see the query and the execution plan from UAT.
In all likelihood, there are differences in settings between your UAT and production....
"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
January 17, 2019 at 7:01 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
January 17, 2019 at 6:57 am
I'm not aware of a tool that does this.
One thing you can do though is to capture the trace, then use Distributed Replay to play 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
January 17, 2019 at 6:55 am
And if there was a very short way through this to make most servers run really fast most of the time, I wouldn't have had to write a 900 page...
"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
January 17, 2019 at 6:44 am
poratips - Tuesday, January 15, 2019 8:42 PMThanks for pointing out GDPR and HIPAA, need to check that too
And the CPPA 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
January 16, 2019 at 6:45 am
Not sure the hospital would approve and he hasn't had alcohol in 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
January 16, 2019 at 6:44 am
I'd need to experiment to be sure, but I suspect that the account that SQL Server is running under can't access the blob storage. Focus on security.
"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
January 16, 2019 at 6:17 am
In addition to moving the databases (backup and restore, unless you want to talk third party tooling) and configuring security (which you've received a lot of good advice around), one...
"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
January 14, 2019 at 7:54 am
Yikes. Just glanced back through and spotted this:isnull(c.DBAction, '') != ''
That's another performance killer. You have a ton of tuning opportunities here without even looking...
"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
January 11, 2019 at 8:01 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
January 11, 2019 at 7:56 am
Viewing 15 posts - 2,791 through 2,805 (of 22,227 total)