HPE Storage Users Group

A Storage Administrator Community




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: 3PAR 7450 (3.3.1 MU2) on 16Gb FC and MSSQL
PostPosted: Mon Aug 13, 2018 4:11 pm 

Joined: Thu Mar 21, 2013 11:38 am
Posts: 166
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?


Top
 Profile  
Reply with quote  
 Post subject: Re: 3PAR 7450 (3.3.1 MU2) on 16Gb FC and MSSQL
PostPosted: Tue Aug 14, 2018 8:56 am 

Joined: Wed Aug 07, 2013 3:22 pm
Posts: 254
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


Top
 Profile  
Reply with quote  
 Post subject: Re: 3PAR 7450 (3.3.1 MU2) on 16Gb FC and MSSQL
PostPosted: Wed Aug 15, 2018 11:28 am 

Joined: Thu Mar 21, 2013 11:38 am
Posts: 166
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?


Top
 Profile  
Reply with quote  
 Post subject: Re: 3PAR 7450 (3.3.1 MU2) on 16Gb FC and MSSQL
PostPosted: Thu Aug 16, 2018 11:37 pm 
Site Admin
User avatar

Joined: Tue Aug 18, 2009 10:35 pm
Posts: 1328
Location: Dallas, Texas
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.

_________________
Richard Siemers
The views and opinions expressed are my own and do not necessarily reflect those of my employer.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 


Who is online

Users browsing this forum: Google [Bot] and 58 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group | DVGFX2 by: Matt