question

Therealist avatar image
Therealist asked

What are the things that a DBA must know about at Windows level that is related to SQL Server and Cluster?

Could Someone one provide any information or topics that a DBA must be aware of when it is especially relating to SQL server and Cluster ,it could be like memory related,Ram,disk,services,configuration related topics etc. Thanks
sql-server-2008-r2sql-server-2012clusterwindows
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
It depends on how involved you are in the cluster setup and maintenance. But, having an entirely new set of behaviors for SQL Server would require you to at least understand what is likely to happen. In general, the standard behaviors of SQL Server don't change. Memory allocation and management, CPUs and threading, disk access, are all the same, effectively, within SQL Server. It's primarily all the external processes that are going to be different. I'd suggest starting at the same point I start with any learning on SQL Server, the Books Online. There are the [hardware and software requirements][1] for clustering within SQL Server. That will at least cover the basics. [1]: http://msdn.microsoft.com/en-us/library/ms143506.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.