Posts in Hardware

AWS really does make the Pain of Purchasing Servers go away

I have thought a lot about how I used to provision traditional IT resources, and how differently I would provision Amazon Web Services resources in the cloud today. Maybe you can benefit from my perspective, based on experience, that keeps it plain and simple.

In the past, I had to think about how much hardware and software I could buy with a given budget. I would over-engineer the architecture, since I would have to live with it for several years. It was better to be safe with more than I could use, than be sorry trying to explain why the money already spent wasn’t enough. Building a whole test system up front to prove it would work would also increase costs, Read More

Partition Alignment in a Windows-Based Environment Using the DiskPart Utility

Alignment of disk partitions can have a huge performance impact, particularly for database servers. Incorrect alignment from an out-of-the-box installation could tax a system’s I/O performance as much as 35%, depending on the type of activity (1). Partitioning, and therefore partition alignment, is one of the first things to happen when a server is being built. A mistake in that early step can negatively affect the performance of the I/O subsystem for the life of a production database server. And yet it was not long ago that it seemed nobody in the DBA community had ever heard of partition alignment.

Keep reading…

We're Here To Help.

Database problem? Tell us a little bit about it.

Name*

Email*

Subject

Message*

captcha

* Required