Panic, Problems, and Plans

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 [...]

September 14, 2011  Tags: , , , ,   Posted in: General, Professional Development, Troubleshooting  No Comments

EXECSYNC progress

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 [...]

September 1, 2011  Tags: , , ,   Posted in: Troubleshooting  One Comment

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: , ,   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: , , ,   Posted in: Features, Troubleshooting  One Comment

Call me Ishmael

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”) [...]

February 25, 2011  Tags: , , , , ,   Posted in: Troubleshooting  No Comments