From owner-freebsd-virtualization@freebsd.org Wed Oct 26 09:30:32 2016 Return-Path: Delivered-To: freebsd-virtualization@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id B8D90C1FEF6 for ; Wed, 26 Oct 2016 09:30:32 +0000 (UTC) (envelope-from matt.churchyard@userve.net) Received: from smtp-outbound.userve.net (smtp-outbound.userve.net [217.196.1.22]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "*.userve.net", Issuer "Go Daddy Secure Certificate Authority - G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 6D215BE8; Wed, 26 Oct 2016 09:30:31 +0000 (UTC) (envelope-from matt.churchyard@userve.net) Received: from owa.usd-group.com (owa.usd-group.com [217.196.1.2]) by smtp-outbound.userve.net (8.15.1/8.15.1) with ESMTPS id u9Q9UCTU018103 (version=TLSv1 cipher=ECDHE-RSA-AES256-SHA bits=256 verify=FAIL); Wed, 26 Oct 2016 10:30:16 +0100 (BST) (envelope-from matt.churchyard@userve.net) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=userve.net; s=201508; t=1477474216; bh=XtuR75OgwT39ZW4X8yEDcAE542v4//2gwnrV+bna+ck=; h=From:To:CC:Subject:Date:References:In-Reply-To; b=iXxfmpQGXaiNll+w1+llaMcMTxeeP5vcOGheeql7s3EA44p1rS4L+vP92szRhJyik 5y0Gx/z0Vw7ENlW/wkYjb0Y+TnoEFwMJtSEsfhFc2oQQ39SF4HZXGmOZ9HcPsnpW+1 PrADeS6b4jZKQjJ1V0QzzFr1UWq6tp1MDWkFLynQ= Received: from SERVER.ad.usd-group.com (192.168.0.1) by SERVER.ad.usd-group.com (192.168.0.1) with Microsoft SMTP Server (TLS) id 15.0.847.32; Wed, 26 Oct 2016 10:30:06 +0100 Received: from SERVER.ad.usd-group.com ([fe80::b19d:892a:6fc7:1c9]) by SERVER.ad.usd-group.com ([fe80::b19d:892a:6fc7:1c9%12]) with mapi id 15.00.0847.030; Wed, 26 Oct 2016 10:30:06 +0100 From: Matt Churchyard To: Peter Grehan , Randy Terbush CC: "freebsd-virtualization@freebsd.org" Subject: RE: Installing SQL Server on Windows 2012 bhyve guests Thread-Topic: Installing SQL Server on Windows 2012 bhyve guests Thread-Index: AQHSLtOHTMln+NzeWUSXyg6lsNDRyKC5ahiAgAEMYbA= Date: Wed, 26 Oct 2016 09:30:05 +0000 Message-ID: <4febd210b57742b780eefc0132709be2@SERVER.ad.usd-group.com> References: <212f161a-d2d1-d164-3910-eeb256ae68ec@freebsd.org> In-Reply-To: <212f161a-d2d1-d164-3910-eeb256ae68ec@freebsd.org> Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.0.10] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-BeenThere: freebsd-virtualization@freebsd.org X-Mailman-Version: 2.1.23 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: Wed, 26 Oct 2016 09:30:32 -0000 -----Original Message----- From: owner-freebsd-virtualization@freebsd.org [mailto:owner-freebsd-virtua= lization@freebsd.org] On Behalf Of Peter Grehan Sent: 25 October 2016 19:19 To: Randy Terbush Cc: freebsd-virtualization@freebsd.org Subject: Re: Installing SQL Server on Windows 2012 bhyve guests >Hi Randy, > I've followed the info provided here=20 > https://wiki.freebsd.org/bhyve/Windows > to create a Windows Server 2012 image that I successfully installed on=20 > the bhyve hypervisor. After getting a working Win2012 image running,=20 > applying updates, etc. I attempted to install SQL Server 2014. In the=20 > late stages of that install, the process attempts to start the SQL server= engine and fails. > There have been some reports of this previously. What might be happening= is that SQL Server has stricter requirements on the underlying block >size= than NTFS itself has. > Since you are using a file-backed image, the reported block size from th= e emulated storage controller may be 8KB or even higher, depending on >the = underlying filesystem type. > A suggestion is to force the block size to 4KB (has to be done during in= stall as well), and if the problem persists, try 512 bytes. This is done by= using >the 'sectorsize=3D' parameter to the disk configuration e.g. > -s 4,ahci-hd,/path/to/disk.img,sectorsize=3D4096 Just to add, if you're using vm-bhyve you should be able to add this with t= he diskX_opts template/config option disk0_opts=3D"sectorsize=3D4096" I may adjust the sample templates to include a sectorsize option for Window= s guests, although I'm not 100% clear on what exact OS versions or applicat= ions require specific settings. I do know that SQL Server has been reported= to suddenly fall over unless a valid block size is used (although I believ= e it did install and run), but again I'm not sure exactly what the "correct= " settings are. Also note that you shouldn't need any grub_* template options if you're usi= ng UEFI. Those options only apply to grub-bhyve. Matt >later, >Peter.