I'm working to plan a new upgrade to our existing data warehouse infrastructure. We're looking at local redundancy options and figure that a traditional FCI will be better than an AG due to the large data sizes we are working with and our San admin's discouragement to doubling our storage costs.
At the same time, this will be a SQL 2019 Enterprise Environment and we're looking at Optane NVME disks or NVDIMMS to help provide performance improvements while loading data to this environment.
Besides using the NVME disks for TempDB, is it possible to use local DAX formatted devices for Hybrid Buffer Pool or Persistent Log Buffers along with a traditional Windows Server Failover cluster?
Has anyone used these? Can they can be used with a FCI, I can't find anything documented one way or another? My gut feeling is no, because they are local resources, but maybe?
To help us help you read this[/url]For better help with performance problems please read this[/url]