Viewing 15 posts - 1,561 through 1,575 (of 22,232 total)
Oh, and if you have specific questions for follow up, don't hesitate to open another thread if necessary. More people will see the question that way. However, as much as...
"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 28, 2020 at 1:42 pm
Hello, and welcome to the party!
There's a lot to unpack there, but I'll try to help a little. These are the questions I spotted.
At this...
"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 28, 2020 at 1:38 pm
Also, you do not need a backup strategy. You need a restore strategy.
MY HERO!!!!
"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 27, 2020 at 8:34 pm
Thanks.
If a 3rd party tool takes db backups(full,diff,log) will that information be captured inside sql tables ?
Yes, as long as they're actually taking SQL Server backups. There are some...
"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 27, 2020 at 8:34 pm
Thank you Grant, and all, for your advises.
What I also heard is that we need to collect a database workload from production and apply it on our testing environment...
"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 27, 2020 at 3:04 pm
I know it's not free, but it's good. I'd strongly suggest you be ready to invest in your own career and skills. Books are a pretty minor investment in the...
"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 27, 2020 at 12:32 pm
Testing, testing, testing, then test some more.
One thing many people don't know about when upgrading SQL Server using the modern versions (2016+), is Query Store. This is a major tool...
"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 27, 2020 at 12:28 pm
You can look at the backup tables in MSDB, backupset. There's a lot of information there on the type of backup, when it occurred, if it was successful, etc....
"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 27, 2020 at 12:22 pm
Good to hear Lynn. I mean the job thing. Of course I also get excited about selling Redgate software too.
"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 26, 2020 at 12:24 pm
Makes sense.
"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 26, 2020 at 12:18 pm
Yeow!
That's like all the problems.
When I consult on this stuff, the one strong recommendation I make is to get champions at multiple levels on multiple teams. If there are people...
"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 25, 2020 at 6:42 pm
You have to look to multiple metrics. The plan is one, certainly, but after that you look to I/O, CPU, memory, blocked processes, waits.
"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 23, 2020 at 2:47 pm
It would be easier to give a complete answer with the Profiler events and filter. However, on a guess, the process id changed? They're not always the same. If 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
October 23, 2020 at 1:33 pm
Nah, the plan can be the same for lots of different executions. If it doesn't recompile, regardless of parameters passed, you'll see the same plan used over & over. It'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
October 23, 2020 at 1:29 pm
So, a hardware change and then behavior changed? When you say right before, you mean several days, several hours, or they pretty much coincide?
"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 21, 2020 at 9:42 pm
Viewing 15 posts - 1,561 through 1,575 (of 22,232 total)