A lot of information is not captured when colleagues run numerous SQL codes on server. Oracle, SQL Server, Azure and others...
Would there be a clever way of capturing and archiving all this queries run?
It may be wise to collect these for several reasons;
- SQL code profiling is an important matter especially for DB admins. You can see the most required tables and fields etc.
- Also have a grasp on most frequent and time consuming joins to enhance DB performance
- Figure the queries that can be replicated in Alteryx and deployed to a server so that no business user needs to run SQL code instead they will be reverted to the gallery.
So found out a similar feature is now available in SQL Server 2016 --> https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-usin...