Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Any suggestions on what set of questions I should be asking an end user or an application user to drill down to the real issue of his complaining about slow responses to his queries?

For example:

When was the issue noted?.
Is there a pattern to this occurence of slow performance? Etc...

To be exact which set of questions should I be asking in order to figure out the correct methodology of troubleshooting the same?

share|improve this question

closed as not a real question by Derek Downey, Phil, JNK Aug 30 '12 at 20:40

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Probably, you can also ask about the type of data he is passing in and the amount of passed in data – Praveen Aug 30 '12 at 19:43
I'd start with identifying the offending query. Then analyze it to see how long it takes, memory, CPU, etc. See what the access paths are. If it does table scans, doesn't use indexes, has locks, etc. – Chris Aldrich Aug 30 '12 at 20:22
Can you narrow this question down a lot? As written is too broad to be of much use. What kind of application? What version of SQL Server? What kind of queries (inserts/updates/deletes/selects)? Local server or network server? Local network or WAN? Is this OLAP or OLTP? – JNK Aug 30 '12 at 20:39
I'm closing this til you get it narrowed down. Post a comment with @JNK in it and I'll reopen it once it's narrow enough to be a good question. – JNK Aug 30 '12 at 20:40