MSSQL Fail to start on newer hardware

Published Date: 2022/03/31 by: DaVieS

MSSQL Fail to start on newer hardware
MSSQL Fail to start on newer hardware

I recently faced with a strange issue with Microsoft Database Server.
I used Bhyve as hypervisor and a Windows as Guest OS, tried to install MSSQL but failed with very "speaky" errors below...


during installation. 


I tried to run it manually and it just exited with fault after saying:
There have been X misaligned log IOs which required falling back to synchronous IO. The current IO is on file xxx. - Thats something... After seeking for answers all I got is just a hint about newer SSDs and try to install another drive as a solution. So every mostly useless forum post get me closer to the conomdrum.

So what is the common thing in a new SSD and Bhyve? Uses 4K Physical Sector sizes by default..
So seems MSSQL will not work on newest hardware which uses 4K. 

In my case I just adjusted the Bhyve settings to ,sectorsize=512 and also added a Sata/Legacy option to BVCP as from 1.8.4-release. For the others, installing into "legacy" drive will make a trick but using VHD disks also could be a solution if you like a dirty way.

P.S: 4K logical sectors are fine if you have 512B physical sectors.

No more words.... 


If you like the article then don't forget to share!

Big Concern: Facebook hack, Google Chrome V8 Hack, Meta Support

Many users experiences that their account leaked through Facebook Advertisement platform.The BOT change their names to Kevin Konkrete Davis and..


We are doing some regular maintenance at 22:00 - 02:00 UTC. Some services might be distrupted at this time. ..

FreeBSD Bhyve Webadmin | BVCP 1.9.8 Just Released

BVCP 1.9.8 features  New protocol to transmit VNC/RFB data as encrypted and compressed.Better, faster and more responsive UI.Colored..

BVCP 1.9.8 Upcoming Features

We received a ton of feedback about our new project, BVCP.So here is a little description what we are working currently. The next release will..

Trackit-PortGuard just released

When implemented well, this software can be considered as two-factor pre-authentication.Therefore this is one of the most secure method to..

2022 annual report

Here we go another year passed away.We very well predicted the importance of energy efficiency. In the year of 2022 we faced a lot of challenges..

A dull attempt to hack into my email from Nigeria.

Seems like this amazing African country has some hacky potential, but so much to learn.The thing why is this attempt worth a blog entry, because..

BVCP 1.9.0 Released Today

A major version update released out today!This update address many requests and improves overall speed and performance. Highlight of this..

Energy Saving

We have been busy since expanding our services worldwide meanwhile in other hand helping reduce CO emission in industrial-scale levels.  We..

All rights reserved 2009 - 2023
Powered by: MVCP 2.0-RC / BVCP / ASPF-MILTER / PHP 7.4 / NGINX / FreeBSD