Take the 2-minute tour ×
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. It's 100% free, no registration required.

I know how to use the Profiler, Performance Monitor, and Activity Monitor. I want to find a way to troubleshoot performance using T-SQL. How can I check for Microsoft SQL Server performance problems using T-SQL?

share|improve this question

closed as not a real question by Jon Seigel, JNK Mar 29 '13 at 17:17

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.

4  
Can you be more specific? From our FAQ: If you can imagine an entire book that answers your question, you’re asking too much. There are I'm sure many books covering exactly what you are asking here. –  JNK Mar 29 '13 at 15:29
2  
@Tarzan The problem is there isn't an "answer" to your question that can be given in one response. There are many books covering everything from DMVs to query plans that could be constructive, as well as useful scripts and other queries that could be used. From the FAQ: "You should only ask practical, answerable questions based on actual problems that you face. Chatty, open-ended questions diminish the usefulness of our site and push other questions off the front page." –  Mike Fal Mar 29 '13 at 16:32
4  
@Tarzan For future reference, I asked you very nicely to make your question more specific. You responded by telling me I am not very bright and insulting me. The little diamond next to my name indicates I'm one of the moderators here, so I have a pretty good idea of the scope of questions that we allow. I'm not sure what confused you about the FAQ, but I'm guessing you didn't bother reading it. Feel free to make this question specific and I'll reopen it, but I'm closing it for now. –  JNK Mar 29 '13 at 17:17
2  
Try SP_blitz by Brent Ozar. Start reading blogs books. There are a million scripts available to check and monitor database performance. Agree with all the comments this question is hideously non-specific. Everyone who has posted a question could probably post a 5 page answer to this question. –  Zane Mar 29 '13 at 17:22
2  
@Tarzan It's clear the problem isn't with the 'thought police' but instead the question, or person asking the question. If you find the rules here to your disliking, please try expers-exchange.com. Also, there are literally hundreds of DMVs to do this. There's so many queries you can write to record performance that your head will spin trying to list even 1% of the possibilities. I will have to side with the 'thought police' on this one. Please provide more specifics or start with Google and some books. Thanks. –  Ali Razeghi Mar 29 '13 at 17:25

2 Answers 2

up vote 1 down vote accepted

best is to use sp_whoisactive -- by Adam mechanic. It can be used to log to a table as described here Depending on your requirement, you can schedule a job to run every 15 mins or so and then you will be able to see how your server is doing.

share|improve this answer
    
Good suggestion. –  Tarzan Mar 29 '13 at 16:09

I'll do you a favor: Performance Tuning with SQL Server Dynamic Management Views by Ford and Davidson should have many answers. Very helpful book indeed, but there is a awful lot to learn if you have not much experience using DMVs (like me). You can try to adapt the scripts in the book to suit your needs better, that was a good learning experience for me.

share|improve this answer

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