jaminsql ✭✭✭✭✭

Paul, This might be late in reaching you now. We have been a bit busy and I hadn't caught up on THWACK items in a while. perhaps the table CONV. Something like update CONV set STATUS='STOPPED', ENABLED='N' Then start the service and use the GUI to reset the password so you get the value hashed. Then you can go set these…

This is because DPA stores a hash that is not the full varninary SQL_handle but, is a hash based on that value. Please up vote storing the full value display feature request. Currently the only place to get the full value is in the Current tab and then under show active sessions we display the DPA hash and the sql_handle.…

There are trace flags and also the deadlock graph . DPA is using the extended event session information for deadlocks. This allows us to get this data and not be as much of a load as Profiler but, this method as mentioned isn't supported for 2008 R2. Finding SQL Server Deadlocks Using Trace Flag 1222 Analyze Deadlocks with…

The only thing I think that should be perhaps added to the article and can be a gotcha is if you are using SQL server authentication. The step that has you add a login on the new server does say to match the credentials to the old server. This is correct but, with SQL server authentication if you create a login on one…

Did you get this running after upgrade? What was the error you were receiving ?

rottengeek​ So when you put up this discussion I sent the questions and checked some with the DPA engineering team on this issue. The reply from them was "We are not touching the system_health session and I don't know about any behavior on SQL Server that should stop collecting the deadlocks when another session is…

not a solution really but, the hide charts button might help with that..

I would also suggest you upvote this item It would help as you then wouldn't have to do all the extra logging steps to get this data to see what is happening here. 

siggy, This looks to me like perhaps DPA's summary tables are not getting the sumarization done in a timely way. The charts you show are all pulled from the tables for sum data. Those tasks run every hour so if the hour for 8 am is getting data in this chart at 3:15 we must have data in detail for that hour that we didn't…

vote for the feature here.

Looking some this looks to be an sproc that is an un documented SQL Server system stored procedure. System Stored Procedures (Transact-SQL) | Microsoft Docs it is listed on this section "The following stored procedures are not documented:" Of the link above. From a search it seems to come up on may threads where there is…

Nice solution gcp​. I like the idea of the database name There is one here also that just alerts if there is not a full backup in the last day. Custom Alert - SQL Server Backup Monitoring it isn't giving the name however so you would end up having to look for that.

log file sync When a user session commits data, its redo information is written to the redo log buffer. The session then sends a signal to the LGWR process that the contents of the redo log buffer need to be written to disk. The LGWR process writes the contents of the redo log buffer to disk and sends a signal back to the…

Happy to help. Also do know that as I said on the call I think you had a number of small details that led to confusion in email on this one. A call to just work it all out usually helps.

It looks like you did a good job here of pulling the data from the repository. When looking at your first reply I would have suggested pulling this data from the repository from this same table set. Reports mentioned as custom are really just queries against our repository. Please feel free to turn this in as a feature…

Update on this thread. A case was opened and the cause was discovered. In the logs that sent we can see that the instances were registered and not licensed at first. The instances in question were added while there were no available licenses. Later a license was added and the monitor started up. I also noticed that DPA had…

No, Currently this is not possible. there is a feature request for it here.

Correct. You will also need to give in the wizard an account that can be used to query the groups.

This looks like an older thread but, I wanted to clarify it some as It could see this one causing some confusion. When DPA is installed on a windows server it should create a service out of the box. The service is called "Ignite PI Server" As the name has never been changed from the Confio days of DPA being Confio Ignite.…

I was going to say the same. Alert black out is a much simpler path on this one. That feature was added in 9.0 for DPA the feature was talked about some here

extreamck‌ and scrockrell@centene.com‌ I did send this on to the product managers to look into as a bug. They agreed and we will investigate a fix. Though we can't talk about time lines on any fixes. I think we maybe able to get you a work around also by a custom query to pull the plan text. Let me test here as we get time…

Update: We also got a support case on this item and this functionality was added to DPA version 9.2 by following this article http://knowledgebase.solarwinds.com/kb/questions/6397/Update+to+the+latest+jTDS+driver+for+DPA+9.2 

Please open a support case. We can get a look on a meeting and resolve this issue much faster there as we can get logs and help you find the problem.

Did you add this also on the content exchange ?

Matt, Thanks for posting this back here for others.

We had a support case for this some time ago for SQL server. I drafted the following KB explaining what we found and entered an Item for it in for a review. The default metric for blocked sessions is not filtering some items that the DPA quick poll and blockers tab are filtering. Does this KB look like what you are seeing?…

good thread here on this with some items you might find helpful. Procedure Cache Hit Ratio low, how to improve?

We had a few reports on this that made their way to us in support cases also. That the query is using Oracle syntax, this is because there is an edition of PostgreSQL (EnterpriseDB Advanced Server) that allows to be installed with Oracle syntax support for easier migration from Oracle database. DPA is doing this check to…

Thanks for updating the thread here that will help others also.

joe-n​, This alert isn't for NPM or the Orion product. It is for Database Performance Analyzer and should be entered in the DPA alerts page.