Exception LoadTestCounterCategoryNotFoundException
The load test found this error.
Exception LoadTestCounterCategoryNotFoundException 1 The performance counter category 'SQLServer:Cache Manager' cannot be accessed on computer 'AGAMENON' (Category does not exist.) ; check that the category and computer names are correct.
I want to ask something, the iis server is on the same machine but sql server 2005 is on another machine, should I have special permisions to see the performance counters on remote machines? What else should I know if the IIS and SQL are not on the same machine of the tester?
Yes, in order to access the performance counters on a remote computer you need to be a member of the Performance Monitor Users group on that computer, or be an Administrator. If there is Performance Monitor Users group, then there are two "user rights" that you need. I believe they are named "Monitor Single Process" and "Monitor System Performance" or something similar.
It should be OK for IIS and SQL to be on different machines, but if you want to measure performance, then you should not run the tests on the same machine as IIS as the tests use CPU and memory resources and could affect the performance of IIS.