Browse by Tags

SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?

Published 18 March 8 4:20 AM | SSQA.net

First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment. To cover on newbie aspect both Active/Passive & Active/Active configuration...

Filed under: sql server, performance, security, clustering, 2005, partition, monitoring, active/passive, parallel execution, performance monitoring, active/active, scalability

Settings to Cluster service domain account and the SQL Server service domain account

Published 10 January 8 2:56 AM | SSQA.net

When you are setting up SQL Server cluster you should think about security privileges that is required for the Cluster Administrator account and SQL Server services account. Do not attempt to use same account for both the serivces, as it will be single...

Filed under: sql server, authentication, account, active/passive, setup, bypass, spn, clusters, domain, cluadmin

Cluster resource 'SQL Server (<SQL Server instance name>)' in Resource Group '<Cluster group name>' failed.

Published 10 October 7 4:31 PM | SSQA.net

A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application...

Filed under: sql server, dba, sqlagent, best practices, cluster, error log, online, failure, active/passive

What should I choose Load Balancing or Data Partitioning?

Published 12 September 7 5:42 AM | SSQA.net

One of our client had such requirement to cater a load balancing for their application and needed to upgrade to higher versions of SQL Server & Operating systems. The current setup at their end is a SQL Server 2000 Active/Passive Cluster and the transactions...

Filed under: sql server, performance, high availability, tuning, replication, active/passive, latency