[PVE-User] SQL server 2014 poor performances

[Fabrizio Cuseo]

----- 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