Forgot your password?
typodupeerror

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

by sean.k (#1993320) Attached to: Kernel Musings: Unix and NT
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 :)

Going the speed of light is bad for your age.

Working...