Viewing 15 posts - 5,611 through 5,625 (of 22,219 total)
Oh, and please, attack the Heights, not the guns.
"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
September 2, 2015 at 7:14 am
Welcome to the party.
Sounds like you're doing well and learning as you go. Reading the articles here will help. A strong suggestion, read the questions and try to answer some....
"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
September 2, 2015 at 7:10 am
I would focus on using PowerShell. You can make the call to the procedure, capture the output to file. It's the most direct mechanism available. You'll have maximum control 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
September 2, 2015 at 7:05 am
If you add the next log backup, you should be able to get to 3:10.
"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
September 2, 2015 at 5:29 am
Assuming you changed the compatibility setting on your database so that it's now at 120, you're using the new cardinality estimator that comes with SQL Server 2014.
Queries that were marginal...
"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
September 2, 2015 at 5:26 am
sunnyepgc (9/2/2015)
"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
September 2, 2015 at 5:22 am
The biggest difference between 2008 & 2014 was the new cardinality estimator. First off, make sure the database compatibility mode is set to 120. If it is, you're using 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
September 1, 2015 at 8:22 pm
Better to use Extended Events, but yeah, both have a recompile event that you can observe.
"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
September 1, 2015 at 12:22 pm
Could be just a timing issue with the log backups. It could be a single large transaction that had to wait for the buffers to clear in order to keep...
"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
September 1, 2015 at 12:08 pm
Yes, it's going to compile based on the parameters you first pass in and whatever is in the temporary tables when the procedure gets compiled.
However, if anything modifies the data...
"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
September 1, 2015 at 11:59 am
DuncEduardo (9/1/2015)
Many thanks for replying. Yes, I had noticed Mike on LinkedIn already but was unable to mail with the account level I currently have; I'd have to upgrade.
Basically,...
"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
September 1, 2015 at 9:16 am
He was just presenting at SQL Saturday Oklahoma City this last weekend. We're acquainted, but I don't have a direct contact for him. Here's his LinkedIn page. You should be...
"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
September 1, 2015 at 6:55 am
Whisper9999 (8/31/2015)
Grant Fritchey (8/31/2015)
If, as a DBA, you see your job around setting up servers,...
"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
September 1, 2015 at 6:27 am
ZZartin (8/31/2015)
"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
September 1, 2015 at 6:25 am
That's one of those questions where you have to ask, how do you define your job?
If, as a DBA, you see your job around setting up servers, handling security, 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 31, 2015 at 4:46 pm
Viewing 15 posts - 5,611 through 5,625 (of 22,219 total)