topic Re: Advice on poor perf. on MS SQL 2k5 DBs running on iSCSI? in Data Protection https://community.netapp.com/t5/Data-Protection/Advice-on-poor-perf-on-MS-SQL-2k5-DBs-running-on-iSCSI/m-p/63969#M9103 <HTML><HEAD></HEAD><BODY><P>In case anyone was wondering, the DBs were moved off the NetApp, new LUNs created with the correct OS type, remapped to the host, and DBs were moved back.</P></BODY></HTML> Fri, 08 Oct 2010 04:07:20 GMT jeff_cassianna 2010-10-08T04:07:20Z Advice on poor perf. on MS SQL 2k5 DBs running on iSCSI? https://community.netapp.com/t5/Data-Protection/Advice-on-poor-perf-on-MS-SQL-2k5-DBs-running-on-iSCSI/m-p/63964#M9102 <HTML><HEAD></HEAD><BODY><P>I have a customer with MS SQL DBs running horribly on W2k8r2 VSpere VMs.&nbsp; I found they were originally provisioned with regular "Windows" LUN type (which is specific to Windows 2003) which explains that improper block alignment is causing the poor performance.&nbsp; I've been told that the best way to resolve this is create new LUNs with "Windows 2008" type, then migration the DBs to those new LUNs.&nbsp; Has anyone ever done this successfully?&nbsp; If yes, what were your steps?&nbsp; Does anyone know of any other better way?</P><P>Thanks.</P></BODY></HTML> Thu, 05 Jun 2025 07:08:16 GMT https://community.netapp.com/t5/Data-Protection/Advice-on-poor-perf-on-MS-SQL-2k5-DBs-running-on-iSCSI/m-p/63964#M9102 jeff_cassianna 2025-06-05T07:08:16Z Re: Advice on poor perf. on MS SQL 2k5 DBs running on iSCSI? https://community.netapp.com/t5/Data-Protection/Advice-on-poor-perf-on-MS-SQL-2k5-DBs-running-on-iSCSI/m-p/63969#M9103 <HTML><HEAD></HEAD><BODY><P>In case anyone was wondering, the DBs were moved off the NetApp, new LUNs created with the correct OS type, remapped to the host, and DBs were moved back.</P></BODY></HTML> Fri, 08 Oct 2010 04:07:20 GMT https://community.netapp.com/t5/Data-Protection/Advice-on-poor-perf-on-MS-SQL-2k5-DBs-running-on-iSCSI/m-p/63969#M9103 jeff_cassianna 2010-10-08T04:07:20Z