New answers tagged clustering
1
vote
Is there any practice to align file system block size with database block size?
Is there a common practice to align the database block size with the file system block size for OLTP?
Not really, no. The best filesystem block size will depend on too many other factors such as the ...
- 35.5k
3
votes
Accepted
Restarting SQL service on primary causes failover of AG to secondary even when the setting says that it must try a reboot prior to failover
We don't mess with these settings in an AG. An AG sits on top of WSFC but is not bound by every setting. SQL manages the AG by AG rules baked into the software. MS even recommends not to mess with ...
0
votes
Cassandra Backups questions
attach a local Disk and copy or snapshot the data onto this Disk
That should work fine.
What is your replication factor (RF)? If you're running with RF==2 on 2 nodes, then they should each have ...
- 4,280
Top 50 recent answers are included