What Kind of Disks Should You Use with Microsoft SQL Server 2016? (Part 2)

In our previous post we looked at disk requirements for Microsoft SQL Server 2016 and outlined available disk technologies, including hardware, RAID configurations, and storage devices. In this post we’ll look at: Manufacturer’s disk performance specifications RAID performance specifications Disk Connection Protocols: SATA, SAS and NVMe Estimating Disk Performance Disk key performance indicators (KPIs)

Posted on: 16 August 2017 | 10:30 am

What Kind of Disks Should You Use with Microsoft SQL Server 2016? (Part 1)

In addition to CPU and memory, Microsoft SQL Server 2016 also requires disks that are fast enough to keep up with the IO requests made by the database. Running SQL on disks that cannot keep up with the requisite level of IO results in latency that affects all subsequent operations. In this post, we’ll look at: SQL Server disk requirements Disk Hardware RAID configurations Disk Management: DAS, NAS and SAN

Posted on: 8 August 2017 | 11:36 am

What is Hybrid Cloud

In its most basic form, hybrid cloud is the unification of a private cloud and public cloud deployment such that they operate together seamlessly within an enterprise. The “hybrid” term means the private and public clouds function independently but operate and provide services as a unified IT infrastructure.

Posted on: 1 August 2017 | 10:30 am

How much CPU does Microsoft’s SQL Server 2016 use?

Running Microsoft SQL Server 2016 without enough CPU resources will degrade performance as badly as trying to run SQL Server without enough memory. Determining how much CPU is available for a SQL Server involves:

Posted on: 26 July 2017 | 10:24 am

VMware or Hyper-V? Part 3: Virtualization Licensing Costs

In the last post, we looked at the cost for licensing Microsoft operating systems on virtual machines – and noted that the windows OS licensing costs were the same regardless of the hypervisor used. The cost difference for hypervisors is primarily based on licensing advanced features – so to determine your licensing costs, you need to determine which advanced features are required in your environment.

Posted on: 24 July 2017 | 10:28 am

Choosing between VMware and Hyper-V

Choosing a hypervisor has become an increasingly difficult proposition. The technology you choose may depend less on the technical differences between the hypervisor technologies and more on your strategic direction and the type of IT resources you already have in place.

Posted on: 18 July 2017 | 10:45 am

VMware or Hyper-V? Part 2: VM Operating System Licenses

In our last post we looked at some of the environmental factors that play into a choice between VMware and Hyper-V: required OS support, hardware compatibility, and ease of use. This post and the next will look at what is often the deciding factor in selecting a hypervisor:

Posted on: 17 July 2017 | 5:02 am

How Much Memory Does Microsoft’s SQL Server Need?

Microsoft SQL Server uses memory to improve performance by caching data, and it will use as much memory as it can based on how much it has been allocated. On a physical server, with a fixed amount of memory, that means making an initial estimate of how to divide the limited system memory between SQL, the operating system, and other applications on the server. 

Posted on: 11 July 2017 | 10:30 am

VMware or Hyper-V? Part 1: Which hypervisor will work best for your environment?

If you’ve gone through the comparison of Cloud vs Virtualization, and decided that Virtualization is the best fit for you – you’re still not done. The next step is deciding which hypervisor to use for your virtualization. If a significant portion of your environment is Windows, then your primary choices are VMware or Hyper-V.

Posted on: 10 July 2017 | 10:36 am

Securing and Optimizing the Virtual Network Infrastructure

An efficient and fully functioning VMware infrastructure is dependent on shared virtual resources that include server, network, and storage - but the glue that holds the virtual infrastructure together is virtual network resources.

Posted on: 27 June 2017 | 12:15 pm