Risorse vm e coda disco alta

[paolino79]

Ciao a tutti,

ho una macchina con 2 processori quad core con 32 gb di ram con esxi 5.0.All'interno ho due macchine virtuali con 2 socket e 4 core e 16 ram ciascuna.In una vm ho un database sql e l'altra l'utilizzo per terminal server.

A intervallli non regolari tutto il sistema si rallenta per poi ripredersi da solo.Ho verificato che le code del disco sono molto alte come la memoria che viene consumata.

Volevo chiedervi come faccio a modificare le code del disco e se la distribuzione del carico è corretta.

Grazie mille a tutti

Ciao

[Tinto1970]

ciao, la prima cosa che mi salta all'occhio è: come mai hai replicato esattamente il numero di socket e cpu che hai fisicamente in quelli presentati alle vm? Forse hai dovuto farlo ma... mi pare un po' strano che una macchina per terminal server necessiti di 8 vCPU...

Venendo alla domanda più specifica: come è configurata la macchina sql (che tipo di db, e come sono i dischi virtuali) e come sono i dischi fisici?

[paolino79]

Grazie Tinto per la risposta.

Ti rispondo alle tue domande:

Ho dato 8vcpu perchè il terminal era lento e quindi ho dato più risorse.

La macchina del database è un windows 2008 r2 con sql standard. Il database è grande all'incirca 15gb, la macchina ne ha 16gb di ram.I dischi sono Thick provision Lazy Zeroed.

I dischi fisici invece sono dischi sas 15000 giri in raid 1 con scheda rai da 512mb.

Grazie mille

[Tinto1970]

la grandezza del db non dice qualcosa ma non molto.... potresti raccogliere un po' di informazioni su quanti IOPS vengono richiesti dalla VM, lo puoi fare con perfmon di windows o anche con il semplice tool "dpack" di Dell.

[rsicilia]

Ciao paolino, per prima cosa ti suggerisco caldamente di diminuire il numero di vCPU in quanto aumentarle senza una reale esigenza (ovvero vCPU che lavorano effettivamente a carichi significativi) potrebbe peggiorarti le performance. Trattandosi di un DB ti suggerisco di partire con 2 vCPU e vedere come si comporta e se le vedi sature (80-90% di carico) aumentale.

In relazione alle code di che livelli stiamo parlando? Quanti IOps genera la VM e quanti ne gestisce il tuo Datastore? Con questi dati dovremmo poter comprendere meglio cosa sta succedendo.

--

Rocco Sicilia

http://www.roccosicilia.it

[paolino79]

Ciao a tutti e vi ringrazio per le risposte.

Ho raccolto un po di informazioni tramite ildpack di dell, che vi allego.

Mi consigliate di diminuire le vcpu, perchè?

<!--

 This is an uncompressed copy of the xml data embedded into the iokit file. 

--> 

- <plog version="11" collector="windows" collectorVersion="1.5.0.287970" localStart="635037769404680000" localEnd="635037913418970000" machineCount="1" deviceCount="1" entryCount="238" binaryLen="5346" contactFirstName="" contactLastName="" contactCompany="" contactPhone="" contactEmail="ppiotto@techgest.it" adler32="955025527">

- <machines>

- <machine protocol="pdh" name="SERVER4" id="0" os="Windows Server (R) 2008 Standard" connErrors="0" physMem="16775704.0">

<cpu description="Intel(R) Xeon(R) CPU E5620 @ 2.40GHz" cores="4" clockSpeed="2,40" />

<cpu description="Intel(R) Xeon(R) CPU E5620 @ 2.40GHz" cores="4" clockSpeed="2,40" />

<app name="Cobian Backup 10" />

<app name="FileZilla Client 3.5.3" version="3.5.3" />

<app name="Impresa" version="7.4.0" />

<app name="Runtime Crystal Report 11.5" version="1.00.0000" />

<app name="Livecare Internet Agent" version="9.30.01" />

<app name="Microsoft Report Viewer Redistributable 2008 SP1" />

<app name="Microsoft Report Viewer Redistributable 2008 SP1 Language Pack - ITA" />

<app name="WinRAR 4.20 (32-bit)" version="4.20.0" />

<app name="VMware vSphere Client 5.0" version="5.0.0.16964" />

<app name="Microsoft Visual C++ 2008 Redistributable - x86 9.0.30729.4148" version="9.0.30729.4148" />

<app name="Microsoft SQL Server Browser" version="10.50.1600.1" />

<app name="Microsoft Visual Studio Tools for Applications 2.0 Language Pack - ITA" version="9.0.35191" />

<app name="Hotfix per Microsoft Visual Studio 2007 Tools for Applications - ENU (KB947789)" version="1" />

<app name="LogMeIn" version="4.1.2138" />

<app name="Documentazione online di Microsoft SQL Server 2008 R2" version="10.50.1600.1" />

<app name="Microsoft Visual Studio Tools for Applications 2.0 - ENU" version="9.0.35191" />

<app name="Hotfix for Microsoft Visual Studio 2007 Tools for Applications - ENU (KB946040)" version="1" />

<app name="Hotfix for Microsoft Visual Studio 2007 Tools for Applications - ENU (KB946308)" version="1" />

<app name="Hotfix for Microsoft Visual Studio 2007 Tools for Applications - ENU (KB946344)" version="1" />

<app name="Hotfix for Microsoft Visual Studio 2007 Tools for Applications - ENU (KB947540)" version="1" />

<app name="Hotfix for Microsoft Visual Studio 2007 Tools for Applications - ENU (KB947789)" version="1" />

<app name="Microsoft Report Viewer Redistributable 2008 SP1 Language Pack - ITA" version="9.0.30729" />

<app name="Impresa" version="7.4.0" />

