SQL Server a memory hog? No, not at all

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

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.

Author

Tim

comments powered by Disqus