[PVE-User] SQL server 2014 poor performances

Fabrizio Cuseo f.cuseo at panservice.it
Mon Oct 28 17:16:16 CET 2019


Sorry, PVEPERF not VZPERF



----- Il 28-ott-19, alle 17:15, Fabrizio Cuseo f.cuseo at panservice.it ha scritto:

> ----- Il 28-ott-19, alle 16:56, Mark Adams mark at openvs.co.uk ha scritto:
> 
>> There is a WD Blue SSD - but it is a desktop drive, you probably shouldn't
>> use it in a server.
> 
> Hello mark.
> I know that is a desktop drive, but we are only testing the different
> performances between this and a desktop pc with a similar (or cheaper) desktop
> ssd.
> 
> 
>> Are you using the virtio-scsi blockdev and the newest virtio drivers? also,
> 
> I am using the virtio-scsi, and virtio drivers (not more than 1 year old
> version)
> 
>> have you tried with writeback enabled?
> 
> Not yet.
> 
> 
>> Have you tested the performance of your ssd zpool from the command line on
>> the host?
> 
> 
> Do you mean vzperf ?
> 
> PS: i don't know if the bottleneck is I/O or some problem like the SQL "content
> switch" setting.
> 
> PPS: SQL server is 2017, not 2014.
> 
> 
> 
>> On Mon, 28 Oct 2019 at 15:46, Michael Rasmussen via pve-user <
>> pve-user at pve.proxmox.com> wrote:
>> 
>>>
>>>
>>>
>>> ---------- Forwarded message ----------
>>> From: Michael Rasmussen <mir at miras.org>
>>> To: pve-user at pve.proxmox.com
>>> Cc:
>>> Bcc:
>>> Date: Mon, 28 Oct 2019 16:46:23 +0100
>>> Subject: Re: [PVE-User] SQL server 2014 poor performances
>>> On Mon, 28 Oct 2019 15:47:18 +0100 (CET)
>>> Fabrizio Cuseo <f.cuseo at panservice.it> wrote:
>>>
>>> > Hello.
>>> > I have a customer with proxmox 5.X, 4 x SSD (WD blue) in raid-10 ZFS
>>> > configuration, Poweredge R710 dual xeon and 144Gbyte RAM. Same
>>> > problem with 4 x SAS 15k rpm drives.
>>> >
>>> Are you sure it is SSD? I don't recollect that WD has produced WD blue
>>> as SSD.
>>>
>>> --
>>> Hilsen/Regards
>>> Michael Rasmussen
>>>
>>> Get my public GnuPG keys:
>>> michael <at> rasmussen <dot> cc
>>> https://pgp.key-server.io/pks/lookup?search=0xD3C9A00E
>>> mir <at> datanom <dot> net
>>> https://pgp.key-server.io/pks/lookup?search=0xE501F51C
>>> mir <at> miras <dot> org
>>> https://pgp.key-server.io/pks/lookup?search=0xE3E80917
>>> --------------------------------------------------------------
>>> /usr/games/fortune -es says:
>>> Follow each decision as closely as possible with its associated action.
>>>             - The Elements of Programming Style (Kernighan & Plaugher)
>>>
>>>
>>>
>>> ---------- Forwarded message ----------
>>> From: Michael Rasmussen via pve-user <pve-user at pve.proxmox.com>
>>> To: pve-user at pve.proxmox.com
>>> Cc: Michael Rasmussen <mir at miras.org>
>>> Bcc:
>>> Date: Mon, 28 Oct 2019 16:46:23 +0100
>>> Subject: Re: [PVE-User] SQL server 2014 poor performances
>>> _______________________________________________
>>> pve-user mailing list
>>> pve-user at pve.proxmox.com
>>> https://pve.proxmox.com/cgi-bin/mailman/listinfo/pve-user
>>>
>> _______________________________________________
>> pve-user mailing list
>> pve-user at pve.proxmox.com
>> https://pve.proxmox.com/cgi-bin/mailman/listinfo/pve-user
> 
> --
> ---
> Fabrizio Cuseo - mailto:f.cuseo at panservice.it
> Direzione Generale - Panservice InterNetWorking
> Servizi Professionali per Internet ed il Networking
> Panservice e' associata AIIP - RIPE Local Registry
> Phone: +39 0773 410020 - Fax: +39 0773 470219
> http://www.panservice.it  mailto:info at panservice.it
> Numero verde nazionale: 800 901492
> _______________________________________________
> pve-user mailing list
> pve-user at pve.proxmox.com
> https://pve.proxmox.com/cgi-bin/mailman/listinfo/pve-user

-- 
---
Fabrizio Cuseo - mailto:f.cuseo at panservice.it
Direzione Generale - Panservice InterNetWorking
Servizi Professionali per Internet ed il Networking
Panservice e' associata AIIP - RIPE Local Registry
Phone: +39 0773 410020 - Fax: +39 0773 470219
http://www.panservice.it  mailto:info at panservice.it
Numero verde nazionale: 800 901492


More information about the pve-user mailing list