question

Louisvr avatar image
Louisvr 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
performancedatabase-sizewmiserver-sizing
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
Håkan Winther avatar image
Håkan Winther answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqlaj 1 avatar image
sqlaj 1 answered
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/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Louisvr avatar image
Louisvr answered
Thank You to everyone so far, it is an extremely interesting topic and function
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.