January 4, 2013 at 12:13 pm
I have a general kind of 'best practices' question.
We recently stood up a new Windows 2008 R2 Cluster (Active\Passive) Cluster and are running SQL Server 2008 R2 in the Cluster.
I have worked in smaller shops where the DBAs did everything from Server installs to DBMS installs and all of the support for both.
The shop I work in now is large enough where we have a DBA Team, a Systems Support Team, a Network Support Team and an Application Admin Team.
Now that this new Cluster is up and running and we successfully installed SQL Server, we are getting ready to go into Production with it but we are bickering about SLAs. The general feeling in the Systems Group is that it's a Clustered Database Server so the DBAs should be responsible for the Cluster itself as well as SQL Server. My feeling is that Systems Delivered the Servers to us Clustered at the OS level and we mearly installed SQL Server in the Cluster so Systems should be responsible for Clustering at the OS level and the DBAs will take care of SQL Server.
How do other shops handle this??
January 4, 2013 at 12:20 pm
We have done it as a joint effort.
This is not just a database cluster, it is also a windows cluster. There are two clusters installed - the os is installed and then there is the SQL Cluster that sits on top of the windows cluster. The sysadmin group (in our case) took care of the OS Cluster, and the DBAs handled the SQL Cluster.
The sysadmin group needs to be involved in either case though. There will possibly be a need for help with DNS or AD depending on the issue.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 4, 2013 at 12:30 pm
I work in a large shop with separate teams for DBA, sysadmins, network etc, and our sysadmins support the OS, which includes the windows cluster, and DBA support the SQL cluster. thats how the build of the cluster was parceled out as well.
If the sysysadmins built the windows cluster in your case I would be surprised (not to say disappointed) if they did not support it as well, if the DBAs installed the windows cluster as well you may have lumbered yourself.
---------------------------------------------------------------------
January 4, 2013 at 12:41 pm
Do DBAs handle the OS support for non-clustered servers? If not, then I don't see any reason for the DBAs to have responsibility for the Windows cluster.
In reality, both groups will probably have some cluster responsibility here. The DBAs may have a need to take SQL Server or the Agent offline using the cluster management application or fail it over to the other node. If you just stop the service like you would on a non-clustered server it will fail-over and restart on the other node, so the DBA will need to use the the cluster management application for that.
January 4, 2013 at 1:03 pm
Thank you sor your comments.. my feeling exactly : )
January 5, 2013 at 4:47 am
If you have role separation in the organisation then the OS and the cluster should be managed by the Windows server team. SQL Server obviously manmaged by the DBAs.
I have also worked in smaller shops where i deployed not only the clustered SQL Server instance but also the OS nodes and the base cluster, it depends on the organisation.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply