> ## Content Index
> Fetch the complete content index at: https://blog.tsd.digital/llms.txt
> Use this file to discover other available public pages before exploring further.

# SQL Server a memory hog? No, not at all
- URL: https://blog.tsd.digital/sql-server-a-memory-hog-no-not-at-all/
- Published: 2006-09-28T17:12:59.000Z
- Updated: 2006-09-28T17:12:59.000Z
- Author: Tim Gaunt
- Tags: SQL Server, #Import 2025-04-01 05:34

Craig found an amusing dity today, he was messing around with the settings in SQL Server Express and noticed these memory settings:

![SQL Server Memory Settings](https://storage.ghost.io/c/64/5b/645b11c2-b436-444c-a523-58dca4ca7bd8/content/images/img/SQLSeverExpress.jpg)

For those of you who don’t want to deliminate it, that’s:

- 2,147,483,647 Megabytes
- 2,147,483 Gigabytes
- 2,147 Terabytes
- Or 2 Petabytes!!

One does have to wonder what sort of super computer Microsoft are expecting to have run the database. It's certainly future-proof that's for sure. I'd love to have 1TB of RAM, let alone 2PB! So the next time you wonder what’s taking up all the memory, best check SQL Server –you might just find that lost Petabyte…

BTW if this blog post is still around when Petabytes are as common as Mega and Gigabytes are now then feel free to lean back in your chair and recollect “the good ol’ days” when computers only had 200-300GB of disk space and a couple of Gig’s RAM.