Our application is developed using Java. Now our QA wants to do a load test on application , as it will involve select,insert and update operations. I want to take this opportunity to see my sql server health during this test.
I can enable tracing , but is there any other way to monitor server health during this load activity ? like we can use EM in oracle etc.