SCP-500 Case Studies & Practical Application 3

Question 1

A DBA reports that a production SQL Server is experiencing slow query response times during business hours. Using SolarWinds Database Performance Analyzer (DPA), what should the engineer examine first?

Accepted Answer

Wait-time analysis to identify which resource the queries are waiting on

Answer

DPA's wait-time analysis identifies which resource (CPU, I/O, locks, network) queries are waiting on, pinpointing the true bottleneck.

Question 2

An application team says their Java web app is slow, but the server's CPU and RAM look fine in SolarWinds SAM. What SAM component would reveal slow internal application processes?

Accepted Answer

Application Performance Monitor (APM) component with custom process monitors

Answer

SAM's APM component monitors application-specific processes, response times, and custom script outputs to expose slow internals beyond OS metrics.

Question 3

A virtualization administrator needs to see which VMs are consuming the most CPU on a VMware cluster and correlate this with host performance degradation. Which SolarWinds product is designed for this?

Accepted Answer

SolarWinds Virtualization Manager (VMAN)

Answer

VMAN provides deep VMware and Hyper-V visibility, correlating VM-level resource consumption with host and cluster performance.

Question 4

After a storage array upgrade, the operations team wants to verify that host-to-LUN I/O latency has improved. Which SolarWinds product provides this storage-path performance data?

Accepted Answer

SolarWinds Storage Resource Monitor (SRM)

Answer

SRM monitors storage arrays and provides LUN-level I/O latency, throughput, and capacity metrics across supported vendor platforms.

Question 5

A SolarWinds SAM administrator wants to monitor a custom in-house application that exposes health metrics via a REST API endpoint. What is the BEST approach in SAM?

Accepted Answer

Create a Windows Script component monitor that calls the API and parses the JSON response

Answer

A script-based component monitor in SAM can execute a REST API call, parse the response, and return a status or metric value for alerting and reporting.

SCP-500 - Solarwinds Certified Professional Practice Test

SCP-500 - Solarwinds Certified Professional Practice Test

SCP-500 Case Studies & Practical Application 3