right now I tried to use SQLdiag and Pssdiag to identify the bottlenect of our SQL server 2008, please gives some example on how to use this 2x tools.
What is the tools to combine the result from these 2 x tools ? The SQL Nexus tool ?
I find the web site of SQL Nexus tool is not easy to understand, please show me some example on how to use it.
I want to easily identify the bottleneck of the SQL server 2008. By this tools is enought? Any other good experience to share?
What if I have use perfmon to collect some data but the file is too large for excel 2003 to open, perfmon on Window XP seems hard to open the perfmon result from Windows 2008 R2 as all the result seems overlap and I don't know how to separate the line.