Recently during Comprehensive Database Performance Health Check, I had a very interesting conversation. SQL Server has introduced Activity Monitor many version earlier. I think everybody is now pretty familiar with this tool and use it frequently. However, during my consulting work, I use different scripts which are much more efficient than Activity Monitor. However, it is alright to use it once in a while.
It has been quite a long time since I stopped posting about various SQL downloads available on the interest. The reason was that many users were not interested in learning about it. However the latest release of SQL Server Management Studio (SSMS), requires a mention about it. The latest version contains Performance Dashboard by default.
Many times, we need to find information about the various features / version of SQL Server installed on a machine. If you ask a DBA, he can provide you information by looking at services and tell what all are installed. He might run some WMI/T-SQL queries to list the services of SQL Server and their versions. Let us learn about the Discovery Report.