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% […]
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 […]
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 […]
