Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

What would be your expectations from such a software. I am planning to show the DBA a list of the top cpu and memory intensive queries along with the query plan, etc. How could i assist the DBA more to help him optimize his queries ? What kind of data does a DBA need to Optimize all queries on his server ?

I am working for the SQL SERVER right now.

share|improve this question

closed as not constructive by Chopper3 Jun 23 '11 at 13:03

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

I would expect it to work as well as SQL Profiler. You and the DBA know that it's built into SSMS, right? Hell, some of the dynamic management views show you the big offenders without even needing to run Profiler.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.