Viewing 15 posts - 1,531 through 1,545 (of 22,202 total)
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...
October 28, 2020 at 1:38 pm
Also, you do not need a backup strategy. You need a restore strategy.
MY HERO!!!!
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...
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...
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...
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...
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....
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.
October 26, 2020 at 12:24 pm
Makes sense.
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...
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.
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...
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...
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?
October 21, 2020 at 9:42 pm
We had the experience once where backups slowed down and the problem was a switch going bad. It didn't evidence itself for any other process except our SQL Server backups....
October 21, 2020 at 6:11 pm
Viewing 15 posts - 1,531 through 1,545 (of 22,202 total)