Viewing 15 posts - 3,751 through 3,765 (of 22,219 total)
It sure sounds like direct intervention by a person. However, do you have a monitoring tool of some kind that has the capacity to interfere with long running jobs?
"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
June 21, 2017 at 6:33 am
You're not saying which cloud environment you're looking at. Let's say it's Azure. Then, yes, there is absolutely a way to "clone" the environment using ARM Templates. To learn about...
"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
June 21, 2017 at 5:29 am
Ah, looked at the code. the ISNULL function in the JOIN criteria is going to result in no statistics being used on the column. Pre-2014 cardinality estimation will be 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
June 15, 2017 at 9:17 am
Estimated rows may be 1, but how many estimated executions? The two combine frequently depending on the other operators in the plan.
"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
June 15, 2017 at 8:29 am
Are you using a VM on Azure, or Azure SQLDB (the PaaS offering)?
The DMVs are...
"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
June 14, 2017 at 8:22 am
It's an 8gb server running two instances at the same time, one production and the other test and you're worried that the test instances, and only the test instance, 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
June 14, 2017 at 5:43 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
June 13, 2017 at 9:40 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
June 13, 2017 at 5:50 am
Test the restore process regularly. That's the best thing to do for any backup. I also like the idea of adding a mid-day diff. Test that too though. And test...
"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
June 13, 2017 at 1:41 am
No for sure 100% method on this. Make sure you backup the databases and you backup the server. Test the backup on the databases to ensure they're correct. Then install...
"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
June 13, 2017 at 1:38 am
Yep, absolutely, Extended Events.
You also have access to the same DMVs to query the cache, sys.dm_exec_requests, etc., and you have Query Store, which is on by default 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
June 9, 2017 at 7:07 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
June 9, 2017 at 6: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
June 8, 2017 at 11:49 am
I trust Edwin to know what he's talking about, so here's a good article. I'd pay attention to the caveats because that's where the pain points may come...
"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
June 8, 2017 at 5: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
June 7, 2017 at 1:02 pm
Viewing 15 posts - 3,751 through 3,765 (of 22,219 total)