topic sql server sequential writes netapp in ONTAP Discussions

sql server sequential writes netapp

ache — Thu, 05 Jun 2025 05:12:32 GMT

Hi guys! Can you please help to understand if it is normal behavior or not?
I have fas3220, on this fas there is a lun on aggregate with 57 disks and no application loads it.
hosts connected to fas over fcoe, version of OS 8.2P3 7-MODE
I wand to place on this lun high loaded database which is high on transaction log writes.
So i decided to test this lun on sequenctial 8k writes with iometer and compare to local drive performance -
all iometer settings that i changed and results you can find on screenshots in attachments.
results of this tests are amazing
Local drive(600 Gb 15k SAS raid 1) shows us 11000 IOPS, but fas3220 lun only 1400.
And my reasonable question - why is so drastic difference, why local drive so much outperform fas3230? is it normal?

Re: sql server sequential writes netapp

Uddhav — Thu, 29 Jan 2015 12:48:57 GMT

You should throw some SSDs there

like something below....

aggr_name flash_pool? #_of_HDD #_of_SDD #_of_ops_actual #_of_ops_possible

aggr1 n 56 0 2000 7480

aggr2 y 56 10 4000 31480

Let me know

Re: sql server sequential writes netapp

ache — Fri, 30 Jan 2015 11:55:03 GMT

it is not so obvious about ssd. On local disk i just have sas 15 k hdd - and it is faster