<app name="Runtime Crystal Report 11.5" version="1.00.0000" />

<app name="Microsoft Visual C++ 2005 Redistributable" version="8.0.59193" />

<app name="MSXML 4.0 SP2 (KB954430)" version="4.20.9870.0" />

<app name="Criteri di Microsoft SQL Server 2008 R2" version="10.50.1600.1" />

<app name="Microsoft SQL Server Compact 3.5 SP2 Query Tools ITA" version="3.5.8080.0" />

<app name="Microsoft SQL Server Compact 3.5 SP2 ITA" version="3.5.8080.0" />

<app name="Security Update for Microsoft .NET Framework 3.5 SP1 (KB2604111)" version="1" />

<app name="Security Update for Microsoft .NET Framework 3.5 SP1 (KB2657424)" version="1" />

<app name="Hotfix for Microsoft .NET Framework 3.5 SP1 (KB953595)" version="1" />

<app name="Hotfix for Microsoft .NET Framework 3.5 SP1 (KB958484)" version="1" />

<app name="Update for Microsoft .NET Framework 3.5 SP1 (KB963707)" version="1" />

<app name="Microsoft Report Viewer Redistributable 2008 (KB971119)" version="9.0.30731" />

<app name="MSXML 4.0 SP2 (KB973688)" version="4.20.9876.0" />

<app name="Trilead VM Explorer" version="4.1.020.0" />

</machine>

</machines>

- <devices>

<device name="0 C:" machineID="0" id="2" blockSize="512" blocks="293601280" blocksFree="78370104" blocksUsed="215231176" clusterId="3" scrubs="0" />

</devices>

- <entries>

<macentry machine="0" freeMem="4865880.7" cpu="13.3" max="100.0" ts="635037769404700000" />

<entry dev="2" ri="0.6" wi="2.7" rbps="10.3" wbps="32.3" rz="17.5" wz="12.0" rl="6.5" wl="11.0" qd="0.0" ts="635037769404700000" />

<macentry machine="0" freeMem="4869493.3" cpu="12.8" max="100.0" ts="635037770604930000" />

<entry dev="2" ri="1.0" wi="2.3" rbps="21.4" wbps="35.8" rz="21.9" wz="15.7" rl="4.2" wl="2.0" qd="0.0" ts="635037770604930000" />

<macentry machine="0" freeMem="4872089.7" cpu="3.9" max="100.0" ts="635037771804930000" />

<entry dev="2" ri="2.3" wi="24.8" rbps="279.3" wbps="651.7" rz="120.1" wz="26.2" rl="3.3" wl="24.8" qd="0.0" ts="635037771804930000" />

<macentry machine="0" freeMem="4871711.3" cpu="9.8" max="100.0" ts="635037773004930000" />

<entry dev="2" ri="6.6" wi="7.5" rbps="791.8" wbps="809.9" rz="120.3" wz="108.2" rl="4.9" wl="8.3" qd="0.0" ts="635037773004930000" />

<macentry machine="0" freeMem="4872399.0" cpu="10.7" max="100.0" ts="635037774204930000" />

<entry dev="2" ri="0.6" wi="1.4" rbps="9.7" wbps="18.5" rz="16.0" wz="13.3" rl="6.6" wl="0.7" qd="0.0" ts="635037774204930000" />

<macentry machine="0" freeMem="4872316.7" cpu="4.0" max="100.0" ts="635037775404930000" />

<entry dev="2" ri="0.6" wi="2.1" rbps="61.1" wbps="87.7" rz="106.3" wz="42.2" rl="4.0" wl="2.2" qd="0.0" ts="635037775404930000" />

<macentry machine="0" freeMem="4869230.7" cpu="4.6" max="100.0" ts="635037776604930000" />

<entry dev="2" ri="0.2" wi="1.9" rbps="4.0" wbps="17.9" rz="16.0" wz="9.4" rl="5.0" wl="1.8" qd="0.0" ts="635037776604930000" />

<macentry machine="0" freeMem="4872536.3" cpu="4.8" max="100.0" ts="635037777804930000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.0" wbps="8.8" rz="0.0" wz="8.5" rl="0.0" wl="1.2" qd="0.0" ts="635037777804930000" />

<macentry machine="0" freeMem="4874477.7" cpu="0.1" max="100.0" ts="635037779004930000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.0" wbps="8.6" rz="0.0" wz="9.0" rl="0.0" wl="1.2" qd="0.0" ts="635037779004930000" />

<macentry machine="0" freeMem="4872615.3" cpu="0.5" max="100.0" ts="635037780204930000" />

<entry dev="2" ri="0.0" wi="3.2" rbps="0.1" wbps="32.3" rz="8.0" wz="9.9" rl="5.9" wl="2.9" qd="0.0" ts="635037780204930000" />

<macentry machine="0" freeMem="4867129.3" cpu="0.9" max="100.0" ts="635037781404930000" />

<entry dev="2" ri="0.1" wi="1.0" rbps="2.1" wbps="9.9" rz="16.0" wz="9.6" rl="5.5" wl="1.1" qd="0.0" ts="635037781404930000" />

<macentry machine="0" freeMem="4868159.3" cpu="0.8" max="100.0" ts="635037782604930000" />

<entry dev="2" ri="0.0" wi="0.9" rbps="0.0" wbps="8.6" rz="0.0" wz="9.1" rl="0.0" wl="1.2" qd="0.0" ts="635037782604930000" />

<macentry machine="0" freeMem="4858403.0" cpu="0.3" max="100.0" ts="635037783804930000" />

<entry dev="2" ri="0.5" wi="2.0" rbps="15.9" wbps="17.5" rz="34.8" wz="8.8" rl="3.3" wl="1.5" qd="0.0" ts="635037783804930000" />

