Connecting Cloud Innovators: Building Community at .NEXT 2024
[quote=RichardsonPorto]Hi [user=81377]AlPM[/user] One of the main reason to split the data disk in multiple vdisks is really to avoid the OpLog not fill up. For log files, spreading in multiple vdisks will not offer benefits, since the logs are written sequentially and that type of workload will bypass the OpLog. Here are some references: [quote]Remember that, unlike database files, SQL Server log files are accessed or written to in a sequential or “fill and spill” manner. Therefore, spreading TempDB log files across several VMDKs is not advantageous and just makes the solution more complex than necessary. Because contention on log disks is fairly rare, Nutanix recommends a single log file per database unless you have a compelling reason for more.[/quote]Source: https://portal.nutanix.com/#/page/solutions/details?targetId=BP-2015-Microsoft-SQL-Server:top_sql_server_log_files.html [quote]The OpLog is similar to a filesystem journal and is built as a staging area to handle
Couple things here. How are you planning to cluster? Failover clustering is not supported on NFS per Microsoft. Unless I'm reading what you're stating wrong. (Single VM on a two node Nutanix cluster?) How many databases and how busy will they be? My DBA is one of the best of the best Microsoft MVPs so we've gotten some great recommendations from him (Brad McGehee) as well as the Nutanix engineers. He recommends 64k allocation formatting and separate disk for databases. For logs, and temp there's little benefit for seperation. It's not so much about size as it is storage reads/writes that should determine if a database should require it's own VMDK. Most instances where it's a lot of reads but a smaller DB, you can cache most of it in RAM and it's fine. But the more DB's and the busier they are, the better off you are splitting it off. So you're right on the money with planning to do that. AHV would be optimal for this since you can now take advantage of AHVTurbo on windows, regardless
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.