Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag cluster Rss

   Items 1 to 17 of 17   
 

Add new disks to a SQL Server Failover Cluster on Windows 2008

This article shows the procedure to Add new disks to SQL Server failover cluster in windows 2008/2008R2. This article also covers how to add dependencies to a SQL Server cluster resource.  Read more...
By Ganapathi varma 2015/11/30 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 1,325 reads

How to Categorize Uncategorized Data

Using SQL to perform cluster analysis to gain insight into data with unknown groups  Read more...
By Stephan Calderon 2015/04/16 | Source: SQLServerCentral.com | Category: cluster analysis
Rating: |  Discuss |   Briefcase | 4,157 reads

Stairway to AlwaysOn Level 6: Analyse & Deploy an AlwaysOn Availability Group

In level 6 of this stairway, we will look deeper into Availability Groups and how to set them up along with a Listener.  Read more...
By Perry Whittle 2015/03/25 | Source: SQLServerCentral.com | Category: stairway
Rating: |  Discuss |   Briefcase | 4,265 reads

Stairway to AlwaysOn Level 5: Analyse & Deploy a Failover Cluster Instance

In Level 5 of this stairway, we help you understand and deploy a Failover Cluster Instance (FCI).  Read more...
By Perry Whittle 2015/02/11 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 3,378 reads

Stairway to AlwaysOn Level 4: Analyse & Deploy a Windows Server Failover Cluster

In level 4 of the stairway to AlwaysOn we look at creating a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2014/12/10 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 3,614 reads

Stairway to AlwaysOn Level 3: Infrastructure 101

In this next level of the Stairway to AlwaysOn, we will look at the components required to implement a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2014/10/29 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 5,127 reads

Stairway to AlwaysOn Level 2: Storage 101

level 2 of the stairway  Read more...
By Perry Whittle 2014/10/01 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 5,661 reads

Stairway to AlwaysOn Level 1: What is "SQL Server AlwaysOn"?

Level 1 of the stairway looks at exactly what the technologies "AlwaysOn", "Failover Cluster Instance" (FCI) and "Windows Server Failover Cluster" are. We'll look at each in detail and summarize where in the High Availability stack they sit.  Read more...
Rating: |  Discuss |   Briefcase | 14,882 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 4

This is Part 4 of a series on AlwaysOn and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.  Read more...
By Perry Whittle 2014/05/20 | Source: SQLServerCentral.com | Category: mirroring
Rating: |  Discuss |   Briefcase | 3,591 reads

Why every SQL Server installation should be a cluster

In this article, I’ll attempt to “convince” you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).  Read more...
By Francis Apel 2014/04/15 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 10,017 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 3

Part 3 of the AO and FCI integration series. This article gets SQL Server configured on the nodes and ready for work.  Read more...
By Perry Whittle 2014/04/03 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 3,425 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 2

This is Part 2 of a series on AlwaysOn and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.  Read more...
By Perry Whittle 2014/03/06 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 4,376 reads

Powershell script to interactively move cluster resources

Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.  Read more...
By Rolando Hernandez 2013/11/19 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 549 reads

Script to determine if two instances are on the same node

Determines if two instances of a Active/Active cluster are running on the same node.  Read more...
By Gregory Ferdinandsen 2013/11/13 | Source: SQLServerCentral.com | Category: wmi
Rating: |  Discuss |   Briefcase | 819 reads

Updating the TCP Port on a SQL Server Cluster Node

When installing 2 SQL Server instances on a Windows Cluster, the installation program requires a Named Instance during the installation of the second node and a dynamic TCP port is created. How do you update the TCP port after the installation in a clustered environment for the named instance?  Read more...
By Additional Articles 2013/05/27 | Source: MSSQLTips.com | Category: tcp
Rating: (not yet rated)  Rate this |   Briefcase | 4,099 reads

Retrieve SQL Instance Connect Info

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port  Read more...
Rating: |  Discuss |   Briefcase | 1,406 reads

SQL Start up Script

This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.  Read more...
By Monte Kottman 2012/09/25 | Source: SQLServerCentral.com | Category: startup
Rating: |  Discuss |   Briefcase | 1,757 reads
   Items 1 to 17 of 17   
 
Tags
alwayson (10)    
failover clustered instance (fci) (7)    
wsfc (6)    
mirroring (3)    
node (2)    
powershell (2)    
agent (1)    
cluster analysis (1)    
data mining (1)    
data science (1)    
email (1)    
failover (1)    
interactive (1)    
ports (1)    
resource groups (1)    
scom (1)    
sql cluster (1)    
sql server (1)    
sql server 2012 (1)    
stairway (1)    
stairway series (1)    
startup (1)    
statistics (1)    
stored procedure (1)    
system center operations manager (1)    
tcp (1)    
unknown groups (1)    
windows 2012 (1)    
wmi (1)    
wql (1)