Catch up on stories from the past week (and beyond) at the Slashdot story archive

 



Forgot your password?
typodupeerror
Check out the new SourceForge HTML5 internet speed test! No Flash necessary and runs on all devices. Also, Slashdot's Facebook page has a chat bot now. Message it for stories and more. ×

Comment hate to break it to ya (Score 1) 357

but SQL Server is configured to seize a specific amount of RAM at bootup. I think it defaults to 64, though it may be higher. This is where the huge RAM hit is coming from. And if you think about it, giving an SQL server a bunch of RAM initially makes more sense than having it request more every time someone runs a query. Personally, my SQL servers are all dedicated machines. You may not notice a performance degradation with a web server until it gets busy but a single complex query and you'll be doing anything you can for a few extra CPU cycles :)

Slashdot Top Deals

This restaurant was advertising breakfast any time. So I ordered french toast in the renaissance. - Steven Wright, comedian

Working...