From owner-freebsd-virtualization@freebsd.org Sun Oct 7 18:46:57 2018 Return-Path: Delivered-To: freebsd-virtualization@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 131AF10C9567 for ; Sun, 7 Oct 2018 18:46:57 +0000 (UTC) (envelope-from allanjude@freebsd.org) Received: from mx1.scaleengine.net (mx1.scaleengine.net [209.51.186.6]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 8375F8F65F for ; Sun, 7 Oct 2018 18:46:56 +0000 (UTC) (envelope-from allanjude@freebsd.org) Received: from [10.1.1.2] (Seawolf.HML3.ScaleEngine.net [209.51.186.28]) (Authenticated sender: allanjude.freebsd@scaleengine.com) by mx1.scaleengine.net (Postfix) with ESMTPSA id DF7221B058 for ; Sun, 7 Oct 2018 18:46:55 +0000 (UTC) Subject: Re: bhyve performance problem with SQL server To: freebsd-virtualization@freebsd.org References: From: Allan Jude Openpgp: preference=signencrypt Autocrypt: addr=allanjude@freebsd.org; prefer-encrypt=mutual; keydata= xsFNBFVwZcYBEADwrZDH0xe0ZVjc9ORCc6PcBLwS/RTXA6NkvpD6ea02pZ8lPOVgteuuugFc D34LdDbiWr+479vfrKBh+Y38GL0oZ0/13j10tIlDMHSa5BU0y6ACtnhupFvVlQ57+XaJAb/q 7qkfSiuxVwQ3FY3PL3cl1RrIP5eGHLA9hu4eVbu+FOX/q/XVKz49HaeIaxzo2Q54572VzIo6 C28McX9m65UL5fXMUGJDDLCItLmehZlHsQQ+uBxvODLFpVV2lUgDR/0rDa0B9zHZX8jY8qQ7 ZdCSy7CwClXI054CkXZCaBzgxYh/CotdI8ezmaw7NLs5vWNTxaDEFXaFMQtMVhvqQBpHkfOD 7rjjOmFw00nJL4FuPE5Yut0CPyx8vLjVmNJSt/Y8WxxmhutsqJYFgYfWl/vaWkrFLur/Zcmz IklwLw35HLsCZytCN5A3rGKdRbQjD6QPXOTJu0JPrJF6t2xFkWAT7oxnSV0ELhl2g+JfMMz2 Z1PDmS3NRnyEdqEm7NoRGXJJ7bgxDbN+9SXTyOletqGNXj/bSrBvhvZ0RQrzdHAPwQUfVSU2 qBhQEi2apSZstgVNMan0GUPqCdbE2zpysg+zT7Yhvf9EUQbzPL4LpdK1llT9fZbrdMzEXvEF oSvwJFdV3sqKmZc7b+E3PuxK6GTsKqaukd/3Cj8aLHG1T1im1QARAQABzSJBbGxhbiBKdWRl IDxhbGxhbmp1ZGVAZnJlZWJzZC5vcmc+wsF/BBMBAgApBQJVcGXGAhsjBQkSzAMABwsJCAcD AgEGFQgCCQoLBBYCAwECHgECF4AACgkQGZU1PhKYC34Muw/+JOKpSfhhysWFYiRXynGRDe07 Z6pVsn7DzrPUMRNZfHu8Uujmmy3p2nx9FelIY9yjd2UKHhug+whM54MiIFs90eCRVa4XEsPR 4FFAm0DAWrrb7qhZFcE/GhHdRWpZ341WAElWf6Puj2devtRjfYbikvj5+1V1QmDbju7cEw5D mEET44pTuD2VMRJpu2yZZzkM0i+wKFuPxlhqreufA1VNkZXI/rIfkYWK+nkXd9Efw3YdCyCQ zUgTUCb88ttSqcyhik/li1CDbXBpkzDCKI6I/8fAb7jjOC9LAtrZJrdgONywcVFoyK9ZN7EN AVA+xvYCmuYhR/3zHWH1g4hAm1v1+gIsufhajhfo8/wY1SetlzPaYkSkVQLqD8T6zZyhf+AN bC7ci44UsiKGAplB3phAXrtSPUEqM86kbnHg3fSx37kWKUiYNOnx4AC2VXvEiKsOBlpyt3dw WQbOtOYM+vkfbBwDtoGOOPYAKxc4LOIt9r+J8aD+gTooi9Eo5tvphATf9WkCpl9+aaGbSixB tUpvQMRnSMqTqq4Z7DeiG6VMRQIjsXDSLJEUqcfhnLFo0Ko/RiaHd5xyAQ4DhQ9QpkyQjjNf /3f/dYG7JAtoD30txaQ5V8uHrz210/77DRRX+HJjEj6xCxWUGvQgvEZf5XXyxeePvqZ+zQyT DX61bYw6w6bOwU0EVXBlxgEQAMy7YVnCCLN4oAOBVLZ5nUbVPvpUhsdA94/0/P+uqCIh28Cz ar56OCX0X19N/nAWecxL4H32zFbIRyDB2V/MEh4p9Qvyu/j4i1r3Ex5GhOT2hnit43Ng46z5 29Es4TijrHJP4/l/rB2VOqMKBS7Cq8zk1cWqaI9XZ59imxDNjtLLPPM+zQ1yE3OAMb475QwN UgWxTMw8rkA7CEaqeIn4sqpTSD5C7kT1Bh26+rbgJDZ77D6Uv1LaCZZOaW52okW3bFbdozV8 yM2u+xz2Qs8bHz67p+s+BlygryiOyYytpkiK6Iy4N7FTolyj5EIwCuqzfk0SaRHeOKX2ZRjC qatkgoD/t13PNT38V9tw3qZVOJDS0W6WM8VSg+F+bkM9LgJ8CmKV+Hj0k3pfGfYPOZJ/v18i +SmZmL/Uw2RghnwDWGAsPCKu4uZR777iw7n9Io6Vfxndw2dcS0e9klvFYoaGS6H2F13Asygr WBzFNGFQscN4mUW+ZYBzpTOcHkdT7w8WS55BmXYLna+dYer9/HaAuUrONjujukN4SPS1fMJ2 /CS/idAUKyyVVX5vozoNK2JVC1h1zUAVsdnmhEzNPsvBoqcVNfyqBFROEVLIPwq+lQMGNVjH ekLTKRWf59MEhUC2ztjSKkGmwdg73d6xSXMuq45EgIJV2wPvOgWQonoHH/kxABEBAAHCwWUE GAECAA8FAlVwZcYCGwwFCRLMAwAACgkQGZU1PhKYC34w5A//YViBtZyDV5O+SJT9FFO3lb9x Zdxf0trA3ooCt7gdBkdnBM6T5EmjgVZ3KYYyFfwXZVkteuCCycMF/zVw5eE9FL1+zz9gg663 nY9q2F77TZTKXVWOLlOV2bY+xaK94U4ytogOGhh9b4UnQ/Ct3+6aviCF78Go608BXbmF/GVT 7uhddemk7ItxM1gE5Hscx3saxGKlayaOsdPKeGTVJCDEtHDuOc7/+jGh5Zxpk/Hpi+DUt1ot 8e6hPYLIQa4uVx4f1xxxV858PQ7QysSLr9pTV7FAQ18JclCaMc7JWIa3homZQL/MNKOfST0S 2e+msuRwQo7AnnfFKBUtb02KwpA4GhWryhkjUh/kbVc1wmGxaU3DgXYQ5GV5+Zf4kk/wqr/7 KG0dkTz6NLCVLyDlmAzuFhf66DJ3zzz4yIo3pbDYi3HB/BwJXVSKB3Ko0oUo+6/qMrOIS02L s++QE/z7K12CCcs7WwOjfCYHK7VtE0Sr/PfybBdTbuDncOuAyAIeIKxdI2nmQHzl035hhvQX s4CSghsP319jAOQiIolCeSbTMD4QWMK8RL/Pe1FI1jC3Nw9s+jq8Dudtbcj2UwAP/STUEbJ9 5rznzuuhPjE0e++EU/RpWmcaIMK/z1zZDMN+ce2v1qzgV936ZhJ3iaVzyqbEE81gDxg3P+IM kiYh4ZtPB4Q= Message-ID: <31782859-a38f-4960-f112-563aa9c378c3@freebsd.org> Date: Sun, 7 Oct 2018 14:46:55 -0400 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="cQ6Bg5sx7ZPt6HWqzCgxqCaWNUdKh6XCt" X-BeenThere: freebsd-virtualization@freebsd.org X-Mailman-Version: 2.1.27 Precedence: list List-Id: "Discussion of various virtualization techniques FreeBSD supports." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 07 Oct 2018 18:46:57 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --cQ6Bg5sx7ZPt6HWqzCgxqCaWNUdKh6XCt Content-Type: multipart/mixed; boundary="uIn32O1qTnhrm9SaSElZPZHHFzrsyGlHk"; protected-headers="v1" From: Allan Jude To: freebsd-virtualization@freebsd.org Message-ID: <31782859-a38f-4960-f112-563aa9c378c3@freebsd.org> Subject: Re: bhyve performance problem with SQL server References: In-Reply-To: --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--