[PVE-User] SQL server 2014 poor performances

Mark Adams mark at openvs.co.uk
Mon Oct 28 16:56:02 CET 2019


There is a WD Blue SSD - but it is a desktop drive, you probably shouldn't
use it in a server.

Are you using the virtio-scsi blockdev and the newest virtio drivers? also,
have you tried with writeback enabled?

Have you tested the performance of your ssd zpool from the command line on
the host?

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
>


More information about the pve-user mailing list