<macentry machine="0" freeMem="4857815.3" cpu="1.1" max="100.0" ts="635037785004930000" />

<entry dev="2" ri="0.0" wi="1.4" rbps="0.5" wbps="12.4" rz="16.0" wz="8.7" rl="3.9" wl="1.5" qd="0.0" ts="635037785004930000" />

<macentry machine="0" freeMem="4860910.7" cpu="2.5" max="100.0" ts="635037786204930000" />

<entry dev="2" ri="1.9" wi="3.4" rbps="158.4" wbps="164.5" rz="81.6" wz="48.6" rl="14.2" wl="8.5" qd="0.0" ts="635037786204930000" />

<macentry machine="0" freeMem="4864641.7" cpu="8.5" max="100.0" ts="635037787404930000" />

<entry dev="2" ri="2.4" wi="1.4" rbps="212.1" wbps="45.1" rz="89.0" wz="31.9" rl="12.2" wl="3.4" qd="0.0" ts="635037787404930000" />

<macentry machine="0" freeMem="4863593.7" cpu="11.6" max="100.0" ts="635037788604930000" />

<entry dev="2" ri="0.9" wi="2.3" rbps="94.3" wbps="119.1" rz="105.7" wz="52.5" rl="4.0" wl="3.0" qd="0.0" ts="635037788604930000" />

<macentry machine="0" freeMem="4862689.7" cpu="4.4" max="100.0" ts="635037789804930000" />

<entry dev="2" ri="0.4" wi="2.0" rbps="6.4" wbps="33.6" rz="16.0" wz="16.9" rl="4.9" wl="1.2" qd="0.0" ts="635037789804930000" />

<macentry machine="0" freeMem="4864328.0" cpu="1.3" max="100.0" ts="635037791004930000" />

<entry dev="2" ri="1.1" wi="2.7" rbps="146.1" wbps="161.2" rz="128.0" wz="59.5" rl="18.1" wl="9.0" qd="0.0" ts="635037791004930000" />

<macentry machine="0" freeMem="4863458.7" cpu="4.0" max="100.0" ts="635037792204930000" />

<entry dev="2" ri="1.3" wi="2.6" rbps="147.7" wbps="160.1" rz="117.4" wz="60.4" rl="14.2" wl="25.2" qd="0.0" ts="635037792204930000" />

<macentry machine="0" freeMem="4868568.0" cpu="5.3" max="100.0" ts="635037793404930000" />

<entry dev="2" ri="0.4" wi="2.7" rbps="14.3" wbps="24.8" rz="37.4" wz="9.3" rl="3.9" wl="5.8" qd="0.0" ts="635037793404930000" />

<macentry machine="0" freeMem="4870266.0" cpu="5.1" max="100.0" ts="635037794604950000" />

<entry dev="2" ri="0.6" wi="1.1" rbps="10.1" wbps="24.6" rz="16.0" wz="22.7" rl="4.5" wl="1.3" qd="0.0" ts="635037794604950000" />

<macentry machine="0" freeMem="4871697.7" cpu="0.7" max="100.0" ts="635037795804950000" />

<entry dev="2" ri="0.1" wi="1.3" rbps="1.2" wbps="10.3" rz="16.0" wz="7.8" rl="4.8" wl="2.6" qd="0.0" ts="635037795804950000" />

<macentry machine="0" freeMem="4871168.3" cpu="2.6" max="100.0" ts="635037797004950000" />

<entry dev="2" ri="0.1" wi="1.0" rbps="8.9" wbps="17.3" rz="89.3" wz="17.5" rl="5.9" wl="3.6" qd="0.0" ts="635037797004950000" />

<macentry machine="0" freeMem="4870760.3" cpu="7.5" max="100.0" ts="635037798204950000" />

<entry dev="2" ri="0.2" wi="1.2" rbps="17.6" wbps="36.3" rz="100.6" wz="29.1" rl="5.0" wl="1.5" qd="0.0" ts="635037798204950000" />

<macentry machine="0" freeMem="4869398.7" cpu="11.2" max="100.0" ts="635037799404950000" />

<entry dev="2" ri="1.2" wi="2.5" rbps="130.9" wbps="141.7" rz="109.1" wz="57.1" rl="10.0" wl="14.5" qd="0.0" ts="635037799404950000" />

<macentry machine="0" freeMem="4863834.0" cpu="9.7" max="100.0" ts="635037800604950000" />

<entry dev="2" ri="1.9" wi="2.6" rbps="124.7" wbps="130.3" rz="64.5" wz="50.9" rl="5.6" wl="5.7" qd="0.0" ts="635037800604950000" />

<macentry machine="0" freeMem="4856161.3" cpu="1.7" max="100.0" ts="635037801804950000" />

<entry dev="2" ri="0.0" wi="1.6" rbps="1.2" wbps="11.2" rz="24.0" wz="7.0" rl="7.7" wl="1.7" qd="0.0" ts="635037801804950000" />

<macentry machine="0" freeMem="4856336.3" cpu="4.5" max="100.0" ts="635037803004950000" />

<entry dev="2" ri="0.3" wi="2.1" rbps="41.1" wbps="83.5" rz="117.3" wz="39.5" rl="10.7" wl="8.3" qd="0.0" ts="635037803004950000" />

<macentry machine="0" freeMem="4856386.7" cpu="12.1" max="100.0" ts="635037804204950000" />

<entry dev="2" ri="0.8" wi="21.9" rbps="12.8" wbps="454.4" rz="16.0" wz="20.8" rl="4.3" wl="33.6" qd="0.0" ts="635037804204950000" />

<macentry machine="0" freeMem="4853804.0" cpu="13.3" max="100.0" ts="635037805404950000" />

<entry dev="2" ri="0.6" wi="1.9" rbps="44.8" wbps="71.9" rz="75.7" wz="38.3" rl="9.3" wl="5.8" qd="0.0" ts="635037805404950000" />

