Posted by: Colin Smith
So in all the sessions that I attended, that was a lot, I found one demo o be above and beyond the rest and it is something that I would really like to do in my shop. During the pre con session that I attended I was able to see SQL Server 2012 be installed and run on Server 2008 R2 Core. That was awesome. I want to try it so bad now and I would love to get a real load on it and compare it to something that I have running in a standard GUI OS. I have to think that the performance would be better since I do not have anything that is not needed running and competing for CPU. The less the OS is doing means more cycles of CPU that SQL Server can have, also means that the OS might need less memory so that means SQL gets more. Those are BIG WINS in my book. Some might say that the downside is not having a GUI where you can install SSMS or other tools in order to manage the sysstem. Well we really should not be managing the database from local SSMS installations anyway and this will force the hand of your developers to stay off your server.. Sure some management may be a bit more work but you can do it all via Powershell. So do not be afraid, I am not. SQL Server running on a core version of the OS seems like a WIN to me and I can not wait to try it and do some real testing.