Solved

Hard disks counters and performance monitor

Posted on 2014-10-27
5
214 Views
Last Modified: 2014-10-28
Hi there

Can someone please tell me how to create counters and performance log (or whatever it is ) for a hard disk on a windows server 2008.

How to add the counters and most importantly knowing that the hard disk is part of the a virtual machine what is considered as normal activity knowing that this VM is running SQL Server 2008

I think I am getting confused so the simpler step by step the better pls  

Thanks
0
Comment
Question by:M SOS
  • 3
  • 2
5 Comments
 
LVL 119

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 40406151
What are you wanting to check, performance of a VM on a datastore, and to detect if the datastore is too slow for the VM ?

e.g. you need to change RAID type for the VM, or add more disks to the host, or change the datastore and move the VM to a faster datastore ?
0
 

Author Comment

by:M SOS
ID: 40406160
For now my friend since I have no experience with VM and since it is a virtual machine shared with other on the same host then I am inclined to think it is a Windows problem. Let us start with the basic steps first

The server is running SQL and the Read/Write is really high

I have set the counters but not sure I have done them correctly

SO, for now I need to know the following

1- How to correctly create hard disk counters and watch them over time

2- What is acceptable lever for read/write counters for a hard disk on VM running SQL on a Windows Server 2008

Thanks
0
 
LVL 119

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 40406169
You really need to look at the performance of the datastore, and is the latency of read and writes to the datastore, greater than 10ms.

This is the datastore that the VM is stored on, on the host Hypervisor.

see my EE Article

HOW TO:  Performance Monitor vSphere 4.x or 5.0
0
 

Author Comment

by:M SOS
ID: 40406192
I have another senior engineer who is adamant that it could be nothing to do with  the Data store

So I have decided to start troubleshooting from scratch

I am treating it as a windows issue for now
0
 
LVL 119

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 40406245
How does he know, if you've not looked at the performance of the datastore.

What is the underlying datastore?

I would look at the Characterize storage performance and correct: Storage Performance Analysis and Monitoring of my Article.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
what about DCpro 2 26
sql 2014,  lock limit 5 30
Workspace One/ VDIM/ Airwatch 6 20
vSphere 5.5 - prevent VM from communicating with another VM? networking or settings? 11 27
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
In this article, I will show you HOW TO: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question