When there needs to be a change to the ‘standard configuration’

Screaming fit

What do you do when a client complains about slow running queries, but when you suggest changing Maximum Degree of Parallelism to something other than “1”, you are told, “That is our standard configuration. Company policy.”
“Why?” you ask.
“To avoid CPU utilization pressure on other queries,” they reply.

If you want to be the hero (admit it, its okay. we all want to be the one who walks in, hits CAPS LOCK and walks away) then you are going to have to justify the change with hard data:

Create a VM with the ‘company standard’ settings and time the queries.
Change the settings and time the queries.
If there is a significant difference, stick the results into an Excel spreadsheet and make a pretty graph.
Print 10 copies and distribute. No soft skills required. 😉

Note: if the database is too large to restore a backup onto a VM, then create a clone of the database minus the actual data: http://support.microsoft.com/kb/914288

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s