The session-level options can be found using the @@options variable in SQL Server. Let us decode that in this blog post and learn about it.
While doing performance tuning for one of my clients, I was looking at ERRORLOG files to understand about their system. I saw that trace flag 1117 and 1118 are enabled via startup parameter.
As many of you know, I am an indecent SQL Server Consultant, who purely focus on SQL Server Performance. Every single day, I keep two slots each hour long available for users who need my help urgently. I never ever pre-book them because, I believe it is critical to help people who needs help NOW. Well let us learn in this blog post about how I recently helped a customer to improve performance by turning off AUTO_CLOSE Database Option.