Viewing 15 posts - 2,761 through 2,775 (of 22,202 total)
January 22, 2019 at 12:54 pm
January 22, 2019 at 6:08 am
Yeah, same here. Not surprised that it used Distributed Replay though.
January 18, 2019 at 7:22 am
January 17, 2019 at 2:27 pm
January 17, 2019 at 2:25 pm
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.
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...
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,...
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.
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....
January 17, 2019 at 7:01 am
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...
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...
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...
January 16, 2019 at 6:45 am
Viewing 15 posts - 2,761 through 2,775 (of 22,202 total)