T-SQL performance tuning – no differences between virtual and physical<\/p>\n
Check host and\u00a0GPU numbers – look outside of the VM at the host.<\/p>\n
Remote Perfmon users – group you can be added to for viewing performance monitor information for the server; you can be added to this group on the server where your VM is hosted.<\/p>\n
ESX Top – task manager for UNIX; command line utility. Check for CPU thrashing – looking for percent used.<\/p>\n
Check host and guest for disk IO latency.<\/p>\n
Balloon memory driver – should be enabled; used by host os to request memory back from the guest os; if this is turned off – prevents host os from paging physical memory to the hosts swap\u00a0file;\u00a0paging will occur and you will have random slowness that will be difficult to diagnose.<\/p>\n
Reserved memory setting – How much memory you want and how much memory you really need to have (reserved).<\/p>\n
Memory deduplication – looking for and stripping out duplicate instances of processes in memory; great for OS memory. Doesn’t work for all SQL Server – unless multiple SQL Servers have the same pages in cache.<\/p>\n
Storage configuration options – IO is the same if the disks are physical or virtual; automatic tier adjusting technology if possible. Storage slow? Get faster storage ($$$). Keep OS, data, logs tempdb on separate disks if possible<\/span>.<\/p>\n Storage deduplication – can greatly improve overall performance; deduplicating the OS virtual disks = save much less data to the array.<\/p>\n VMWare Paravirtualization Driver – optional driver for vSphere Virtual Machines; recommended for high IO workloads; config via VM Properties – select SCSI controller, change type.<\/p>\n Monitoring – look at more levels of the environment; SQL Server, guest OS, hypervisor, etc.<\/p>\n Counters – Timer inside the VM lies – ugly rumor and nothing more.<\/p>\n","protected":false},"excerpt":{"rendered":" T-SQL performance tuning – no differences between virtual and physical Check host and\u00a0GPU numbers – look outside of the VM at the host. Remote Perfmon users – group you can be added to for viewing performance monitor information for the … Continue reading
\nreads\/writes per sec – correlated counter at the host level
\nseconds \/ reads and writes
\ndisk queue
\npage life expectancy
\nsystem processor queue
\nVM Disk
\nVM Memory<\/p>\n