Killing the “SQL Server is a Memory Hog” Myth
At least once a week I read or hear the familiar refrain, “SQL Server is a memory hog,” or “SQL Server uses all the memory.”
memory
The Server Draft
If you were given the chance to build the ultimate server, what would you draft first?
Estimating Hekaton Max Server Memory Requirements in SQL Server 2014
SQL Server 2014 has a lot of shiny new features. One of the brightest is In-Memory OLTP Hekaton, something I have been optimistic about (get the pun?) ever since I saw it at the PASS Summit in 2012. These days there is no shortage of information available to day regarding how Hekaton is full of … Read more
Doing It Wrong: Virtualizing SQL Server
I’ve been involved in a virtualization projects for almost ten years now. In that time I’ve had the opportunity to track my own list of “best practice” items. It’s a list I share freely with clients and customers that seek me out for virtualization advice. I can tell that virtualization (and Cloud) efforts are on … Read more
HOW TO: Determine If You Are Running A 32-bit Version Of SQL Server On A 64-bit O/S
Last week a question came up regarding the ability for a SQL Server 32-bit instance to address more than 4Gb of RAM when running on top of a 64-bit operating system (O/S). My friend Argenis Fernandez (blog | @DBArgenis) has already blogged the answer to this question so I won’t bother repeating those details here. However, … Read more
Are The Bells Tolling For Oracle?
Cojones. That’s about all I could think of when reading this article posted to Forbes.com. [UPDATE: The link at Forbes has been taken down, probably right after this response from Microsoft went live. You can find the original Forbes article in Google’s cache by clicking here.] It was written by Bob Evans who, as luck … Read more
