Maximum LUN Size Limit Can be Presented to a SQL DB Volume

[Pramod Unni]

We have a scenario where we have 2xDL580 G5 Servers installed with Smart Array P812 controllers connected to 7xMSA 60 Disk enclosures, is there any possibility to have the boot from SAN option (we are planning to use SQL 2005 DB on these servers, in case one server goes down,we can have a stand by server option if this is possible).



In this scenario, we have one HP P2000 G3 MSA FC Dual Cntrl LFF Array & 6x HP P2000 Dual I/O LFF Drive Enclosures. Here my question was when we present a volume for the cluster disk resource as i understand there is size limit basic & dynamic volumes (2TB for basic & 16TB for GPT), in this case we will have limitation of max LUN size right?

In this option if we setup a Active Passive SQL 2005 Cluster with MSA P2000 G3 with 5 Enclosures with 2TB drives (2TBx 60Nos, I believe there is a limit on the LUN we can present for SQL DB disk.

Can any one throw some light on this scenario.

[Prokopets]

Hi!
>is there any possibility to have the boot from SAN option
No, it's not possible in this configuration. Anctually, you can boot from this enclosures, but you won't get standby server.

>in this case we will have limitation of max LUN size right?
i'm not sure, if i understood you correctly, but maximum LUN size that storage can present to host doesn't depend on a host file system and it's 16Tb for P2000 in any case.