Viewing 15 posts - 4,816 through 4,830 (of 22,224 total)
The only things that immediately jump out are the two DISTINCT operations. That's usually a crutch for either bad data or bad data structures. To really improve performance, I'd address...
"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
April 18, 2016 at 12:00 pm
And here's a quicker read, an article on getting started with backups[/url]. And restores.
"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
April 18, 2016 at 11:03 am
I have to jump on with Jeff & Kevin on this one. By and large one should use the appropriate data types in the appropriate place. Is it a non-issue...
"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
April 18, 2016 at 10:58 am
The primary is going to follow the settings for statistics updates. It won't change because the database is in an Availability Group.
"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
April 18, 2016 at 7:59 am
jeff.mason (4/18/2016)
Grant Fritchey (4/18/2016)
If you do go to use extended events (also my advice on a 2012 forum),...
"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
April 18, 2016 at 7:57 am
I'm with Lowell. I'm only writing the query if I get the grade.
If you're stuck, try writing the query. Show us what you have tried that doesn't work. I'm sure...
"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
April 18, 2016 at 5:32 am
If the log backup is not running (and that's how I read the explanation), then the committed transactions won't be removed from the log and it will continue to grow....
"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
April 18, 2016 at 5:30 am
SSMS doesn't "open" anything as a database. SSMS is just the client that lets you look at what is on the SQL Server instance. It's the instance that manages 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
April 18, 2016 at 5:28 am
Piling on, don't use the Profiler GUI against production systems. It hurts performance.
If you do go to use extended events (also my advice on a 2012 forum), be sure you...
"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
April 18, 2016 at 5:21 am
At a really low level, it's how the storage of the information is maintained. But I'm with Jeff, a better definition of what you're trying to understand, other than just...
"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
April 18, 2016 at 5:17 am
naveen.neerukattu1228 (4/18/2016)
Hi Homebrew01, johnwalker10Thankyou for your help and have little bit confusion around Refresh means Refresh will done with in single instance with multiple databases?
It completely depends on what's...
"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
April 18, 2016 at 5:14 am
Lynn Pettis (4/15/2016)
Sergiy (4/14/2016)
nhansen pcc (4/11/2016)
Have you identified the corruption? has the server team looked at the drives or SAN?
Both our internal SAN team, and the vendor have looked...
"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
April 16, 2016 at 10:58 am
What the heck is this doing in the JOIN criteria:
0 = 1
and pbu.bu_id is not null
I gave up after that. I'm not paid enough.
Instead of NOLOCK on umpti-gazillion tables, why...
"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
April 15, 2016 at 11:12 am
What about the row estimates between the servers. Are they the same? You're getting a different memory grant because the optimizer thinks it's moving different amounts of data (and 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
April 15, 2016 at 9:27 am
Brandie Tarvin (4/15/2016)
Grant Fritchey (4/15/2016)
and, more recently:
How to recover from deleting everything, including the backups
I sincerely hope that this data is not vital to your...
"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
April 15, 2016 at 8:10 am
Viewing 15 posts - 4,816 through 4,830 (of 22,224 total)