<macentry machine="0" freeMem="4853325.7" cpu="1.1" max="100.0" ts="635037806604960000" />

<entry dev="2" ri="0.5" wi="1.6" rbps="58.8" wbps="67.3" rz="110.2" wz="43.2" rl="7.0" wl="7.0" qd="0.0" ts="635037806604960000" />

<macentry machine="0" freeMem="4852479.3" cpu="12.2" max="100.0" ts="635037807804950000" />

<entry dev="2" ri="0.5" wi="2.0" rbps="44.0" wbps="54.6" rz="82.5" wz="27.9" rl="7.3" wl="4.5" qd="0.0" ts="635037807804950000" />

<macentry machine="0" freeMem="4851854.7" cpu="3.6" max="100.0" ts="635037809004950000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.0" wbps="8.8" rz="0.0" wz="8.8" rl="0.0" wl="1.5" qd="0.0" ts="635037809004950000" />

<macentry machine="0" freeMem="4854199.0" cpu="12.6" max="100.0" ts="635037810204950000" />

<entry dev="2" ri="4.3" wi="2.1" rbps="69.7" wbps="28.3" rz="16.1" wz="13.4" rl="18.9" wl="1.6" qd="0.0" ts="635037810204950000" />

<macentry machine="0" freeMem="4831907.3" cpu="7.7" max="100.0" ts="635037811404950000" />

<entry dev="2" ri="1.5" wi="2.1" rbps="67.6" wbps="65.3" rz="45.8" wz="31.1" rl="6.7" wl="5.3" qd="0.0" ts="635037811404950000" />

<macentry machine="0" freeMem="4818288.7" cpu="1.0" max="100.0" ts="635037812604950000" />

<entry dev="2" ri="0.2" wi="1.4" rbps="3.2" wbps="12.7" rz="17.5" wz="9.0" rl="4.6" wl="2.2" qd="0.0" ts="635037812604950000" />

<macentry machine="0" freeMem="4819321.0" cpu="4.9" max="100.0" ts="635037813804950000" />

<entry dev="2" ri="0.4" wi="1.4" rbps="6.9" wbps="21.7" rz="16.0" wz="15.5" rl="4.8" wl="5.5" qd="0.0" ts="635037813804950000" />

<macentry machine="0" freeMem="4821205.0" cpu="0.7" max="100.0" ts="635037815004950000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.7" wbps="8.7" rz="20.0" wz="9.0" rl="8.2" wl="2.6" qd="0.0" ts="635037815004950000" />

<macentry machine="0" freeMem="4822383.0" cpu="0.3" max="100.0" ts="635037816204950000" />

<entry dev="2" ri="0.0" wi="0.9" rbps="0.0" wbps="7.9" rz="0.0" wz="9.1" rl="0.0" wl="1.1" qd="0.0" ts="635037816204950000" />

<macentry machine="0" freeMem="4817137.0" cpu="0.9" max="100.0" ts="635037817404950000" />

<entry dev="2" ri="0.4" wi="2.0" rbps="6.0" wbps="24.6" rz="16.0" wz="12.0" rl="4.5" wl="1.5" qd="0.0" ts="635037817404950000" />

<macentry machine="0" freeMem="4813027.0" cpu="1.5" max="100.0" ts="635037818604950000" />

<entry dev="2" ri="0.1" wi="1.0" rbps="2.1" wbps="9.8" rz="25.6" wz="10.1" rl="9.0" wl="1.6" qd="0.0" ts="635037818604950000" />

<macentry machine="0" freeMem="4813705.3" cpu="0.9" max="100.0" ts="635037819804950000" />

<entry dev="2" ri="0.0" wi="1.5" rbps="0.1" wbps="10.5" rz="16.0" wz="7.0" rl="4.7" wl="1.5" qd="0.0" ts="635037819804950000" />

<macentry machine="0" freeMem="4813085.7" cpu="6.3" max="100.0" ts="635037821004950000" />

<entry dev="2" ri="0.5" wi="2.3" rbps="7.9" wbps="87.3" rz="16.0" wz="37.6" rl="4.8" wl="1.2" qd="0.0" ts="635037821004950000" />

<macentry machine="0" freeMem="4812997.0" cpu="3.3" max="100.0" ts="635037822204950000" />

<entry dev="2" ri="0.2" wi="16.5" rbps="12.7" wbps="385.1" rz="54.3" wz="23.3" rl="4.3" wl="27.9" qd="0.0" ts="635037822204950000" />

<macentry machine="0" freeMem="4818138.3" cpu="7.6" max="100.0" ts="635037823404950000" />

<entry dev="2" ri="4.5" wi="2.2" rbps="772.2" wbps="32.8" rz="172.9" wz="15.1" rl="3.9" wl="1.6" qd="0.2" ts="635037823404950000" />

<macentry machine="0" freeMem="4817545.3" cpu="8.1" max="100.0" ts="635037824604950000" />

<entry dev="2" ri="0.6" wi="3.3" rbps="44.6" wbps="179.2" rz="77.5" wz="54.6" rl="6.8" wl="8.2" qd="0.0" ts="635037824604950000" />

<macentry machine="0" freeMem="4813552.7" cpu="1.2" max="100.0" ts="635037825804950000" />

<entry dev="2" ri="0.0" wi="1.7" rbps="0.5" wbps="71.6" rz="64.0" wz="41.7" rl="4.1" wl="1.2" qd="0.0" ts="635037825804950000" />

<macentry machine="0" freeMem="4814343.3" cpu="2.1" max="100.0" ts="635037827004950000" />

<entry dev="2" ri="0.1" wi="1.6" rbps="1.9" wbps="25.9" rz="16.0" wz="16.0" rl="9.1" wl="0.9" qd="0.0" ts="635037827004950000" />

