I am just testing/learning memory concepts over here. not to throttle any productions systems :-)
Ah! That makes sense then.
Yeah, learning how to deliberately overload the data cache vs the plan cache vs crushing the O/S space, etc., are all useful things. Good idea. Gives you a better idea of what can do those kinds of things, so you can fix it when it happens in the wild.
Try some things like loading too many big tables into active queries, all at the same time.
Try firing off a bunch of hyper-complex queries all at once.
Try non-deadlock long locks.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon