Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A True SQL OS


A True SQL OS

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)

Group: Administrators
Points: 51788 Visits: 19005
Comments posted to this topic are about the item A True SQL OS

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
BJ Hermsen
BJ Hermsen
Mr or Mrs. 500
Mr or Mrs. 500 (531 reputation)Mr or Mrs. 500 (531 reputation)Mr or Mrs. 500 (531 reputation)Mr or Mrs. 500 (531 reputation)Mr or Mrs. 500 (531 reputation)Mr or Mrs. 500 (531 reputation)Mr or Mrs. 500 (531 reputation)Mr or Mrs. 500 (531 reputation)

Group: General Forum Members
Points: 531 Visits: 880
I would love to see a core OS install running SQL Server. There are still many times when apps on the SQL Server would be necessary likewise there other reasons to not implement a core only model. It really depends how granular of an implementation a person wantseeds.

http://msdn.microsoft.com/en-us/library/ms143506.aspx -- "SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations."

Unfortunately SQL Server 2008 is not compatible with the Windows Server 2008 Core only installation. Maybe it is part of MS long term upgrade strategy.
nigel.
nigel.
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1675 Visits: 2834
Steve,

You say they won't do this due to a loss of revenue from selling fewer Windows licences.
Surely Micro$oft will just charge more for this 'SQL OS' to make up the difference.

Nigel

--
Nigel
Useful Links:
How to post data/code on a forum to get the best help
The "Numbers" or "Tally" Table - Jeff Moden

GSquared
GSquared
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20201 Visits: 9730
I like the idea of a stripped down version of Windows for this purpose more than the idea of SQL Server having to support hardware drivers, Active Directory, booting, internet connectivity (even if just for SQL Server updates to be downloaded), network connectivity (SQL Server doesn't contain the TCP/IP protocols, NIC drivers, etc., because Windows does that for it), and so on.

A version of Windows Server specialized for SQL Server and nothing else might be a good idea. But then Microsoft has to include support, upgrade and new version paths, etc., for it, and that might just add to expenses. If it would be a viable product, then it would be nice.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Todd Payne
Todd Payne
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 195
It is a great Idea! When a automobile company designs a car, or developers design an application. They focus on the capabilities they want to include. Then they can optimize the product to get the best performance. I Liken Installing SQL Server on a server to hitching a trailer on the family car. The trailer works fine and the job gets done, but If you were using the family car and the attached trailer every day, how long would it be before you were wishing you had a truck. The truck could be the perfect size, with a suspension and engine matched to your particular need. Sure it wouldn't do everything the family car did, but it would haul stuff better than the family car. You would probably have both parked in your driveway.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)

Group: Administrators
Points: 51788 Visits: 19005
I like the car analogy!

And I hope they don't start charging more for SQL without Windows, but I wouldn't be surprised.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Someguy
Someguy
SSC-Enthusiastic
SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)

Group: General Forum Members
Points: 191 Visits: 579
Question: How would this effect features of SQL Server which interact with other windows-dependent features such as CLR? I know we've had discussions on this forum as to whether SQL Server really benefits from the addition of CLR, but since it's there, it seems like a lot of Windows functionality is going to be potentially called.

___________________________________________________
“Politicians are like diapers. They both need changing regularly and for the same reason.”
edwardelliott
edwardelliott
SSC-Enthusiastic
SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)

Group: General Forum Members
Points: 151 Visits: 351
a database / os hybrid? You've just invented an AS/400! :-)
notquitexena
notquitexena
SSC Eights!
SSC Eights! (901 reputation)SSC Eights! (901 reputation)SSC Eights! (901 reputation)SSC Eights! (901 reputation)SSC Eights! (901 reputation)SSC Eights! (901 reputation)SSC Eights! (901 reputation)SSC Eights! (901 reputation)

Group: General Forum Members
Points: 901 Visits: 313
"Windows I/O and scheduling could be tuned specifically for SQL Server, or just incorporated into the SQL Server platform."

I'm afraid if you incorporated these into SQL Server you would quickly have the functionality diverge from the base OS source, which could in the long run lead to strange consequences. I've seen code which was copied from a legacy system mutate so fast in the space of the year that the original designer could not figure out why it would no longer work in the new system.
Scott D. Jacobson
Scott D. Jacobson
Mr or Mrs. 500
Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)

Group: General Forum Members
Points: 592 Visits: 1016
Robert Hermsen (8/26/2009)
http://msdn.microsoft.com/en-us/library/ms143506.aspx -- "SQL Server 2008 is not supported on Windows Server 2008 and Windows Server 2008 R2 Server Core installations."

Unfortunately SQL Server 2008 is not compatible with the Windows Server 2008 Core only installation. Maybe it is part of MS long term upgrade strategy.


That specifically says "not supported". In MS-ese that is not the same as "not compatible". I'd guess this stems from the fact that .NET is required for SQL to install. Initially, .NET was not supported under Core installations either. But I think this might have changed: http://blogs.technet.com/server_core/archive/2008/12/19/net-3-0-and-3-5-in-windows-server-2008-r2-server-core.aspx
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search