Recent content by VDNKH

Everything resides on a ZFS RAID 10

Have you managed to make MSSQL run faster with these changes? I have a server with Micron Enterprise 7450/7500 NVMe drives, but it's slow for database queries and backups. We moved the VM from a server with less hardware to this new one, and backup performance is the same, and a select from a...

Greetings, friend, good evening. Did you find any solution to your ZFS VM's performance?

Instead with this one: fio --name=vm_sql_file_test --filename=ttest_file.img --rw=randrw --bs=8k --iodepth=32 --numjobs=4 --time_based --runtime=300s --group_reporting --eta-newline=5s --direct=1 --ioen gine=libaio --fsync=1 --size=10G I get this resul: Run status group 0 (all jobs): READ...

I used this on my ZFS RAID10: fio --name=multi_write_benchmark --filename=test_write --rw=write --bs=1M --iodepth=32 --numjobs=6 --time_based --runtime=60s --group_reporting --eta-newline=5s --direct=1 --ioengine=libaio --size=40G and the result is: Run status group 0 (all jobs): WRITE...

I did a sequential write test, quite heavy and the speeds are quite high, but I'm worried about the small/random ones.

In what way, do you mean that I do a Windows installation on the physical server?

Hi, it's me again. Dear forum friends, Today I'm here with a question that has me thinking and that I can't seem to make sense of. I have a server with very good hardware specifications. In fact, I posted about it a while ago to see if I should install ZFS in RAID 10 to host my VMs. These are...

Greetings friend, I have been reluctant to use btrfs since at the time I read that it was something experimental, and should not be used in production, it was a long time ago, anyway I will try to update myself on the current status of btrfs

Thank you for your help, it is greatly appreciated.

@santiagobiali Thank you very much my friend, I really appreciate your opinion, I will take it into account.

Thanks You in advance!!!!

Greetings, good evening, fellow forum members. The company I work for is in the process of acquiring a High-Grade dedicated server from OVHCloud. I've previously worked with servers from that provider, but smaller ones from the Advanced range, using Proxmox and installing with the ISO without...

Thanks @_gabriel but this is really sad :s

Hi team Is this issue still active? No response from the parties involved? I am experiencing this bug with Windows Server 2022 and SQL Server 2019. The virtual disk that hosts the databases is the one that suddenly loses access, I also see in the log the records mentioned above. We use the...