NetApp storage recommendation for SQL Server 2008 R2
I am currently in the process of building 600gb database. The DB will be stored on a NetaApp filer using a single aggregate with RAID-DP. Do I create just one volume and then place all my data files and separate within folders or does it matter to create different volumes and break out data, log and temdb on their own volumes? Is there any performance gain or loss by doing either given the fact that It is just one aggregate?
OS: Windows Server 2008 R2
SQL: SQL Server 2008 R2
Thank you.
OS: Windows Server 2008 R2
SQL: SQL Server 2008 R2
Thank you.
Few questions:
Will you be using Snapmanager for SQL?
Will this be a physical or virtual environment (cool stuff you can do with VMware).
Will this be snapmirrored to another site?
What Netapp are you running and which Ontap build?
Best practice is to put your logs and database volumes on different aggregates if you have it, if you can't afford the storage reduction for a second aggregate you can put it on the same one but you'll need 3 volumes at a minimum. One database, one logs, and one for snapinfo. Putting the temp db on a separate LUN also may be a good idea.
Do you need to have the databases cloned a on a different system for reporting (you can do this by mounting the LUN from a snapshot if you have flex clone on a wholly different system without affecting performance)
Will you be using Snapmanager for SQL?
Will this be a physical or virtual environment (cool stuff you can do with VMware).
Will this be snapmirrored to another site?
What Netapp are you running and which Ontap build?
Best practice is to put your logs and database volumes on different aggregates if you have it, if you can't afford the storage reduction for a second aggregate you can put it on the same one but you'll need 3 volumes at a minimum. One database, one logs, and one for snapinfo. Putting the temp db on a separate LUN also may be a good idea.
Do you need to have the databases cloned a on a different system for reporting (you can do this by mounting the LUN from a snapshot if you have flex clone on a wholly different system without affecting performance)
ASKER
This is a pretty straight forward SQL install. Netapp providing storage via FC. Based on the fact that the luns will be presented to the server from one aggregate is there any benefit to using seperate vol/luns?
Physical server
Netapp Filer 8.1.2P4 7-Mode HA
No plans to cluster
No snap mirror
Single aggregate
Physical server
Netapp Filer 8.1.2P4 7-Mode HA
No plans to cluster
No snap mirror
Single aggregate
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will configure seperate volumes and luns. Thanks for all of your help.
A 600GB DB currently, depending on your transaction log backup schedule, and the activity, could be 100GB log file.
Are ou having multiple paths to the netapp (load balanced)
Are there plans to Cluster SQL?
If so, you should start with a single node cluster such that it will be ready should you upgrade......
Four Luns (quorum, database files, transaction log files,backup LUN unless you have a separate backup solution.)