Skip to content
Born SQL

Primary Menu

  • Home
    • About
    • Contact Us
  • Blog
  • Speaking
  • Resources
    • SQL 2000: Duplicate Index Finder
    • Database Backup Sync and Restore
    • Max Server Memory Matrix
    • SQL to Excel Exporter tool
    • Blog series links
    • Hire us!
      • SQL Server Performance and Health Check (dbSnitch)
      • Upgrade Wizard
      • Disaster Recovery
      • 2-Day Tune-Up
      • DBA

Day: August 30, 2016

Post image

Max Server Memory Revisited

Posted on 30 August 201630 August 2016 by randolph

Some time ago, I added a free resource to this site to help DBAs know how much max server memory should be assigned to SQL Server, based on an algorithm by Jonathan Kehayias. On 19 August 2016, I went one step further and wrote a free script to perform the calculation for your own instance,
-> Continue reading Max Server Memory Revisited

Tagged best practice, Configuration, Max Server Memory, T-SQL Leave a comment

Posts navigation

Want to write for this site?
Click here!
Randolph West

Randolph West

Randolph West (they/them) is a Senior Technical Writer at Microsoft on the Database Docs team. When not writing about technology, you can see them acting on the stage and screen, or doing voices for independent video games. Available for mentoring, talks on SQL Server and technology in general, you can connect with Randolph on Twitter. Buy their books on Amazon.

View Full Profile →

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 314 other subscribers

Recent Posts

  • Data is not immutable
  • Winding down
  • Just one more thing, an essay on troubleshooting
  • Choco upgrade, y’all
  • If I can’t use PWDENCRYPT, how am I supposed to use HASHBYTES?
  • On bias
  • A new book is on its way
  • You can’t secure your network with spite
  • How do I merge a small part of a Git repo into another repo?
  • Don’t change your default SQL Server port for security reasons

Follow @BornSQL on Twitter

Follow @_randolph_west on Twitter

Archives

Popular Tags

Azure Azure SQL Database Backup Backups Beginner Careers Cloud Community Compatibility Configuration Containers Corruption Data Recovery data types date datetime datetime2 Development DevOps Disaster Recovery Fundamentals Internals Linux Maintenance Max Server Memory Migration Performance Recovery Security software development SQLNewBlogger SQLSaturday SQL Server SQL Server 2000 SQL Server 2016 SQL Server 2017 SQL Server 2019 SQL Server on Linux SSMS Storage Engine T-SQL T-SQL Tuesday Temporal Tables tsql2sday Upgrade

Find stuff

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
Calgary, Canada
info@bornsql.ca
+1-587-997-4845
  • Twitter link
  • Linkedin link

Copyright © Born SQL, a 1690406 Alberta Ltd company