m60freeman · Senior Database Administrator · ✭✭✭✭✭

@gcp: I agree with each of your points, although the "Occurs once at:" and "Occurs every:" part wouldn't really apply because we just want to pick a range. But if somebody out there has a need for a 5 minute blackout period on Mondays and Thursdays starting at 55 minutes after every hour between 6:55 AM and 8:00 PM, DPA…

See also ​.

Definitely!

I would extend this to make them unique per database within an instance. For people running many instances of the same database in one instance (supporting different customers or regions, for example), this could be helpful.

Please also see .

dlaney‌: I like the Health Check reports that I get from the Spotlight Essentials web site (somewhat similar to DPA's Advisors, but much more comprehensive and detailed: Missing Indexes, Security Policies [Guest user and password policies], Best Practices [use of Select *, Optimization Hints, and Set Rowcount], Recovery…

The page that displays these could have a statement to that effect. But the fact that the information can be misused is not a reason to hide it from those of us that know how to evaluate it and take only appropriate action. The ability to mark a specific missing index recommendation so it will be hidden from view once it…

Another example is the Signal Waits Percent chart on the Resources | CPU page. When the highest data point is 25%, displaying the Y-axis scale as 0 - 100% wastes 75% of the chart area on empty space. This chart is not auto-scaling, it has a fixed scale. It would be nice to be able to choose between Auto, Default, and…

I agree that being able to filter the Trends view to show only blocking waits would be a step forward. It should affect all the tabs under Trends, and also affect the Advisors. I want to deal with statements that consume too much CPU or memory, but only after I deal with the ones that are keeping dozens of users from…

Note that this is a request to be able to manually group hashes. A more advanced version of this would allow us to specify a regular expression to identify SQL to be automatically grouped based on the text matching the RegEx. Please also see Re: Historically Associate Queries

When the baseline feature was added to 10.0, it did not include baselining for VM/Host metrics. It would be great to have those added.

I'm using SQL Server. The referenced custom alerts don't really address my need. I am not concerned with seeing when a database has grown by more than X% in a day. I want to see the trend of growth over time (for example, a 12 month rolling average of n GB per month) for both mdf and ldf files by database for all databases…

Something like this would make seeing patterns so much easier.

Nice! I knew 9.1 was in beta but didn't realize it was GA yet. Thanks! Mark Freeman Database Administrator | Rogue Fitness 1080 Steelwood Road, Columbus, OH 43212 MFreeman@RogueFitness.com On Wed, Mar 18, 2015 at 11:37 AM, kathleen.gibbs <

For example, tell me which table in the following query might need some index tweaking: /* (inserted by DPA) Text truncated due to excessive length */ SELECT [Project1].[id] AS [id], [Project1] .[doh] AS [doh], [Project1] .[C1] AS [C1], [Project1] .[version] AS [version], [Project1] .[date_created] AS [date_created],…

Without the query text, there is no way to know which query for a SPID is running long. I can see why trying to include the query text would be a problem, but you could include the handle (r.sql_handle) instead. What is long for one query is not long for another. Perhaps you could take the approach from the long-running…

When I come in on Monday, I have no idea what happened since I left off on Friday. Coming back from vacations is even worse. The start page should be able to go back at least a week.

It is the same for me: "Post doesn't contain poll".

Please see related feature requests:

Another use would be to have one Alert Group for production server issues, another for test server issues, and another for development server issues.

Hooray!

I can see where this could dramatically increase the storage needed for the repository.

I haven't hunted around the repository much. If you send in a request to support, I've heard that they will send documentation on the schema. I don't want to have to work that hard; I want to be able to get it through the UI. I understand that you have a current pain point, so I'd suggest you open a high priority ticket…

Please also see .

We're more than a bit off-topic here, but the ability added in 9.1 to filter out specific statements from the long-term views really helped get the "noise" out of my charts. However, they are not filtered out of the Reports and the exclusions are ignored for short-term views. Maybe add a radio button or drop-down to select…

While there may be waits associated with obtaining and allocating memory, I need to know how much memory is being allocated. One significant use case is for determining the cause of a sudden drop in PLE. If I look at the Timeslice tab and have PLE in the Resources tab at the bottom of the page, I can see when the event…

I received this email alert at 9:08: Alert: Max Blocking Time Per Session - custom Database Instance: S-SW-PRODSQL2 Execution Time: Wednesday - July 29, 2015 09:07:53 View Alert Status: http://S-SW-NetMan:8123/iwc/alertMain.iwc Alert Parameters: Description: This alert will calculate the maximum blocking time per session.…

Yeah, the customized Raspberry Pi is cool, but I just don't have the time to take advantage of it. I could display a bobblehead on my desk and all my coworkers would be really impressed.

I have a few problem queries that are in a 3rd party app I cannot change. These wildly skew the scale of the charts, which is the same situation that ">sqlrockstar describes. Changing the interval doesn't help me because I want to see the longer-term charts without these statements represented. The reports suffer from the…

The grid columns should be resizable, adding a scrollbar if needed.. I see this as somewhat related to .