SQL Server and Hyper-V resources (incorrect resource allocation/mapping)?

V

Vyacheslav2015-04-23 13:16:28

Monitoring

Vyacheslav, 2015-04-23 13:16:28

Good afternoon colleagues!
I have a question at the junction of Win and SQL servers. There is a virtual machine with Win2008, 1C and SQL server inside Hyper-V Win2012. Users complain about performance problems, Hyper-V cheerfully reports that it has a load of 1-6% on all cores (temperature confirms near-zero loading of physical cores).
The settings set "limit for virtual machines" = 100%.
What did I miss? It seemed to me that if I give 4 cores to the virtual machine and they are 100% loaded - I should see 100% loading of these 4 cores in perfmon on the server ...
(see screenshots for information)

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

L

ldv, 2015-04-23
@ldvldv

https://social.technet.microsoft.com/Forums/system...
blogs.msdn.com/b/virtual_pc_guy/archive/2008/02/28...
Task Manager on host system shows parent partition loading

V

Vyacheslav, 2015-04-23
@HiMem-74

Well, firstly, SQL in a virtual machine is a rather reckless decision.
What were you guided by and what did you want to get as a result by putting SQL into a virtual machine?

I was guided by "Best practices for virtualizing and managing SQL server", as a result I got fault tolerance (we have a cluster).
What settings are you interested in? Which tab to show?

A

athacker, 2015-04-23
@athacker

In your virtual machine, by and large, three resources are served - CPU, memory, disk. Brakes can be caused by any of these reasons. You have already figured out the CPU, you need to deal with the other two. With a lack of memory, the VM will swap madly, and performance will suffer unbelievably. The same will happen with slow drives. Check memory load and latency/iops on disks.

A

Andrey Birulya, 2015-04-23
@Proxopotamus

I don't quite get it - what's bothering you? There are 40 cores on board, you have defined 4 cores for the machine, they are loaded at 95%+, the hypervisor shows 9% load - everything seems to converge? Or are you saying that you do not see this load in the dispatcher on the hypervisor? So you won't see it there.
ps In general, 1c does not recommend keeping both the server and clients on the same machine. it would be reasonable to divide it into two - leave one for the sequel + 1s server, and raise rds on the second.