You posted and upvoted questions at https://pollgab.com/room/brento, and I ascended – well, drove into – the Eldfell Volcano in the Westman Islands to answer ’em:
Questions we covered in the video:
00:00 Introductions 01:55 Do you notice big improvements for physical servers over virtual servers? 05:14 Why aren’t my SQL Servers using all of the available RAM? 07:16 Do you recommend periodic SQL Server restarts? 09:36 How many times have you encountered a SQL Server in perfect shape that needs no work? 11:55 Should I use Extended Events or Profiler? I find the XE interface