george sibbald (1/19/2011)
Perry,maybe it is taken as read but it should be mentioned another drive would be needed to install SQL application files to (i.e. the instance root directory) and this would not be a cluster resource.
C drive could be used for this but a drive for the purpose would be usual.
thanks for putting the article together. Any plans for an article on clustering other SQL components (mainly SSIS and SSRS)
Completely agree, generally you would have a D drive for application files although is this really absolutely necessary nowadays?
On SQL Server 2008 (not R2) there is a known issue with cluster installations whereby the shared components location on nodes you add to a clustered instance is ignored and goes straight to C: drive regardless. This is fixed in a later SP\CU so if slipstreaming the approprtiate fix should be fine. R2 doesn't have the issue.
It's preference i suppose, the idea was to keep things simple here and to the point without wittering on to much about best practices that most of us are aware of.
SSIS is not truely cluster aware and MS do issue warnings about configuring it so, SSRS is not cluster aware either. I am planning an article which uses Veritas Cluster Services, this product allows any Windows service to be configured as a cluster resource.
Glad you liked the article.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