<macentry machine="0" freeMem="4822455.3" cpu="10.1" max="100.0" ts="635037828204950000" />

<entry dev="2" ri="0.4" wi="1.8" rbps="42.0" wbps="60.3" rz="102.9" wz="33.2" rl="15.0" wl="12.1" qd="0.0" ts="635037828204950000" />

<macentry machine="0" freeMem="4826639.0" cpu="11.5" max="100.0" ts="635037829404960000" />

<entry dev="2" ri="0.2" wi="1.6" rbps="4.0" wbps="20.9" rz="17.8" wz="13.2" rl="6.9" wl="3.9" qd="0.0" ts="635037829404960000" />

<macentry machine="0" freeMem="4826349.0" cpu="11.4" max="100.0" ts="635037830606910000" />

<entry dev="2" ri="0.6" wi="1.6" rbps="46.3" wbps="64.7" rz="78.3" wz="41.1" rl="13.8" wl="13.7" qd="0.0" ts="635037830606910000" />

<macentry machine="0" freeMem="4817349.0" cpu="6.6" max="100.0" ts="635037831810720000" />

<entry dev="2" ri="0.1" wi="19.8" rbps="1.9" wbps="455.3" rz="16.0" wz="23.0" rl="9.7" wl="34.5" qd="0.1" ts="635037831810720000" />

<macentry machine="0" freeMem="4818791.3" cpu="4.5" max="100.0" ts="635037833014080000" />

<entry dev="2" ri="0.0" wi="1.7" rbps="0.3" wbps="34.3" rz="16.0" wz="20.1" rl="5.0" wl="1.6" qd="0.0" ts="635037833014080000" />

<macentry machine="0" freeMem="4818769.7" cpu="3.0" max="100.0" ts="635037834217380000" />

<entry dev="2" ri="6.6" wi="2.6" rbps="266.3" wbps="161.0" rz="40.1" wz="60.8" rl="7.5" wl="26.0" qd="0.0" ts="635037834217380000" />

<macentry machine="0" freeMem="4810846.7" cpu="1.4" max="100.0" ts="635037835418940000" />

<entry dev="2" ri="4.5" wi="1.7" rbps="79.1" wbps="17.8" rz="17.5" wz="10.6" rl="3.5" wl="1.7" qd="0.0" ts="635037835418940000" />

<macentry machine="0" freeMem="4811903.3" cpu="1.1" max="100.0" ts="635037836620500000" />

<entry dev="2" ri="0.1" wi="0.9" rbps="1.1" wbps="9.5" rz="16.0" wz="10.3" rl="5.3" wl="1.6" qd="0.0" ts="635037836620500000" />

<macentry machine="0" freeMem="4812363.0" cpu="0.8" max="100.0" ts="635037837821670000" />

<entry dev="2" ri="0.2" wi="1.0" rbps="3.7" wbps="9.7" rz="16.0" wz="9.5" rl="7.0" wl="3.9" qd="0.0" ts="635037837821670000" />

<macentry machine="0" freeMem="4811969.0" cpu="0.6" max="100.0" ts="635037839022970000" />

<entry dev="2" ri="0.1" wi="1.6" rbps="0.9" wbps="12.1" rz="16.0" wz="7.4" rl="11.5" wl="7.0" qd="0.0" ts="635037839022970000" />

<macentry machine="0" freeMem="4812145.7" cpu="0.6" max="100.0" ts="635037840223810000" />

<entry dev="2" ri="0.2" wi="1.9" rbps="2.7" wbps="20.1" rz="16.0" wz="10.3" rl="6.3" wl="7.5" qd="0.0" ts="635037840223810000" />

<macentry machine="0" freeMem="4804754.3" cpu="0.7" max="100.0" ts="635037841423410000" />

<entry dev="2" ri="0.6" wi="1.4" rbps="9.5" wbps="9.1" rz="16.0" wz="6.7" rl="6.8" wl="6.7" qd="0.0" ts="635037841423410000" />

<macentry machine="0" freeMem="4804321.3" cpu="0.5" max="100.0" ts="635037842622930000" />

<entry dev="2" ri="0.2" wi="0.9" rbps="2.8" wbps="8.2" rz="16.0" wz="8.8" rl="5.2" wl="2.2" qd="0.0" ts="635037842622930000" />

<macentry machine="0" freeMem="4804320.0" cpu="0.9" max="100.0" ts="635037843822710000" />

<entry dev="2" ri="0.0" wi="0.9" rbps="0.3" wbps="8.0" rz="16.0" wz="9.1" rl="14.2" wl="4.9" qd="0.0" ts="635037843822710000" />

<macentry machine="0" freeMem="4804489.7" cpu="1.2" max="100.0" ts="635037845022830000" />

<entry dev="2" ri="0.0" wi="1.5" rbps="0.3" wbps="13.0" rz="16.0" wz="8.5" rl="10.8" wl="2.7" qd="0.0" ts="635037845022830000" />

<macentry machine="0" freeMem="4804601.3" cpu="1.5" max="100.0" ts="635037846222950000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.3" wbps="10.9" rz="16.0" wz="10.6" rl="5.6" wl="1.0" qd="0.0" ts="635037846222950000" />

<macentry machine="0" freeMem="4803627.3" cpu="1.3" max="100.0" ts="635037847423180000" />

<entry dev="2" ri="0.0" wi="2.1" rbps="0.0" wbps="19.0" rz="0.0" wz="9.2" rl="0.0" wl="2.1" qd="0.0" ts="635037847423180000" />

<macentry machine="0" freeMem="4801557.0" cpu="3.6" max="100.0" ts="635037848623420000" />

