Viewing 15 posts - 766 through 780 (of 22,227 total)
Extended Events are your bestest friend. Specifically, in addition to the normal query captures of rpc_completed and sql_batch_completed, you can look at ole_db_data_reader to see remote queries specifically.
"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
October 13, 2022 at 2:34 pm
My answer to this is always the same. What are the Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) of the organization? With those defined, can you prove 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
October 13, 2022 at 2:30 pm
No arguments 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
October 10, 2022 at 4:13 am
I've seen the SQL Edge in action. It's just SQL Server under the covers. That's your single best bet. Just backing up @Ant-Green.
"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
October 7, 2022 at 2:09 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
October 6, 2022 at 1:01 pm
Have you looked for disc corruption? It honestly looks like things are messed up at a low level.
"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
October 6, 2022 at 12:58 pm
Microsoft's recommendations are pretty good, and, I think, based on Jonathan Kehayias' guidance.
"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
October 5, 2022 at 2:27 pm
I also suggest you start using <> rather than != for 'not equal to'. <> is a more widely accepted SQL standard than !=, as far as I know.
Optimizer...
"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
October 5, 2022 at 12:56 pm
Just so we're clear, CTFP = Cost Threshold for Parallelism.
And I agree. Changing it from the default value is a must. In addition to picking an arbitrary value (common practice...
"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
October 5, 2022 at 12:55 pm
I'll be there!!
"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 30, 2022 at 1:48 pm
I think that's how you have to do it there too. You can't simply upgrade the VM in place. It just doesn't work like that. Once you have a VM,...
"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 29, 2022 at 3:08 pm
If you're willing to do an in-place upgrade, it's really simple. Get the media for the Standard (or any other) edition on to the VM (how you do that is...
"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 29, 2022 at 12:54 pm
The principal use case would be extensive, many-to-many data structures. If you don't have that, you don't need to sweat it.
"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 26, 2022 at 12:13 pm
Sounds good then. As I said, a long time ago, if the tool can meet the RPO & RTO, I'm fine with it.
"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 23, 2022 at 12:19 pm
I know this is an old topic but we are using Cohesity 6.6. It now has SQL log backup and Point in time restores. So far I'm liking...
"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 23, 2022 at 8:51 am
Viewing 15 posts - 766 through 780 (of 22,227 total)