Thank you for your interest in knowing ways of “Finding SQL server slowness root cause in a minute” with Free tools. We are doing it with the GUI free tool – SQL Planner, as manual methods could be extremely difficult and complex.
Step 1 : I have pre-recorded a session in youtube site which you can watch anytime at your comfort, this article explains how easy it is to look into server at particular time and find expensive query, sp, deadlock , blocking, errors found in selected SQL server
https://mssqlplanner.com/finding-sql-server-root-cause-in-a-minute/
Step 2: Please watch above video, once completed you might have question on “How to configure SQL server in SQL Planner to detect slowness, bottleneck and issues” , please watch this video
it can monitor your server for more than 60+ issues. If you want to know complete SQL Planner features and demo, visit to this link
Step 3: Hope you have completed above 2 steps carefully, once done, you can download SQL Planner from official site at this link : http://mssqlplanner.com/download-product/
Choose Free Edition and download, please note this free edition is not suitable for Enterprise as this is without support, has minor bugs, and not recommended by manufacturer.
Please follow all instructions carefully to install SQL Planner and pre-requisites on this page.
Do you have any question or trouble, please reply me or write to support@mssqlplanner.com
Have a great day !
Thanks
Chandan Sahu