<entry dev="2" ri="0.1" wi="2.0" rbps="1.2" wbps="110.1" rz="16.0" wz="54.8" rl="4.2" wl="1.6" qd="0.0" ts="635037848623420000" />

<macentry machine="0" freeMem="4802626.7" cpu="2.3" max="100.0" ts="635037849823710000" />

<entry dev="2" ri="0.0" wi="16.3" rbps="0.3" wbps="366.6" rz="16.0" wz="22.5" rl="5.4" wl="35.8" qd="0.0" ts="635037849823710000" />

<macentry machine="0" freeMem="4804134.0" cpu="1.1" max="100.0" ts="635037851024070000" />

<entry dev="2" ri="0.1" wi="1.4" rbps="1.6" wbps="11.0" rz="16.0" wz="8.0" rl="4.8" wl="1.1" qd="0.0" ts="635037851024070000" />

<macentry machine="0" freeMem="4805080.7" cpu="0.6" max="100.0" ts="635037852224430000" />

<entry dev="2" ri="0.0" wi="0.9" rbps="0.0" wbps="8.1" rz="0.0" wz="8.9" rl="0.0" wl="1.6" qd="0.0" ts="635037852224430000" />

<macentry machine="0" freeMem="4805856.3" cpu="2.9" max="100.0" ts="635037853424790000" />

<entry dev="2" ri="0.4" wi="2.3" rbps="39.7" wbps="166.2" rz="103.7" wz="71.0" rl="5.3" wl="7.4" qd="0.0" ts="635037853424790000" />

<macentry machine="0" freeMem="4806941.3" cpu="0.7" max="100.0" ts="635037854625160000" />

<entry dev="2" ri="0.1" wi="1.2" rbps="2.3" wbps="8.7" rz="16.0" wz="7.1" rl="4.1" wl="1.4" qd="0.0" ts="635037854625160000" />

<macentry machine="0" freeMem="4800152.0" cpu="0.7" max="100.0" ts="635037855825520000" />

<entry dev="2" ri="0.0" wi="0.9" rbps="0.3" wbps="7.7" rz="16.0" wz="8.3" rl="6.0" wl="1.4" qd="0.0" ts="635037855825520000" />

<macentry machine="0" freeMem="4764333.7" cpu="4.6" max="100.0" ts="635037857025880000" />

<entry dev="2" ri="0.2" wi="1.4" rbps="3.6" wbps="10.0" rz="16.0" wz="7.0" rl="7.0" wl="1.0" qd="0.0" ts="635037857025880000" />

<macentry machine="0" freeMem="4763563.3" cpu="3.0" max="100.0" ts="635037858226240000" />

<entry dev="2" ri="0.4" wi="1.0" rbps="5.7" wbps="11.9" rz="16.0" wz="11.5" rl="4.2" wl="1.1" qd="0.0" ts="635037858226240000" />

<macentry machine="0" freeMem="4769935.7" cpu="1.6" max="100.0" ts="635037859426600000" />

<entry dev="2" ri="8.0" wi="4.5" rbps="254.3" wbps="50.8" rz="31.7" wz="11.3" rl="2.7" wl="4.6" qd="0.0" ts="635037859426600000" />

<macentry machine="0" freeMem="4753778.0" cpu="3.2" max="100.0" ts="635037860626960000" />

<entry dev="2" ri="0.0" wi="2.6" rbps="1.7" wbps="116.6" rz="34.7" wz="45.6" rl="2.8" wl="1.4" qd="0.0" ts="635037860626960000" />

<macentry machine="0" freeMem="4751088.3" cpu="0.4" max="100.0" ts="635037861825930000" />

<entry dev="2" ri="0.0" wi="0.9" rbps="0.4" wbps="8.2" rz="16.0" wz="8.8" rl="9.5" wl="2.5" qd="0.0" ts="635037861825930000" />

<macentry machine="0" freeMem="4751720.0" cpu="0.8" max="100.0" ts="635037863024370000" />

<entry dev="2" ri="0.2" wi="1.4" rbps="3.2" wbps="9.6" rz="16.0" wz="7.0" rl="5.6" wl="5.4" qd="0.0" ts="635037863024370000" />

<macentry machine="0" freeMem="4752268.0" cpu="0.4" max="100.0" ts="635037864223080000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.0" wbps="7.7" rz="0.0" wz="8.1" rl="0.0" wl="3.2" qd="0.0" ts="635037864223080000" />

<macentry machine="0" freeMem="4751824.3" cpu="0.3" max="100.0" ts="635037865422720000" />

<entry dev="2" ri="0.0" wi="0.8" rbps="0.5" wbps="7.3" rz="56.0" wz="8.7" rl="4.4" wl="2.1" qd="0.0" ts="635037865422720000" />

<macentry machine="0" freeMem="4749364.0" cpu="0.5" max="100.0" ts="635037866622360000" />

<entry dev="2" ri="3.7" wi="14.4" rbps="116.8" wbps="298.7" rz="31.7" wz="20.8" rl="10.0" wl="827.1" qd="2.8" ts="635037866622360000" />

<macentry machine="0" freeMem="14949109.3" cpu="1.2" max="100.0" ts="635037867822260000" />

<entry dev="2" ri="34.1" wi="16.2" rbps="678.0" wbps="417.7" rz="19.9" wz="25.8" rl="8.1" wl="313.0" qd="4.9" ts="635037867822260000" />

<macentry machine="0" freeMem="14938644.0" cpu="0.3" max="100.0" ts="635037869022260000" />

<entry dev="2" ri="0.1" wi="1.1" rbps="1.7" wbps="10.0" rz="16.0" wz="9.0" rl="3.7" wl="1.1" qd="0.0" ts="635037869022260000" />

<macentry machine="0" freeMem="14906677.3" cpu="0.6" max="100.0" ts="635037870222310000" />

