When you have you application running in Windows Azure the best thing is to enable diagnostics monitoring so you can collect diagnostics data from your application.
However it is also possible to collect performance related data using PERFMON without diagnostics monitoring if you cannot enable by any reason.
To enable performance monitoring in Windows Azure VM using PERFMON you can do the following in startup task:
Now you can RDP to your Windows Azure VM and collect the PERFMON data.
Very useful.
I was trying to recollect the service that needs to be started to use the perfmon tool but couldn't.. this article was a quick recokner to get what i was looking for.