Timeline for How is ‘tempdb’ getting used when Always On Failover happens?
Current License: CC BY-SA 4.0
4 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
May 12, 2022 at 1:10 | comment | added | PeterX | @TheoEkelmans I was confused by your article as MS says SQL Server failover cluster installation supports Local Disk only for installing the tempdb files. As you say, a proper RAID setup with monitoring is important. | |
Feb 8, 2021 at 14:18 | comment | added | Theo Ekelmans | I all fairness, its an important piece of the puzzle that blindsided me and my colleague, and it is meant as a supporting/additive statement on Tara's answer. But I now see I could have been more clear about my intention. Therefor I still think it was an appropriate post | |
Jan 5, 2021 at 21:48 | comment | added | LowlyDBA - John M | I think this qualifies more as an interesting comment than an answer - the asker specifically wanted to know TempDB behavior after a failover, but you're talking about a scenario where a failover does not even occur (automatically, at least). | |
Jan 5, 2021 at 12:09 | history | answered | Theo Ekelmans | CC BY-SA 4.0 |