asked
SQL Server dashboard using WQL (WMI)
Hi I am in the process of building a server dashbaord for some of our smaller clients that cannot afford expensive tools. All ok with standard WMI, but am battling with finding resources for SQL related info, basic queries for eg, database size, table sizes, fragmentation of tables, queries processed etc. Anybody out there that can help. I am completely new to this and am a bit lost at the moment Regards Louis
The site works on votes. You need to mark any helpful answers with a thumbs up. If one of the answers leads to a solution, mark that by clicking on the check mark.
If you would like to find SQL statements that you can use for your dashboard, you can take a look at my Management Studio reports at: [
www.sqlservice.se/ssms/custom_reports.aspx][1] They will only work for SQL Server 2012, but it can give you an idea of what to monitor. (You can extract the SQL statements by using SQL Profiler) [1]:
http://www.sqlservice.se/ssms/custom_reports.aspx
Take a look at the queries Glen Berry has on his blog. It will give you a start. > **SQL Server Diagnostic Information Queries for November 2013** >
http://sqlserverperformance.wordpress.com/
Thank You to everyone so far, it is an extremely interesting topic and function
17 People are following this question.
