1

Topic: What at usage in the virtual machine, servers?

ms sql 2008 r2
Resources give the big. But not real and virtual.

2

Re: What at usage in the virtual machine, servers?

The screw works between all tasks of a physical host, therefore its productivity can not suffice you sharply.
Most likely disk array not the superfast.

3

Re: What at usage in the virtual machine, servers?

sparrow wrote:

ms sql 2008 r2
Resources give the big. But not real and virtual.

1. Small performance penalty.
2. Good qualification, differently performance penalty is necessary will be big.
3. To adjust servers and other people (subdividings, the companies) will influence their productivity, and you will be responsible for productivity.

4

Re: What at usage in the virtual machine, servers?

LSV wrote:

the Screw works between all tasks of a physical host, therefore its productivity can not suffice you sharply.
Most likely disk array not the superfast.

Speak there a stand from ssd

5

Re: What at usage in the virtual machine, servers?

alexeyvg wrote:

it is passed...
1. Small performance penalty.
2. Good qualification, differently performance penalty is necessary will be big.
3. To adjust servers and other people (subdividings, the companies) will influence their productivity, and you will be responsible for productivity.

so.

6

Re: What at usage in the virtual machine, servers?

sparrow wrote:

it is passed...
Tell there a stand from ssd

Yes it not very well, there one SATA HDD 5400 or a stand from ssd.
We tell about  VS physical servers at identical loading.
To the physical server with a heap of bases and applications on one screw too it will be bad.
And from the points written by me a real problem is No3
Because remaining problems can be solved, but if there  children from other subdividing, and a unique method of dialogue with them -  addressed to the Principal of the Incorporated Management Date-centers manage, and they answer "and we are fine", then.... :-)

7

Re: What at usage in the virtual machine, servers?

Estimation of real losses from virtualization https://blogs.vmware.com/performance/20 … here6.html
Tests were led with the help http://www.tpc.org/tpcc/
And it is not important that it oracle on vmware

8

Re: What at usage in the virtual machine, servers?

sparrow;

alexeyvg wrote:

2. Good qualification, differently performance penalty is necessary will be big.
3. To adjust servers and other people (subdividings, the companies) will influence their productivity, and you will be responsible for productivity.

Recently faced these problems:
Other subdividing adjusted all as it is necessary, and as a result productivity of the virtual machine on the powerful server is much worse, than at the feeble but real server.
Letters with claims give some months nothing. To understand, how correctly to adjust virtual machines, in other subdividing nobody would like.
Probably, you even will not be responsible in any way for a problem with productivity, but similar situations will not please you.

9

Re: What at usage in the virtual machine, servers?

deku wrote:

an estimation of real losses from virtualization https://blogs.vmware.com/performance/20 … here6.html
Tests were led with the help http://www.tpc.org/tpcc/
And it is not important that it oracle on vmware

Yes, at the correct administration of percent 10, typically enough.
Still from recently appeared - this new patch on  vulnerability - on  often should be put it, and how many it ? Who that speaks about-30 % on the DBMS server :-( Though normally estimations all the same more low.

10

Re: What at usage in the virtual machine, servers?

VMWare  performance penalties approximately 7-13 %, MS 15-20 %, but it provided that all  and only one  if  it is full there losses can be even more.
Plus, depends on adjustments what  will fight for resources for what  what priorities and from an iron infrastructure (its adjustments) - in the most bad cases, all can creep somehow.

11

Re: What at usage in the virtual machine, servers?

alexeyvg wrote:

it is passed...
Yes, at the correct administration of percent 10, typically enough.

There in article on other iron and other version vmware - losses of 30 %
"... With ESXi 5.1, the Order-Entry benchmark throughput of a 64-vCPU VM on a 4-socket, 32 core/64 thread E7 - 4870 (Westmere) server was 70 % of the throughput of the same server in native mode when both servers were running at 77 % CPU utilization (the native server reached a maximum CPU utilization of 88 % and throughput of 54.8 transactions per second)..."

12

Re: What at usage in the virtual machine, servers?

deku wrote:

it is passed...
There in article on other iron and other version vmware - losses of 30 %
"... With ESXi 5.1, the Order-Entry benchmark throughput of a 64-vCPU VM on a 4-socket, 32 core/64 thread E7 - 4870 (Westmere) server was 70 % of the throughput of the same server in native mode when both servers were running at 77 % CPU utilization (the native server reached a maximum CPU utilization of 88 % and throughput of 54.8 transactions per second)..."

the HARDWARE probably meant HyperV
And that on different systems  at different adjustments can be different losses. Though ESXi an effective platform, but here the person compared, HyperV faster... http://xn--80aimpg7h.xn--p1ai/test-sravnenie-virtualizacii-vmware-citrix-xenserver-proxmox-ve-ms-hyper-v-2012r2-3/

13

Re: What at usage in the virtual machine, servers?

sparrow;
If not to follow Best Practices dock from MS results of productivity will be pitiable though on what disks.
Receive, at the best, IO 30mb/with on a kernel.

14

Re: What at usage in the virtual machine, servers?

sparrow;
From practice it   with IO on disks. Though the question can as is spaced apart and life can with more direct hands at administrators is better, but DBA recommend on , all the same to carry out bases on separate physical resources that anybody for them would not fight

15

Re: What at usage in the virtual machine, servers?

TaPaK;
+1. Yes, if productivity is necessary - categorically it is impossible to use virtual disks.

16

Re: What at usage in the virtual machine, servers?

I will add that often forget about restrictions in resources for virtual machines on addressed storage, processors, etc.
Somehow was that managers sang about abrupt virtualization and modes ON and FT and when technicians began to put it appeared that in some modes it is possible to use only 4 kernels that categorically did not arrange.
Therefore reefs always it is possible to dig out.

17

Re: What at usage in the virtual machine, servers?

TaPaK wrote:

sparrow;
From practice it   with IO on disks. Though the question can as is spaced apart and life can with more direct hands at administrators is better, but DBA recommend on , all the same to carry out bases on separate physical resources, what anybody for them would not fight

What unpredictable  if physical disks  in , and at  for support of it are even special command set?
It is clear that about 10 % write, when it is made so.
By the way, some small adjustments of virtual disks, type switch-off of extensibility and background initialization still several times raise high-speed performance, even without  gland.
Yet we do not forget to put special extensions in guest OS which accelerate operation with  iron.
In general, even I, the lamer which that I remember, and good administrators adjust be healthy (by the way, on all my operations only one administrator on my storage adjusted   :-)).
Well and standard, as much as possible cheap, anonymous administrators from the HARDWARE subject will be restricted, of course, to start of the installer and  to the heads "all is ready", there is no time them to be picked for you, tea, not you employed them :-)