Viewing 15 posts - 2,941 through 2,955 (of 22,219 total)
"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 27, 2018 at 8:51 am
I can't explain the differences in the statistics (and I've reached out to some people to see if someone can). However, I can explain performance hits on failover. You're going...
"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 27, 2018 at 6:57 am
You can define it that way if you want. I would not agree that these are universal definitions. In fact, I don't see that differentiation really. I do see 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
September 27, 2018 at 6:49 am
Also, please, a join, or even 3 or 7 or 20, is not some OMG HAIR ON FIRE performance issue. It's not. In fact, relational storage engines are very good...
"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 27, 2018 at 6:38 am
It sure looks like additional processing is occurring. See the VM processor going up at exactly the same point as your memory issues start. You also see that earlier with...
"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 27, 2018 at 6:30 am
I'd say the only surprise there is that you can increase the size without rebuilding the index. Thinking about it though, it makes sense. We're only affecting future values 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
September 25, 2018 at 4:51 am
And there it is. Azure Data Platform. It's really cool. I've done a quick unboxing here.
"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 24, 2018 at 12:45 pm
SQL Server 2019 was not the only announcement coming out today. Keep watching. Cool stuff ahead.
"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 24, 2018 at 9:12 am
Nope. You can't pause Azure SQL Database. You can with the Warehouse, but not the database.
Best approach, script all the creates and then run them when you're ready...
"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 6: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
September 20, 2018 at 6:01 am
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
Viewing 15 posts - 2,941 through 2,955 (of 22,219 total)