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

Urgently need a T-SQL query which can give all the performance monitoring information like database size, database physical path etc, log size, log path, spaced used, space free, number of connections, number of logins, number of deadlocks with its queries etc etc of a single database in SQL Server 2008 R2

share|improve this question

closed as primarily opinion-based by Marian, Paul White, billinkc, bluefeet, RolandoMySQLDBA Oct 27 '13 at 0:12

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.

Go for

Note: You have asked a lot in just one question. Though, if you have performance issues, then I would recommend you to start with the Glenn's DMV queries or Brent's sp_AskBrent.

If you want to find if your server and databases are configured properly and if they might have performance concerns or might be misconfigured (away from standard best practices), Brent's sp_BLITZ and SQL Power Doc will do a really nice job.

share|improve this answer
+ sp_whoisactive – swasheck Oct 25 '13 at 22:02
@swasheck Good one. Forgot to add it. Now added. – Kin Oct 25 '13 at 22:15

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