SQL Server Performance Forum – Threads Archive
NAS deviceAnyone out there running on a NAS device? If you have an opinion on running SQL 2K EE / W2K3 EE on a NAS, I’d be interested to hear it. We are currently deployed on one, and I’ve heard a lot of conflicting arguments about whether this is a good idea or not.
We have had few segment issues on SQL Server running on NAS device and it found to be faulty disk controller and incorrect BIOS settings, which was fixed at a later stage. You should pinpoint the correct AWE configuration in order to overcome certain issues if too much memory is allocated to SQL Server. Refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;304261 about verified HCL for NAS devices. HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Microsoft have in the past changed their opinion on support of this kind of set up. With W2K3 they do now support it again. I’ve not actually had a production system running on the NAS, as it is still seens as too big a risk with the database accessed from the SQL Server over the network… I don;t know if that is a valid concern though… Twan
I ran several databases on a NAS for a couple years. We didn’t have any issues with it. We were running SQL 2K EE / W2K EE.
[email protected] When life gives you a lemon, fire the DBA.