Categories
Mastering Development System & Network

iotune qemu/KVM total_iops total_bytes limits

I have created some qemu/KVM virtual machines on SSDs. The host has ~6 SSDs. 1 is being used for the OS, and each of the other SSDs has two VM guests. I’m using iotune to limit the capabilities of these drives: <disk type=’file’ device=’disk’> <driver name=’qemu’ type=’raw’ cache=’writeback’ io=’threads’/> <source file=’/var/lib/libvirt/images/sdd/pz/heavy/virtual-machine-1/os.img’ aio=”/> <target dev=’vda’ bus=’virtio’/> […]

Categories
Mastering Development

Issue with memory optimized tables transaction commit dependencies

I’m working with SQL Server 2016, and working on large group of sprocs that are all called by one parent sproc. All the sprocs do nothing but reads to return one result set. I’ve confirmed all necessary objects are in cache and no physical reads are happening. All reads are done on indexes with no […]