topic Re: Performance issue on drives that has been provided to SQL cluster node in Data Protection https://community.netapp.com/t5/Data-Protection/Performance-issue-on-drives-that-has-been-provided-to-SQL-cluster-node/m-p/48236#M7636 <HTML><HEAD></HEAD><BODY><P>Are there any Snapmirrors or SMSQL jobs running at the same time?</P><P>Any de-duplication? If this is set to auto consider setting the de-dupe to run on a schedule out of hours.</P><P></P><P>A disk reallocate may also help with performance depending on your set up, but I would wait for Netapp Support to confirm after reviewing your data.</P></BODY></HTML> Thu, 01 Dec 2011 17:21:40 GMT GRAEMEOGDEN 2011-12-01T17:21:40Z Performance issue on drives that has been provided to SQL cluster node https://community.netapp.com/t5/Data-Protection/Performance-issue-on-drives-that-has-been-provided-to-SQL-cluster-node/m-p/48232#M7635 <HTML><HEAD></HEAD><BODY><P>We have provided some of the luns to SQL cluster and there is performance issue when they are running some DB scripts on the server where the luns are located. We have checked NetApp filers CPU, memory and switch port I/O ratings. Evrything is normal..We have collected perf stat from filer and sent it to NetApp support and waiting for update. Can any one Please suggest on this, If you faced same kind of issue earlier ?</P></BODY></HTML> Thu, 05 Jun 2025 06:40:24 GMT https://community.netapp.com/t5/Data-Protection/Performance-issue-on-drives-that-has-been-provided-to-SQL-cluster-node/m-p/48232#M7635 VEERA_DURAI 2025-06-05T06:40:24Z Re: Performance issue on drives that has been provided to SQL cluster node https://community.netapp.com/t5/Data-Protection/Performance-issue-on-drives-that-has-been-provided-to-SQL-cluster-node/m-p/48236#M7636 <HTML><HEAD></HEAD><BODY><P>Are there any Snapmirrors or SMSQL jobs running at the same time?</P><P>Any de-duplication? If this is set to auto consider setting the de-dupe to run on a schedule out of hours.</P><P></P><P>A disk reallocate may also help with performance depending on your set up, but I would wait for Netapp Support to confirm after reviewing your data.</P></BODY></HTML> Thu, 01 Dec 2011 17:21:40 GMT https://community.netapp.com/t5/Data-Protection/Performance-issue-on-drives-that-has-been-provided-to-SQL-cluster-node/m-p/48236#M7636 GRAEMEOGDEN 2011-12-01T17:21:40Z