Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»

The New SQL OS Expand / Collapse
Author
Message
Posted Tuesday, April 1, 2008 9:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 24, 2012 11:23 AM
Points: 8, Visits: 12
Ivan Weaver (4/1/2008)
I was starting to drool until I got part way through. But, it was most believable because MS has tried the SQL Server Volume where you could have a whole disk volume dedicated to SQL Server. I don't know that it is used much, but an interesting idea non-the-less. Still, an OS based on a Data engine, didn't some one try that before, and where are they now? (painlfully remembers Novell NetWare 5)


That would've been PICK. I still have interesting memories on using PICK back in the 80's (some good, most painful)



Post #477816
Posted Tuesday, April 1, 2008 10:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 21, 2012 7:40 AM
Points: 26, Visits: 84
The idea of removing the Windows dependency is appealing.
Post #477827
Posted Tuesday, April 1, 2008 10:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 1:10 PM
Points: 4, Visits: 35
If only! That would be great...
Post #477838
Posted Tuesday, April 1, 2008 4:44 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:39 AM
Points: 1,315, Visits: 785
Good one!

But...

Wasn't this sort of how SQL 6 and 6.5 worked? At least if I remember correctly those two (and I assume 4.2) bypassed the OS for IO functions and managed those themselves. Hence why we had to create a device/partition (ok it has been 11 years since I worked on either, so particulars are a bit rusty) that we then created the database on.
Post #478155
Posted Tuesday, April 1, 2008 5:16 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 821, Visits: 2,028
Anders Pedersen (4/1/2008)
...
Wasn't this sort of how SQL 6 and 6.5 worked? At least if I remember correctly those two (and I assume 4.2) bypassed the OS for IO functions and managed those themselves. ...


Yep. Same for 7 IIRC. 2000 objects if it's data or log files are compressed via NTFS. I think that this might still be true for 2005.

Ah well. So much for the Dyson Principle: "I just think that things should work properly."


ATB

Charles Kincaid

Post #478163
Posted Tuesday, April 1, 2008 5:22 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:28 AM
Points: 7,179, Visits: 15,775
Charles Kincaid (4/1/2008)
Anders Pedersen (4/1/2008)
...
Wasn't this sort of how SQL 6 and 6.5 worked? At least if I remember correctly those two (and I assume 4.2) bypassed the OS for IO functions and managed those themselves. ...


Yep. Same for 7 IIRC. 2000 objects if it's data or log files are compressed via NTFS. I think that this might still be true for 2005.

Ah well. So much for the Dyson Principle: "I just think that things should work properly."


I'm actually not sure they've ever stopped thinking on this. The original concept of Longhorn's File system was essentially supposed to be a SQL Server database of sorts. In other words - the DB IS the file system. I don't think that survived, but it's a very compelling thought.


----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #478164
Posted Tuesday, April 1, 2008 5:28 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 4, 2014 10:11 AM
Points: 892, Visits: 1,560
Nick Brenner (4/1/2008)
Not laughing. Not laughing at all. Good thing I read it all the way through before forwarding it on to my boss. He would not be amused either.



How can you not be willing to laugh at all and still work in a Windows environment? Just Chill, same goes for the Boss.


Kindest Regards,

Just say No to Facebook!
Post #478165
Posted Tuesday, April 1, 2008 8:00 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 13, 2014 10:15 AM
Points: 103, Visits: 152
Dang. I was so into this article... good one.
Post #478194
Posted Wednesday, April 2, 2008 9:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 1:07 PM
Points: 32, Visits: 50
Charles Kincaid (4/1/2008)

Ah well. So much for the Dyson Principle: "I just think that things should work properly."


It would depend on whose version of 'properly' is in use at the time. ;) MS thinks the OSs work properly, it's just the hardware. ;) It's up to us testers, err, users, to let them know about issues.

"How long a minute is depends on what side of the bathroom door you're on." :D

Post #478622
Posted Wednesday, April 2, 2008 12:14 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 17, 2014 11:23 AM
Points: 1,019, Visits: 446
Funny, us DBAs here in Kalamazoo have not heard anything about this until now. We are the new Redmond, y'know!

- Tim Ford, SQL Server MVP
http://www.sqlcruise.com
http://www.thesqlagentman.com
http://www.linkedin.com/in/timothyford
Post #478771
« Prev Topic | Next Topic »

Add to briefcase «««12345»»

Permissions Expand / Collapse