This resource is no longer available
Despite what you may have heard, it is possible to troubleshoot SQL Server database performance issues without a third-party data performance management tool.
There are certain measures that can be taken to troubleshoot performance issues without third-party tools. Below are 2 shortcuts to effective performance troubleshooting on SQL Server:
- Monitoring and alerting
- Always know what has changed on your SQL Server instances
Read this 34-page report from Microsoft SQL Server MVP Kevin Kline to learn more about these 2 shortcuts and several other techniques to effectively troubleshoot SQL Server without third-party data performance management tools.