Posted by: Colin Smith
About three weeks ago some new hardware came in and the server build team gave it to me, of course it needed SQL Installed Yesterday right. Well this build required SQL Server, SSAS, SSIS, and SSRS to be installed. No big deal I did the install did all of my configuration and handed it to the application team. Well when I did my config I told SQL Server to take 32 Gigs of memory and lock it in memory. I did this because it is a server with 64Gigs of Ram and I know that SSAS is going to need a significant chuck as well. I configured SSAS to take 30 Gigs and this should have left 2Gigs for the OS. Well I got a call and the app team was telling me that the server was paging like crazy. I logged on and it sure was. I start digging around and I found that in the Task Manager only 32 Gigs was being reported. Turns out that the server team installed a standard version of the OS and not the Enterprise that we purchased. Really? I mean they knew that it had 64Gigs of memory installed. Did they think that we just put that there for safe keeping in case we needed it later? Any way not the end of the world. Should be able to upgrade it with minimal down time, but still.