First Rule:- All the live changes should be tested successfully on the testing or Preprod server before we deploy in live including backout steps.

Type of changes & the...

I would suggest trying running the below queries at time when the SQL server is very used. Which should help us in understanding the total memory consumed by SQL Server....

You could run the sql profiler trace to capture the log file details, which will let you know while carrying which activities the log file grows. Once we know the...

No.. there's no way to rename a SQL Server instance. You either have to re-install or install a new instance with the desired name.

If you can't afford for the third party tools.. Here the idea on which you need to work on writing a windows script.

Within the sys process when ever the...

Well, with the report it seems the memory usage by sql server seems to high..

Run the below queries to identify how much memory is consumed by SQL Server, each...