Meet my latest toy, a 1991 Honda Beat! I introduce it, then take your top-voted questions from https://pollgab.com/room/brento.
Here’s what we covered:
00:00 Start 02:17 Pro: Are sessions sleeping during transactions harmful, and do they prevent the transaction log from truncating? If so, how can’t I prevent them server-side? 03:35 sqlknitter: We have high IO (pageiolatch_sh) causing performance sluggishness. Trying to check index fragmentation, and the query just runs. The GUI freezes. Is this potentially indicative of a highly fragmented index? 04:39 We Don’t Do Corruption Checks!: I don’t trust my SAN Admin. How can I