gcp · Database Administrator · ✭✭✭✭✭

@"kpina"

DanielleH Q.19 I could be wrong, but that looks like it should be a multiple choice answer?

Congratulations to unclehooch​ Now I'd really like the Raspberry Pi, so if you could all do me a favour and get one of the week 3 questions wrong, I'd greatly appreciate it

WEEK 3: DAY 14 - pretty sure this should be a multiple answer question @"kpina"

Also If you want them, vote them all up!

Week 4 Day 2 Jan 25 - this link may work better than the hint link: https://www.solarwinds.com/-/media/solarwinds/swdcv2/licensed-products/kiwi-syslog-server/resources/datasheets/kiwi-syslog-server-datasheet.ashx?rev=7e439cd192174e8b9a93cc6d97fb60d6 Page 2: Designed to handle up to xxxxxx messages per hour

Might need to fix the dates for Week 3 :D @"the_ben_keen" 

DanielleH Q.10 hint is less than happy - wrong link? This XML file does not appear to have any style information associated with it. The document tree is shown below. <Error><Code>AccessDenied</Code><Message>Access denied</Message></Error> This may be a more useful link for people to check: Server Configuration Monitor -…

"text box bellow" Does it make a loud noise?

WEEK 3: DAY 11 - multiple answers to choose, but only radio buttons allowing 1 choice - oopsy! @"danielleh"

Coming in very late here, but just in the process of setting up a new RHEL8 server for DPA, hopefully this will help someone. DPA 2021.3.7445 on RHEL8 Created file dpa.service in /lib/systemd/system: [Unit] Description=Solarwinds Database Performance Analyzer (DPA) After=network.target StartLimitIntervalSec=0 [Service]…

For DPA 2021.3.7445 I just tested upgrading the log4j* jar files on a Test system which seemed to work fine, and subsequently I see it is the recommended resolution: https://support.solarwinds.com/SuccessCenter/s/article/Database-Performance-Analyzer-DPA-and-the-Apache-Log4j-Vulnerability-CVE-2021-44228?language=en_US HTH…

Not relevant to me, we do not have SAM

Yes, all fixed now. Thanks!

Now Working! (24/02) The link to DPA 2021.1 is broken in the new platform https://thwack.solarwinds.com/t5/DPA-Discussions/SOLARWINDS-DATABASE-PERFORMANCE-ANALYZER-DPA-2021-1-RELEASE-IS/m-p/616458#M2954 returns Page Not Found.

The Year of Covid. The Year of the Rat. The Year of the Introvert. The Year of the Conspiracy Theory. The Year of Distrust and Division.

Thanks, have just checked the DB2_MONITOR_SINGLE_DB and it is set to false. Appreciate your help - I've opened a ticket.

Thanks - Will do. Begs the question though - If they are all the same, why not just have a single link to DPA 9.0? KISS principle and all that

DPA 8.3 and DB2 9.7 I think I see what is happening. When I look at the COND table, DPA is only reporting for the database recorded in CONN_DATABASE that was used when I registered the Instance to DPA. It won't let you register the other databases as the registration is per instance - This database instance is already…

Interesting. Our downloads section is only showing 9.0 for DPA - SQL Server 9.0.146 with a link to the actual 9.0 download. The DPA 9.0 links for DB2, Oracle and Sybase all take you to the 8.3.407 download.

I'm glad it worked for you mjkpref​. As mandevil​ says, I think there is another component in the scheduling mechanism, as it doesn't seem to be a reliable trick. Maybe SW can consider amalgamating these couple of requests? Basically, give us a decent calendar mechanism to set up blackouts, alerts etc.? In the meantime -…

@pnogueira if you want to know the explicit status of the job, you'll need to look at msdb sysjobs and sysjobshistory and create your own custom alert. This may get you started: Checking the status of SQL Server Agent jobs - SQLMatters The problem with using the custom alerts is that there are a limited number of alert…

You might also be able to use the script in this example as the basis of a custom alert: Simple script to find the free space in sql server db files (data, log) against all databases - Learn MySQL

This article may give you some ideas on investigating pageiolatch: https://sqlperformance.com/2014/06/io-subsystem/knee-jerk-waits-pageiolatch-sh

That does give you a count of failed jobs, provided it is a single step job, or they actually catch success/failure for each step. If the 'On failure action' is defaulted to 'Go to the next step' then you'll never see an error if a second or subsequent step fails. I have a vendor (*cough* airwatch *cough*) job that fails…

The default ignite user would be created in SQL server when you installed ignite - but it may also be stored in the repository somewhere encrypted. The SQL user in the repository database might be orphaned from the ignite login on your new SQL install. You can update the login password via SSMS but first check for orphaned…

I'm not sure if this is exactly what you need, but on SQL 2008 and higher you can use the sys.dm_os_process_memory DMV and examine the page_fault_count data "Indicates the number of page faults that are incurred by the SQL Server process." sys.dm_os_process_memory (Transact-SQL)

You could try using telnet to check if the port is accessible (but you may not have telnet enabled by default on a Windows PC) e.g. telnet 10.1.42.13 1433 If it connects successfully, then the port is open. Testing port connectivity with Telnet - YouTube Faling that - ask your server team or whoever looks after the…

I now really want to see this under System Options: Name Description Default Value Current Value Ninja Mode Security suppress mode OFF ON

Similar suggestions currently in Feature Requests: If you want 'em, vote 'em up!