My DB performance management experiences is primarily with Oracle and I am looking for an equivalent set of tools in MSSQL. In particular something to easily spot historical SQL peaks and identify the culprit SQL. It seems most of the built-in tools (Activity monitor/DMV) offered by MS only caputure active issues, but cannot retrive and chart issues that occurred much longer than a few minutes in to the past.
For Oracle, we have Oracle Enterprise Manager which views the AWR repository and by default can see, 7 days worth of Activity including the exact Sessions/SQL statements that caused an issue and why.
Example screen shot: https://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqlid.htm#TDPPT142
For MSSQL aka SQL Server, the only thing I have been able to find is a 3rd party utility from Solar Winds.
Example screen shot: http://logicalread.com/wp-content/uploads/2017/05/meritsSQLblogpost5.png
Does Microsoft have something native that offers this capability?