Season 2 · Episode 105
Episode 105 When is enough, enough?
SQL Data Partners Podcast · Carlos L Chacon
July 19, 201743m 23s
Audio is streamed directly from the publisher (traffic.libsyn.com) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
How can you tell when a change is enough of a change? How do you know you didn't make too big of a change? Steve and I discuss some thoughts around what you might look for when you make certain changes. Some of the components we cover include Max degree of parallelism, cxpackets, virtual log files, the number of log files for a database, backup retention and memory.
The shownotes for today's episode is found at http://sqldatapartners.com/2017/07/18/enough/ and have fun on the SQL trail.