rick.sellers

Comments

  • Those two screen shots are for standard metrics in DPA. If it gets voted up, maybe it will get on the Roadmap. That is why I submitted it as a Feature Request. We have PerfStack, but it is not yet configured fully and it may be a while before it is. We can always go back to DPA for the data, but it would be nice to see it…
    in Add additional DPA graph resources in SAM Integration Comment by rick.sellers August 2017
  • I probably used the wrong terminology when writing this feature request. When I said "alarm", I meant the Query status summary was still showing as red for that server when all query analysis items for that server had been excluded in the SQL exclusion list. We expected that server to drop off the Query Analysis…
    in Exclude SQL statement history from trend analysis when SQL statement is excluded Comment by rick.sellers August 2017
  • Even better would be the ability to aggregate by stored procedure even if it used multiple execution plans. For example, if you have a stored procedure that uses the WITH RECOMPILE option.
    in Aggregate wait data by stored procedure Comment by rick.sellers July 2017
  • I voted this up, but with the caveat that the counters in the DMV get reset when SQL Server is restarted. A warning to that effect should be placed on the page where this information is displayed. As always, knowing how to use the information provided is critical to getting the best performance out of SQL Server.
    in Show Unused Indexes Comment by rick.sellers June 2017
  • No, I am asking for the same resources we get for cpu, memory, disk, and sessions from the Resources view in DPA to be available in SAM for the Waits and Tran Log tabs in DPA. I cannot find a resource in SAM to add to a view that will display the graphs that are available in DPA for Waits and Tran Logs in a stacked format…
    in Add additional DPA graph resources in SAM Integration Comment by rick.sellers August 2017
  • I created my own Custom Metric on this before I found this one. The difference is that I used a Metric Type of "Rate", which gives me the Page Splits/sec on the SQL Server instance and I run it on a 60-second interval. The SQL I used is shown below: SELECT cntr_value FROM sys.dm_os_performance_counters WHERE object_name =…
    in Custom Metric - Page Splits Comment by rick.sellers June 2017
Avatar