How is it performance wise?
Is there any advantage to running it on Linux (except maybe the cost of a Windows license which is probably trivial compared to the cost of Sql Server itself)
Is there any advantage to running it on Linux (except maybe the cost of a Windows license which is probably trivial compared to the cost of Sql Server itself)
As the OP indicated, MS SQL has it's own facilities for managing memory and disk I/O. It basically asks for all the resources from the OS and then does everything itself internally. I'm exaggerating obviously but it does try to avoid costly calls to the OS whenever and however possible which is why it was so easily ported to Linux.