I Put a new blade center in for a customer’s database server.
The new server has 50 gb ram and 6 processors available.
Now, I shoot the query from hell at the database thinking it?s going to be no problem.
Well, what happens is weird. All 6 processors go to 100% but sql doesn?t even use 500Mb of ram. I tried setting it to minimum of 2gb and max at the default limit, but sql still only grabs about 500Mb. I tried turning on the sql AWE memory engine, but still no difference. How can an SQL query peg 6 CPUs while using almost no memory and what can I do about it?
