Logging and Performance Monitoring – I created a SQL logging system using a single simple and adaptable logging stored procedure to easily and thoroughly log ETL and proc execution and run time elapsed time, statistics, performance, and automatic error logging.
I did this because there is no such "normal" thing as this and it's quite useful!
There are commercial products and I have used some of them and some of them are quite good but they are expensive and usually companies will not afford to buy them in spite of the benefits they bring.
When it comes to SQL there really isn't a standardize way to instrument SQL and log its performance...So I quite a few years ago I built such a system and used it successfully in multiple production sites over multiple companies.
Nowadays there are companies such as DataDog that has cloud based systems and various instrumentation abilities including SQL...
But the cost rapidly adds up and frequently companies have to limit their expenditures by limiting their deployments...Which means only partial coverage.
The advantages of my approach is that it is all in house, no per log record or monthly charges, and it can be easily applied to SQL Server database system and other databases as well.
Bon appetite!