<entry dev="2" ri="13.0" wi="2.6" rbps="1297.4" wbps="26.2" rz="100.1" wz="10.1" rl="12.4" wl="1.2" qd="0.0" ts="635037870222310000" />

<macentry machine="0" freeMem="14837312.3" cpu="0.2" max="100.0" ts="635037871422420000" />

<entry dev="2" ri="0.0" wi="0.9" rbps="0.7" wbps="8.7" rz="16.0" wz="9.3" rl="6.6" wl="1.4" qd="0.0" ts="635037871422420000" />

<macentry machine="0" freeMem="14829286.0" cpu="0.2" max="100.0" ts="635037872621940000" />

<entry dev="2" ri="1.6" wi="1.3" rbps="25.6" wbps="9.8" rz="16.0" wz="7.6" rl="4.0" wl="1.7" qd="0.0" ts="635037872621940000" />

<macentry machine="0" freeMem="14818583.7" cpu="0.4" max="100.0" ts="635037873821460000" />

<entry dev="2" ri="0.1" wi="1.5" rbps="2.3" wbps="13.8" rz="16.0" wz="9.2" rl="4.6" wl="2.5" qd="0.0" ts="635037873821460000" />

<macentry machine="0" freeMem="14808204.7" cpu="0.5" max="100.0" ts="635037875021310000" />

<entry dev="2" ri="4.3" wi="1.3" rbps="69.5" wbps="11.4" rz="16.1" wz="9.0" rl="3.3" wl="1.3" qd="0.0" ts="635037875021310000" />

<macentry machine="0" freeMem="14798320.0" cpu="0.1" max="100.0" ts="635037876221310000" />

<entry dev="2" ri="3.7" wi="1.8" rbps="47.2" wbps="13.8" rz="12.8" wz="7.5" rl="6.2" wl="1.3" qd="0.0" ts="635037876221310000" />

<macentry machine="0" freeMem="14798573.3" cpu="0.2" max="100.0" ts="635037877421330000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.0" wbps="9.1" rz="0.0" wz="9.2" rl="0.0" wl="1.1" qd="0.0" ts="635037877421330000" />

<macentry machine="0" freeMem="14694290.0" cpu="4.6" max="100.0" ts="635037878621450000" />

<entry dev="2" ri="6.2" wi="5.8" rbps="280.4" wbps="55.5" rz="45.2" wz="9.6" rl="3.3" wl="2.0" qd="0.0" ts="635037878621450000" />

<macentry machine="0" freeMem="14769599.0" cpu="0.2" max="100.0" ts="635037879821570000" />

<entry dev="2" ri="0.0" wi="1.5" rbps="0.1" wbps="13.1" rz="16.0" wz="8.6" rl="3.1" wl="1.7" qd="0.0" ts="635037879821570000" />

<macentry machine="0" freeMem="14770101.0" cpu="0.2" max="100.0" ts="635037881021770000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.0" wbps="9.0" rz="0.0" wz="8.7" rl="0.0" wl="1.0" qd="0.0" ts="635037881021770000" />

<macentry machine="0" freeMem="14770925.3" cpu="0.1" max="100.0" ts="635037882221540000" />

<entry dev="2" ri="0.0" wi="1.6" rbps="0.0" wbps="11.2" rz="0.0" wz="7.1" rl="0.0" wl="1.4" qd="0.0" ts="635037882221540000" />

<macentry machine="0" freeMem="14771274.0" cpu="0.2" max="100.0" ts="635037883421060000" />

<entry dev="2" ri="0.0" wi="1.4" rbps="2.3" wbps="12.6" rz="54.4" wz="8.7" rl="6.1" wl="1.5" qd="0.0" ts="635037883421060000" />

<macentry machine="0" freeMem="14768851.3" cpu="0.2" max="100.0" ts="635037884620640000" />

<entry dev="2" ri="0.0" wi="1.2" rbps="0.0" wbps="10.7" rz="0.0" wz="8.9" rl="0.0" wl="1.2" qd="0.0" ts="635037884620640000" />

<macentry machine="0" freeMem="14769123.3" cpu="0.2" max="100.0" ts="635037885820520000" />

<entry dev="2" ri="0.1" wi="1.5" rbps="1.5" wbps="14.8" rz="16.0" wz="9.6" rl="3.6" wl="1.5" qd="0.0" ts="635037885820520000" />

<macentry machine="0" freeMem="14770575.7" cpu="0.2" max="100.0" ts="635037887020400000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.0" wbps="9.2" rz="0.0" wz="9.3" rl="0.0" wl="1.1" qd="0.0" ts="635037887020400000" />

<macentry machine="0" freeMem="14771891.7" cpu="0.1" max="100.0" ts="635037888220430000" />

<entry dev="2" ri="0.0" wi="1.3" rbps="0.0" wbps="9.7" rz="0.0" wz="7.4" rl="0.0" wl="1.1" qd="0.0" ts="635037888220430000" />

<macentry machine="0" freeMem="14812204.0" cpu="0.3" max="100.0" ts="635037889420550000" />

<entry dev="2" ri="0.0" wi="1.7" rbps="0.0" wbps="15.5" rz="0.0" wz="9.0" rl="0.0" wl="2.3" qd="0.0" ts="635037889420550000" />

<macentry machine="0" freeMem="14823687.7" cpu="0.2" max="100.0" ts="635037890620670000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.8" wbps="9.1" rz="16.0" wz="8.6" rl="4.1" wl="1.1" qd="0.0" ts="635037890620670000" />

<macentry machine="0" freeMem="14817718.7" cpu="0.5" max="100.0" ts="635037891820670000" />

<entry dev="2" ri="0.9" wi="1.4" rbps="66.3" wbps="10.5" rz="75.7" wz="7.6" rl="4.5" wl="1.0" qd="0.0" ts="635037891820670000" />

