So what have I been up to? Well not writing blog posts, obviously. Everybody Panic!!! Really though, I haven’t exactly been slacking off these past couple weeks. As you may recall, one of my goals this year was to present at a SQL Saturday. To help me towards that goal, I have my very first […]
I’m happy to report that some progress has been made on my performance problem. I’m still working on it, and there will be a full progress report to come, but for now I’m simply happy to say I’ve gotten somewhere in the EXECSYNC dept. Now, that’s not to say I’ve gotten rid of them, but […]
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 […]
This week I’ve been chasing my own white whale. Another developer came to me with this little problem. A query he was trying to run over a linked server to an Oracle database was returning unexpected results. Here’s his original query: select count(order_num) from openquery(PROD, ‘select t2.order_num from myschema.mytable t2 where open_date < to_date(”01-JAN-2011”, ”DD-MON-YYYY”) […]
