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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Andrew Hancock (VMware vExpert / EE MVE^2)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)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
Andrew Hancock (VMware vExpert / EE MVE^2)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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VMware

From novice to tech pro — start learning today.