Viewing 15 posts - 2,956 through 2,970 (of 22,224 total)
Indexes, or queries, are not the same between the two databases, so we're comparing apples to hammers. Look at Query 5. In the old plan, it has three index seeks....
"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 20, 2018 at 5:51 am
I'd love to help out, but I really don't want to dig through all 20-30 plans here. Which one am I to focus on?
"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 20, 2018 at 5:44 am
First, and most important, backups and backup testing.
Create a DR plan
Test the DR plan
Monitoring for availability, performance, behavior
Statistics maintenance
Get your databases into source control
Automate...
"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 20, 2018 at 5:39 am
Those should return data. If they're not, it's likely that something is up with sys.dm_os_performance_counters, not your databases or servers. Check all the possibilities Pinal Dave lists.
"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 20, 2018 at 5: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
September 20, 2018 at 4:58 am
I have to agree - this is an awesome Eagle Scout project.
Since they exported...
"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 19, 2018 at 9:17 am
Again, how are you recording them?
"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 19, 2018 at 5:51 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
September 19, 2018 at 5:46 am
Sergiy - Tuesday, September 18, 2018 6:17 PMI understand why you used geospatial data for mapping.
I don't understand - why Azure?
Multiple...
"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 19, 2018 at 5:44 am
How are you measuring the Buffer Cache Hit Ratio on a per database basis? It's a server level metric. It's also pretty useless as a metric. Same thing goes for...
"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 19, 2018 at 4:37 am
Another vote for the T-SQL Recipes book. That one is pretty cool.
"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 19, 2018 at 4:31 am
I would not do it because of the consistency issues in the backup scripts. However, should work perfectly fine when go to restore.
"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 18, 2018 at 12:26 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
September 18, 2018 at 9:36 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
September 18, 2018 at 7:12 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
September 18, 2018 at 6:04 am
Viewing 15 posts - 2,956 through 2,970 (of 22,224 total)