Thanks for making this available, good to see what others are facing when working on diagnosing performance issues.
"Define the issue" is always one of my biggest challenges - some customers come with vague "It is slow" statements and others (my favorite) come prepared with plenty of detail and application logs so I can isolate the issue on the database side.
And I always seize opportunities to educate -- last week I was asked by a manager type to index all columns on all tables in a database since they experienced a couple of slow queries and wanted to make sure everything was tuned.
After I stopped banging my head on my desk I wrote a very polite email which boiled down to "Lets spend time working on actual problems, not problems that haven't shown up yet."
I enjoy the challenge of tuning but I secretly wished that it really was as simple as indexing every column in the DB :)
1 comment:
Thanks for making this available, good to see what others are facing when working on diagnosing performance issues.
"Define the issue" is always one of my biggest challenges - some customers come with vague "It is slow" statements and others (my favorite) come prepared with plenty of detail and application logs so I can isolate the issue on the database side.
And I always seize opportunities to educate -- last week I was asked by a manager type to index all columns on all tables in a database since they experienced a couple of slow queries and wanted to make sure everything was tuned.
After I stopped banging my head on my desk I wrote a very polite email which boiled down to "Lets spend time working on actual problems, not problems that haven't shown up yet."
I enjoy the challenge of tuning but I secretly wished that it really was as simple as indexing every column in the DB :)
Post a Comment