Viewing 15 posts - 3,346 through 3,360 (of 22,219 total)
Some of the magic phrases you want to use when talking to the business about something like this (and it is absolutely a business question, not a technical one) 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
January 23, 2018 at 5:26 am
You've pretty much described standard behavior for PLE. It's one of the reasons why it's not a great measure for performance. I'd focus on other counters, especially wait statistics 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 22, 2018 at 5:04 am
Without seeing the wait statistics on the server, blocked process reports, etc., it's hard to say for certain why one is behaving differently than the other. It's pretty likely that...
"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 22, 2018 at 5:03 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 19, 2018 at 1:07 pm
Don't do it.
Upgrading to SQL Server 2014 means making the leap to the new cardinality estimation engine (a very good thing, most of the time). If you hit...
"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 19, 2018 at 12:56 pm
"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 19, 2018 at 9:32 am
Hah! I'll offer an opinion on both books, since they're in front of me...
"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 19, 2018 at 7:05 am
Hi John I have ran db tuning advisor it has recommended 21 indexes to...
"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 19, 2018 at 5:10 am
What you've posted is not a normal result of a standard upgrade. Something is seriously hosed on the system. It could be the SQL Server install itself. It could 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
January 18, 2018 at 6:02 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 18, 2018 at 6:00 am
Hello Grant,
Thanks for your inputs. The max_update_date will not be changed in both 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
January 17, 2018 at 10:34 am
is there a chance that you have row-level security in place? Then the process that is running the automation has different permissions from your login, hence different results? Just trying...
"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, 2018 at 10:27 am
Are there blocked processes on the machine? You may be waiting on something else entirely. Also, how long was it running before you rolled it back? I've seen the rollback...
"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, 2018 at 5:59 am
It would almost have to be down to differences in the @max_update_date and how it gets generated inside vs. outside the procedure. Fundamentally, there's nothing all that special about 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 17, 2018 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
January 16, 2018 at 11:00 am
Viewing 15 posts - 3,346 through 3,360 (of 22,219 total)