On a server running a webserver application it is possible to use the APM Insight to track the webapplications performance including the SQL queries, capturing slow running queries etc.

But for a server running MSSQL but no webserver, how can I monitor the database  performance?