HPE Storage Users Group https://www.3parug.com/
3PAR 7450 (3.3.1 MU2) on 16Gb FC and MSSQL https://www.3parug.com/viewtopic.php?f=18&t=2955	Page 1 of 1

---

Author:	mujzeptu [ Mon Aug 13, 2018 4:11 pm ]
Post subject:	3PAR 7450 (3.3.1 MU2) on 16Gb FC and MSSQL
We are experiencing high queue lengths on our VMFS5 datastore LUNs hosting our MSSQL servers. Nothing else seems to have the problems that SQL does? We have zero detect, 16k aligned and NO dedupe on these specific LUNs. Overall system performance seems fine. In this case the 1TB LUN's host nothing but 1 VM running the SQL database. In 3PAR CLI running a statvv I will see the queue length spike up to the 40's+. We will also see SQL inserts fail and constantly be cached and re-queued. Is there any recommendations or thoughts on how best to run a SQL instance on 3PAR? Anything obvious I may be missing?

---

Author:	Cleanur [ Tue Aug 14, 2018 8:56 am ]
Post subject:	Re: 3PAR 7450 (3.3.1 MU2) on 16Gb FC and MSSQL
Have you tried setting up cross stack Analytics in InfoSight ? Not saying it'll fix your issue but might help you pin down the source of the latency. https://infosight.hpe.com https://h20195.www2.hpe.com/V2/GetDocument.aspx?docname=a00048709enw

---

Author:	mujzeptu [ Wed Aug 15, 2018 11:28 am ]
Post subject:	Re: 3PAR 7450 (3.3.1 MU2) on 16Gb FC and MSSQL
I have and it is helpful. Curious does anyone else constantly rebuild/defrag their indexes? Thoughts on doing this on an SSD array with mixed workload?

---

Author:	Richard Siemers [ Thu Aug 16, 2018 11:37 pm ]
Post subject:	Re: 3PAR 7450 (3.3.1 MU2) on 16Gb FC and MSSQL
My thoughts on "constantly" rebuilding/defrag index on a SSD array - it needs to be reviewed and adjusted. Overly aggressive DB maint on SSD arrays does not yield the significant benefits it used to on spinning disks with a high seek time penalty for fragmented data.

---

Page 1 of 1	All times are UTC - 5 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/