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
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.
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.