3PAR Users Group

A Storage Administrator Community




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Slow SSD Performance
PostPosted: Tue Nov 27, 2018 2:42 am 

Joined: Tue Nov 27, 2018 2:36 am
Posts: 1
We have a 3par with 36 sas disks and a cluster with 3 HyperV nodes. the SQL was performing good but we needed to speed up things, so we got 8 SSD disks.

we moved the database to a ssd volume and the performance was tragic

the index of the databas on the sas took 1h 36m and on the ssd took 5h 53m.

all hosts are firmare updated and the fiber switch to the latests.

any ideas what might be going wrong???


Top
 Profile  
Reply with quote  
 Post subject: Re: Slow SSD Performance
PostPosted: Tue Nov 27, 2018 5:12 am 

Joined: Tue Mar 29, 2016 9:32 pm
Posts: 65
Do you have more info on your setup ?

Is it a thin, deduped, compressed volume on the array ?

Did you do a host based "copy the files" migration to the new volume or have the array tune the existing volume onto SSD for you ?
- If you did a host based copy did you make sure to format the disk correctly ? had a similar issue where SQL disks were formatted 4k and should be 64k

More info is always good :-)


Top
 Profile  
Reply with quote  
 Post subject: Re: Slow SSD Performance
PostPosted: Tue Nov 27, 2018 12:35 pm 

Joined: Mon Sep 21, 2015 2:11 pm
Posts: 722
Location: Europe
Also, what is the indexing doing. If it was large sequential IO you're not getting a lot more power/bandwidth per spindle. So a 75% reduction in spindles isn't always a good thing :).

Latency however should be a lot lower.

What 3par system do you have and what 3par OS version?


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


Who is online

Users browsing this forum: Google [Bot] and 15 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