Search results

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...

Hi team, The same thing happened to me today after a power failure. The VM said duplicate IP even though only that VM had it, I searched with ARP through the routers / switches and did not detect anything strange. I tried deleting and adding interfaces to the VM but the same thing happened on...

Thanks for the info my friend, i needed it

Yes i put in simple Words, i have several server with zfs raid 1 and suffer with the io delay, thats was the only way i found to solve it

Hi! Limit the RAM for ZFS, always will use 50% of the RAM installed When using ZFS on SSDs without power loss protection, TRIMs must be configured at least once every week, otherwise you will always suffer from very high IO delay. the command is: zpool trim rpool to notify of blocks that are...

Hi @ligistx, Have you tried making a trim to rpool? the command is: zpool trim rpool to notify of blocks that are no longer in use. When using ZFS on SSDs without power loss protection, TRIMs must be configured at least once every week, otherwise you will always suffer from very high IO delay.