Hard disks counters and performance monitor

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
M SOSAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
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
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
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
 
M SOSAuthor Commented:
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
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
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
 
M SOSAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.