2005 PASS Summit Attendess - Question
-
For all of you out there that are going to be at the 2005 PASS Summit, do any of you use NAS (specifically NetApps) and iSCSI for your SQL Server? If so, I would really like to meet with you at the Summit.
We are in the process of making a lot of changes in our SQL Server environment and one of the things we are going to do is move our data to some existing NetApps filers using iSCSI. I want to meet with and talk to as many people as I can about how their systems are setup and how they work and the things I need to be aware of in this configuration.
Thanks for any feedback!
hawg
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
-
I don't use NetApp but as far as I know NAS has very limmited support in SQL Server!
Take a look at: Support for Network Database Files
Relevant Part:
Microsoft does not support SQL Server networked database files on NAS or networked storage servers that do not meet these write through and write order requirements.
Because of the risks of network errors compromising database integrity, together with possible performance implications that may result from the use of network file shares to store databases, Microsoft recommends that you store database files either on local disk subsystems or on Storage Area Networks (SANs).
Now I've met people before that Have use Network Appliance products and all goes well until high volumes kick in and then is all about them blaming M$ and M$ blaming them
Are you sure you can't go to SAN?
* Noel -
I understand, and I agree, that a SAN would be the best route. However, we currently have a NAS solution in house and with the introduction of iSCSI, that is the route we are taking at this time.
We tried it in the past using CIFS and that was horrible and I told them that we were taking all SQL data off the NAS, and I did, except for two databases.
When this issue came up again we started talking about the introduction and growing maturity of iSCSI. Because of our existing NAS filers and the amount of work our SQL Servers currently perform, this seems to be a reasonable solution at this time.
As our company grows (the reason for our changes), we will be able to monitor the performance. We know we will have to add some additional storage in the future whether it is NAS or SAN or DAS. Our performance requirements should not grow so quickly that we outgrow the NAS solution within the next couple of years.
By that time, we will be better situated to make a determination on the future direction for storage.
All that to say, we are going the NAS route, I just want to talk to others that are currently using it with the current iSCSI drivers.
Thanks.
hawg
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply