Viewing 15 posts - 2,401 through 2,415 (of 22,219 total)
This sounds like a reasonable approach to me. After the archive you might want to shrink the databases a little. I'd also suggest setting up an automated process to continue...
"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
August 22, 2019 at 11:19 am
What Jeff said.
Plus, spend as much time learning and practicing your people skills as you do your technical skills. You'll be much more successful if you can communicate well.
"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
August 22, 2019 at 9:07 am
It's been good. We're still waiting for our baby girl to decide to be born. She's taking her time. (Yesterday was the "due date")
I'm assuming by now...
"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
August 22, 2019 at 9:04 am
So, we're talking at cross purposes here.
Results to text put the results out as text in the results window. They don't go to any file anywhere. They're just text instead...
"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
August 21, 2019 at 12:34 pm
It's not about fragmentation. It's about the delta store, the place where the deletes are kept. You want to watch that and rebuild based on clearing that up, not fragmentation.
"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
August 21, 2019 at 12:32 pm
You may need to set up a linked server on the Azure VM. Use synonyms to dummy out the behavior.
"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
August 21, 2019 at 12:30 pm
Restores.
Restores matter more than backups. No one cares how good your backups are. They care whether or not you can restore the database. Learn to do restores in your sleep....
"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
August 21, 2019 at 12:24 pm
This seems a little harsh. I would assume there was more to the story. For example, this is the 14th time this person has opened an email and let loose...
"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
August 20, 2019 at 12:28 pm
And yet another week of dealing with the "anti-virus" virus...
Sheesh. Not only did we have to deal with systems being sluggish this week still, we had to deal 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
August 16, 2019 at 12:10 am
Check your cost threshold for parallelism. 5 is the default and it's too low.
I'd still strongly recommend doing what I suggested with query store.
"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
August 15, 2019 at 7:07 pm
Thanks for coming back with what the problem was. So many people never let us know.
You can modify system_health to keep more data, but, from the sounds of it, I...
"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
August 15, 2019 at 7:06 pm
For me, the community of people on SSC makes it worth while to stick with compared to SO and other sites.
Yep.
"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
August 14, 2019 at 3:13 pm
Assuming you're on SP1, or greater, of SQL Server 2016, you can use DATABASE SCOPED CONFIGURATION to change the cardinality estimation engine. You should set LEGACY_CARDINALITY_ESTIMATION to ON.
Again, I...
"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
August 14, 2019 at 12:05 pm
We're on SQL Server 2016, yes?
Don't use Profiler and Trace Events. They are old school. Worse yet, filtering on them is horrible. Even though you apply a filter (only look...
"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
August 14, 2019 at 11:34 am
I'm with everyone else, get back to the old cardinality estimation engine for a short time. Turn on Query Store on your database. Run your load for a bit 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
August 14, 2019 at 11:29 am
Viewing 15 posts - 2,401 through 2,415 (of 22,219 total)