3 Replies Latest reply: Apr 4, 2010 1:27 PM by dnewtontmw RSS

Best practices for SQL Server on NetApp - Performance?

dnewtontmw
Currently Being Moderated

We have SQL 2005 (soon SQL 2008) on a FAS3160 unit, 28 spindles, FC SAN, 15K disks.  This is the only host using this storage system.  We're probably at 60% of total space capacity.

 

It seems like since we went live 6 months ago on this storage system (NetApp is new to us), that performance has gradually degraded.  SQL Server is increasingly reporting waits from the disk subsystem.

 

Is there any checklist or guide for how to keep your NetApp box running at peak performance, in a SQL Server environment?  We do all of the typical SQL Server DBA maintenance (index rebuilds and so on).

 

Thanks.

More Like This

  • Retrieving data ...