January 5, 2011 at 12:32 am
Hi,
does some one have any inforamtion on "SQL Server & Windows 2008 R2 HPC Cluster"?
As I read Windows Server 2008 R2 HPC Cluster FAQ http://www.microsoft.com/hpc/en/us/product/high-performance-computing-faqs.aspx
it indicate that Server Application can not be run on Windows 2008 R2 HPC Cluster.
If someone have information releted to it plz share. Actuly I want to run SQL Instance on HPC Cluster.
Ram
MSSQL DBA
January 10, 2011 at 5:49 am
Ramdas Baghel (1/5/2011)
Hi,If someone have information releted to it plz share. Actuly I want to run SQL Instance on HPC Cluster.
Hi Ramdas
Windows HPC Server does not support SQL Server. Actually the HPC architecture in general is not well suited for the way SQL Server works and operates.
In HPC a series of devices work on their own little piece of a larger puzzle. Take SETI@home for example. In the SETI@home project every connected device (PC/PS3/whatever) analyze a small bit of radio telescope data. Every device works independently and only at a later stage the results are merged.
In SQL Server however, the connected servers wouldn't be able to work independently, for a number of reasons. The fact that you can't even have a SQL Server instance run active/active in a Microsoft Failover Clustering environment, I don't think HPC SQL Server compatibility is coming any time soon.
You might want to take a look at SQL Azure though:
http://www.microsoft.com/en-us/sqlazure/default.aspx
Best regards
Lars Søe Mikkelsen
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply