Aha!
I found the answer to my Resource Governor quandary in this outstanding article, Understanding SQL Server Memory Grant, on MSDN.В The juicy bit: The server calculates the memory limit for one query. By default, this is 25% (20% on 32bit SQL 2005) of total query memory (which is set by memory broker as about 90% [...]
April 25, 2011
Tags: memory, Resource Governor, troubleshooting Posted in: Features, Troubleshooting 
One Comment
Resource Governor causing memory problem??
So.В Last week I blogged about the experiment I was running with Resource Governor for one of our newly upgraded development databases.В I had enabled Resource Governor and created a procedure to categorize sessions, but I hadn’t set any limits and everyone was sharing the same default pool.В The plan, if you’ll recall, was to [...]
April 22, 2011
Tags: memory, Resource Governor, SQL 2008, troubleshooting Posted in: Features, Troubleshooting One Comment
Resource Governor – Getting started
One of the databases I’m responsible for is a fairly large OLTP system.В For the majority of the time, it runs great.В Unfortunately, there’s a select group of users who insist on using it as an OLAP system, running very large reports or queries during business hours and consuming a lot of system resources in [...]
April 13, 2011
Tags: Resource Governor Posted in: Features One Comment
