jsql

Upvoted! This would be very helpful. It's a shame to have the info available in DPA and have to do screenprints to create reports for management.

Ha my eyes aren't good in the morning. Replied to myself!

That's exactly what I do for my quarterly reports.

3,232. is that a lot? i'm not even sure what an interface represents here.

Thanks for the help! Hard to get the SAN details at the moment, our SAN is externally managed and our Infra Team does not know the disk config specifics. Summer holidays, short staffed, everyone seems too busy at the moment, Our Infra guy says that it's certainly got parity enabled. Don't know the RAID level or even if…

it's not often that we have a failover, i'd say one every couple of months, usually a network issue. but once we have a failover, we don't failback, there are some applications that are sensitive even though they are "AO compatible". we usually live with the failover until the next windows/sql patching and them sort them…

Not seeing any improvement in SIMPLE mode....any other ideas to improve?

Its any query that hits this one table. Not just a single query. It has no unique key and has a clustered index on it, causing index scans for any query that hits it.

Can I tack on some questions here? Let me know if you prefer a separate thread. I see a screenshot above with tempdb info but I don't find it in my DPA. Any clue on how to get this info? I'm having some issues with tempdb on a server in which tempdb keeps growing. I used some queries online that I found to find the largest…

Where do I find that chart - Write Latency Compared to Top Files on D..... ?

That is true but then the charts (for performance history) have huge gaps when a failover occurs. also, wouldn't that screw up the baselines?

Excellent. Exactly what I was looking for. I adapted it for MIN/MAX/AVG....next step will be to loop it through all my instance names. MANY THANKS!!! DECLARE @DBID varchar(100), @DBNAME varchar(100), @SQL varchar(1000); -- change the instance name here, matches the name shown in the Home page SELECT @DBID = ID, @DBNAME =…

thanks for the tips! my history view is indeed growing after increasing the CLEAN_DAYS_OF_DETAIL. i just wasn't patient enough and forgot about "30 days hath september, april, june and november". i'll check on the reports tomorrow.

Thanks for the info! Not on AlwaysOn. It was initially installed with FULL recovery model, we switched to bulk logged but no improvement. I need to check with the app owner so see if we can go to simple (should be ok), DPA version is 12.0.3074. I need to check with Network Team on version of NPM. No custom code on NPM. if…

Thanks for the info! Very interesting. I'm fairly new to DPA, been installed for about 2 months now. That's exactly what I'm doing, trying to reduce the noise. Our disk alerts often go red for the HMDL. So from a SQL perspective, as long as we get good SQL latencies do I need to be concerned about Host Max Disk Latency? Is…

Thanks as always. You are the man(devil)! I would propose this to be a standard AG alert and incorporate it into the dashboard.

Yes, DPA needs that for Table tuning advisors, It's only available for query advisors.

Is it possible to create a report that shows the VM metrics such as CPU, Disk, Memory, etc? It would be nice for management reporting to show the load trends for such metrics over time. I don't see any option but I could be missing something. Thanks!