Category Archives: Clustering

SQL Server 2012 Cluster Install Error : "SQL Server Database Services feature state"

"SQL Server Database Services feature state". This was the Error Message, which I received this morning during building / Installing a SQL Server 2012 cluster. FIX / Resolution / Workaround : Change registry key on active node: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.SQLDEV2012\ConfigurationState] Change all entry values from 2 to 1 Incident happened to me in Detail I [...]

SQL Server Analysis Services Clustering

Does Microsoft SQL Server Analysis Services (SSAS) Supports clustering ? YES, Microsoft SQL Server Analysis Services (SSAS) supports windows clustering. SQL Server Analysis Services is independent service and SSAS resource is not dependent on the SQL Server Database Engine resource. Analysis Services on clustered environments listens on the default port – TCP 2383. Even if [...]

SQL Server 2008 Clustering on Windows 2008 Video

This is the Complete Video Services for SQL Server 2008 Cluster on Windows 2008.In this video series, we will cover What is Clustering Hardware and Software Requirement for Clustering. Installing and Configuring VMWARE for building virtual environment Installing Windows 2008 clustered environment Installing SQL Server Active Passive (Cluster) on Windows 2008 clustered environment Adding a [...]

SQL Server High Availability Questions

Question: How replication set up impacts to application performance ? Answer: No issues with latency. You might see it based on throughput. Never seen replication cause the blocking, but user’s cause it. Question: have you seen issues with an index rebuild causing a delay in the apply? Answer: Yes, you may see an impact Question: [...]

Video : How to Add a Node to an Existing SQL Server 2008 Failover Cluster

This video demonstrates, how to add a node to an existing SQL Server Failover Cluster instance. Note: To view All this Video, Please install Microsoft Silver light Tags : How to Add a Node to an Existing SQL Server 2008 Failover Cluster,how to add a node to an existing SQL Server Failover Cluster instance, how [...]

New Features of SQL Server 2008

Here is the list of top 51 features of SQL Server 2008 which are present in SQL Server 2008 sales Boucher. My objective to cover all new features of SQL Server 2008 with detailed concept delivery with videos. Policy-Based Management Policy-Based Management is a policy-based system for managing one or more instances of SQL Server [...]

SQL Server 2008 – Clustering Enhancements

One new feature with clustering in SQL Server 2008 is the removal of the requirement to have one drive letter for each SQL Server instance. This increases the number of instances that each cluster can support and enables increased server consolidation. Most of the additional enhancements for SQL Server 2008 clustering are only available with [...]