Date: Sun, 7 Oct 2018 14:46:55 -0400 From: Allan Jude <allanjude@freebsd.org> To: freebsd-virtualization@freebsd.org Subject: Re: bhyve performance problem with SQL server Message-ID: <31782859-a38f-4960-f112-563aa9c378c3@freebsd.org> In-Reply-To: <e0a60d18-2902-df28-ec94-9a630824eebf@netfence.it> References: <e0a60d18-2902-df28-ec94-9a630824eebf@netfence.it>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --cQ6Bg5sx7ZPt6HWqzCgxqCaWNUdKh6XCt Content-Type: multipart/mixed; boundary="uIn32O1qTnhrm9SaSElZPZHHFzrsyGlHk"; protected-headers="v1" From: Allan Jude <allanjude@freebsd.org> To: freebsd-virtualization@freebsd.org Message-ID: <31782859-a38f-4960-f112-563aa9c378c3@freebsd.org> Subject: Re: bhyve performance problem with SQL server References: <e0a60d18-2902-df28-ec94-9a630824eebf@netfence.it> In-Reply-To: <e0a60d18-2902-df28-ec94-9a630824eebf@netfence.it> --uIn32O1qTnhrm9SaSElZPZHHFzrsyGlHk Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 2018-10-07 11:31, Andrea Venturoli wrote: > Hello. >=20 > I've got a FreeBSD 11.2 box running vm-bhyve with two Windows virtual > machines, each with an instance of MS SQL server. >=20 > Everything works fine normally, but there's a specific operation which > will impose an high CPU load on the machine and last several minutes, > when it's expected to get the results in a few seconds. >=20 > I think I have to pass this trouble to the "programming" people, but > before I do that, I'd like to double-check this is not a system problem= =2E >=20 >=20 >=20 > Some notes: >=20 > _ that specific operation will put the two VMs in touch with each other= , > as one will contact the DBMS on the other and import data; however, > that's not the only procedure which does such a thing and the others ar= e > working fine; >=20 > _ during the execution of such procedure, the load on the host rises, a= s > both VMs show high CPU usage (in Task Manager), top shows both bhyve > processes in kqread (but this happens all the time), disk activity > doesn't seem so high; >=20 > _ the box has a Quad-Core CPU and I assigned two cores to each VM (I > have hw.vmm.topology.cores_per_package=3D4 in /boot/loader.conf); >=20 > _ both VMs use virtio-net, with both tap interfaces connected to the > same "virtual switch"; >=20 > _ both VMs use a zvol for their HD. >=20 >=20 >=20 > Before I sentence this is an application level problem, is there some > improvment I could do to the above? Any check or test I should run? >=20 >=20 > =C2=A0bye & Thanks > =C2=A0=C2=A0=C2=A0=C2=A0av. > _______________________________________________ > freebsd-virtualization@freebsd.org mailing list > https://lists.freebsd.org/mailman/listinfo/freebsd-virtualization > To unsubscribe, send any mail to > "freebsd-virtualization-unsubscribe@freebsd.org" What is the 'volblocksize' of your zvol? What block size are you using for the bhyve virtual device? is it virtio-blk or ahci? Can you tell if the problem is related to disk IO? --=20 Allan Jude --uIn32O1qTnhrm9SaSElZPZHHFzrsyGlHk-- --cQ6Bg5sx7ZPt6HWqzCgxqCaWNUdKh6XCt Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (MingW32) iQIcBAEBAgAGBQJbulSfAAoJEBmVNT4SmAt+14YP/jBJSOa9kngAVX46W0dPYIta rGUBRpst2IGwTbgo9X3OULFv2TwHxOoh2r1ki4k/Fm5WDG6EEaVesnA9ghHnXvGz A36LtUociyEiTrvgfm+exSiMpMI2nYJoYJkY+Fr0rYiNn9qCg7nFQ0ylK7wgKiuI tVhsCqAFoE5EDtW+6MEiwR/MiXqzgwAcdi+7OmNf0g3MiBeStFbTZej1+B/3HeQq bPysWmvSFvPALfs3UdZ8RknW3wgyOl0z76yHu4Mt2ZEdd+mtKyR9NF6evn8lz3CP HVXt8LEN6AwdqmGZKDMt3fBn6gDniKHvCLolq8JVFBtpb3u4TPYuAEczQhpJnZ6p 1MFxekS2XY1osUUS6rEo7XKN/Nq8BpkcK1qDT3bfgXcy9NUh9uce95SBeNZ64bbn JX6eYczCxIDCMGp5orrwEROKvWWEX4FupGdDSTkXJ+qSR/4IRf+KGpbOnS9tMvXq VItWFUuQIQs/WcAKQlxlrHuvE4pMuM192teBPDCAYyF6vWcCMvW9uyPcaJSlAF28 IGAjpMMLt1Jb5GgNUlgd/nZ7HztBpHDlRijnOVjlU7m6tQ56EgawtVN6WSCqtVS7 heODZNQ2L2Lg+8UIrTtCrbmVFF7yW7usCXGPhVQEYXN4Mv5zuzAn/mdbVaySasKp +zyoqaH01swVw2LDk/Kg =9qIM -----END PGP SIGNATURE----- --cQ6Bg5sx7ZPt6HWqzCgxqCaWNUdKh6XCt--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?31782859-a38f-4960-f112-563aa9c378c3>