<macentry machine="0" freeMem="14815742.7" cpu="0.3" max="100.0" ts="635037893020310000" />

<entry dev="2" ri="0.1" wi="1.2" rbps="1.6" wbps="9.1" rz="16.0" wz="7.8" rl="3.7" wl="1.0" qd="0.0" ts="635037893020310000" />

<macentry machine="0" freeMem="14813337.7" cpu="0.5" max="100.0" ts="635037894219950000" />

<entry dev="2" ri="10.3" wi="132.6" rbps="1313.8" wbps="1385.3" rz="127.3" wz="10.4" rl="1.8" wl="0.2" qd="0.8" ts="635037894219950000" />

<macentry machine="0" freeMem="14757552.3" cpu="0.7" max="100.0" ts="635037895419770000" />

<entry dev="2" ri="101.7" wi="87.2" rbps="2284.8" wbps="745.8" rz="22.5" wz="8.6" rl="3.1" wl="1.0" qd="0.5" ts="635037895419770000" />

<macentry machine="0" freeMem="14680199.0" cpu="0.2" max="100.0" ts="635037896619650000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.4" wbps="9.4" rz="16.0" wz="9.2" rl="5.9" wl="1.5" qd="0.0" ts="635037896619650000" />

<macentry machine="0" freeMem="14626225.7" cpu="1.2" max="100.0" ts="635037897819560000" />

<entry dev="2" ri="10.0" wi="1.5" rbps="686.1" wbps="26.8" rz="68.4" wz="17.8" rl="7.1" wl="2.4" qd="0.0" ts="635037897819560000" />

<macentry machine="0" freeMem="14474782.7" cpu="0.5" max="100.0" ts="635037899019560000" />

<entry dev="2" ri="0.8" wi="1.0" rbps="18.5" wbps="12.9" rz="23.2" wz="12.4" rl="4.6" wl="1.3" qd="0.0" ts="635037899019560000" />

<macentry machine="0" freeMem="14474639.7" cpu="0.2" max="100.0" ts="635037900219560000" />

<entry dev="2" ri="0.0" wi="2.5" rbps="0.0" wbps="26.1" rz="0.0" wz="10.2" rl="0.0" wl="1.4" qd="0.0" ts="635037900219560000" />

<macentry machine="0" freeMem="14418889.0" cpu="0.6" max="100.0" ts="635037901419650000" />

<entry dev="2" ri="4.4" wi="4.0" rbps="189.7" wbps="428.4" rz="43.1" wz="107.8" rl="4.5" wl="9.0" qd="0.0" ts="635037901419650000" />

<macentry machine="0" freeMem="14380823.7" cpu="0.4" max="100.0" ts="635037902619560000" />

<entry dev="2" ri="2.0" wi="1.1" rbps="49.3" wbps="8.8" rz="25.1" wz="8.0" rl="4.0" wl="1.1" qd="0.0" ts="635037902619560000" />

<macentry machine="0" freeMem="14319384.0" cpu="1.4" max="100.0" ts="635037903819320000" />

<entry dev="2" ri="44.9" wi="2.2" rbps="1047.7" wbps="105.8" rz="23.3" wz="48.1" rl="15.9" wl="3.5" qd="18.5" ts="635037903819320000" />

<macentry machine="0" freeMem="14239144.7" cpu="0.3" max="100.0" ts="635037905019100000" />

<entry dev="2" ri="0.0" wi="1.0" rbps="0.0" wbps="9.0" rz="0.0" wz="9.0" rl="0.0" wl="1.7" qd="0.0" ts="635037905019100000" />

<macentry machine="0" freeMem="14219856.7" cpu="0.8" max="100.0" ts="635037906219100000" />

<entry dev="2" ri="2.8" wi="2.1" rbps="52.5" wbps="14.4" rz="19.0" wz="6.7" rl="4.7" wl="5.7" qd="0.0" ts="635037906219100000" />

<macentry machine="0" freeMem="14068241.0" cpu="1.9" max="100.0" ts="635037907419100000" />

<entry dev="2" ri="4.4" wi="1.3" rbps="89.3" wbps="9.4" rz="20.4" wz="7.2" rl="5.0" wl="1.9" qd="0.0" ts="635037907419100000" />

<macentry machine="0" freeMem="14026262.0" cpu="0.8" max="100.0" ts="635037908619100000" />

<entry dev="2" ri="4.3" wi="1.3" rbps="71.9" wbps="13.6" rz="16.8" wz="10.6" rl="4.2" wl="1.4" qd="0.0" ts="635037908619100000" />

<macentry machine="0" freeMem="13778205.3" cpu="5.0" max="100.0" ts="635037909819100000" />

<entry dev="2" ri="30.3" wi="3.1" rbps="588.1" wbps="183.4" rz="19.4" wz="59.8" rl="5.0" wl="1.7" qd="0.2" ts="635037909819100000" />

<macentry machine="0" freeMem="13249323.7" cpu="5.5" max="100.0" ts="635037911019100000" />

<entry dev="2" ri="1.5" wi="1.9" rbps="23.6" wbps="75.1" rz="16.0" wz="39.0" rl="4.7" wl="2.6" qd="0.0" ts="635037911019100000" />

</entries>

</plog>

[Tinto1970]

sulle vcpu: si parte sempre dal minimo (1 o due al massimo) e solo se necessario (il fatto che la macchina sia lenta non vuoldire che le manchino le vcpu) si sale.
Questo perché aggiungere vcpu che non servono non accelera, anzi, può rallentare.

Per i dati: così sono un po' difficili da leggere, basta che lasci girare un po' il dpack -magari in un orario in cui il db lavora molto- e ci posti uno screenshot dove si vedano le IOPS per disco