Hi, I’m David Wiseman.
I’m a SQL Server DBA that enjoys performance tuning and spend most of my time writing and tuning T-SQL code. This is my personal blog site to share my experience, scripts and tools with the community.
- Set Max Server Server Memory at StartupMax server memory is one of the SQL Server configuration options that you should change from the default value. Brent Ozar has some good advice on this here. TLDR: You should leave some extra memory for the o/s. A good starting point is to leave 10% (4GB minimum). If you are running other processes on […]