Skip to main content

Questions tagged [performance-dashboard]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers

Database design for dashboard (statistics of performance)

I have a device (printer) that I can connect to using protocol and query for different statistics. To keep it simple, I get in return jobname and number of total prints for that job. Example: >&...
2 votes
1 answer

Significance of Historical waits report in SQL server Performance dashboard

I have the following historical wait report for my SQL server. I have noticed that Wait Category Tran Log IO is consuming 27.09% of percentage time followed by Query Store which takes 24.34%. I want ...
1 vote
0 answers

CPU load detalization does not work in SSMS Performance Dashboard

Starting from some version (it's actually earlier than the documented 17.2), SSMS has the Performance Dashboard built in, so you don't have to download and install it separately. Great. We have SQL ...
0 votes
2 answers

How can I optimize dashboard performance?

I have a table like FieldA, FieldB, FieldC, FieldD, TheDate, Count I have a web app which provides a dashboard of the top few Count by each of the fields. Not wanting to prematurely optimize, the ...