The Multifunctioning DBA

Mar 31 2012   9:00PM GMT

Coolest thing I that was a demo during connections

Colin Smith Colin Smith Profile: 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.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: