O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuration

In the previous chapter, we learned what clustering is, what are the different types of clustering available, and how they work. We also learned about the different components of SQL Server clusters such as Quorum. We learned how to install Single-instance and Multi-instance SQL Server failover clusters.

In this section, we will learn how to configure SQL Server failover cluster, so that it will give us a boost in performance.

Write caching

If we are using a non-external disk controller with our cluster, we should turn off the write caching as it may hinder performance. This is because data resides in a local disk and there is no guarantee that the data will be available if the disk fails and so there are chances of data loss during ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required