SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQLDiag and PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.
With the RML Utilities you can answer questions such as the following:
If you think you have OpsMgr SQL Server performance issues maybe SQL Nexus together with SQLDiag and RML Utilities can help with performance tuning and analysis.
I want to thank David Scheltens for showing me how to use SQL Nexus and creating the PerfStatsScripts.
SQLDiag (installed default with SQL2005 and SQL2008)
PSSDiag (to use with SQL2000)
Thanks for this post. I'm a big fan of SQL Nexus, but admittedly it can be a nuisance to install and get working reliably as there's quite a few steps and they're not documented very well on Codeplex. This is a great guide.
Thanks for the nice words! I am/was a newbie on SQLNexus so I probably hit all the problems during the install ;-)
Stephan Stranger a posté sur son Blog un article sur l'utilisation de SQL Nexus pour résoudre des problèmes...