SCP-500 Case Studies & Practical Application 3 — Questions and Answers
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?
- The server's physical disk I/O counters in Windows Task Manager
- Wait-time analysis to identify which resource the queries are waiting on (Correct answer)
- The number of active TCP connections to the SQL Server port
- CPU utilization trends over the past 30 days
Correct answer: Wait-time analysis to identify which resource the queries are waiting on
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?
- WMI-based disk I/O template
- Application Performance Monitor (APM) component with custom process monitors (Correct answer)
- Syslog event correlation rule
- SNMP interface utilization poll
Correct answer: Application Performance Monitor (APM) component with custom process monitors
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?
- SolarWinds Server & Application Monitor (SAM)
- SolarWinds Virtualization Manager (VMAN) (Correct answer)
- SolarWinds Network Performance Monitor (NPM)
- SolarWinds Storage Resource Monitor (SRM)
Correct answer: SolarWinds Virtualization Manager (VMAN)
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?
- SolarWinds Network Performance Monitor (NPM)
- SolarWinds Storage Resource Monitor (SRM) (Correct answer)
- SolarWinds Server & Application Monitor (SAM)
- SolarWinds Log Analyzer
Correct answer: SolarWinds Storage Resource Monitor (SRM)
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?
- Create a Windows Script component monitor that calls the API and parses the JSON response (Correct answer)
- Use a built-in HTTP monitor pointed at the application's main URL
- Configure an SNMP trap receiver for the application server
- Deploy a new polling engine on the application server
Correct answer: Create a Windows Script component monitor that calls the API and parses the JSON response
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.
Question 6: An engineer configures a SAM application monitor for IIS but finds it always shows 'Unknown' status. The Windows server is added to Orion with WMI credentials. What is the MOST likely cause?
- The IIS service is consuming too much CPU for WMI to respond
- The WMI credentials lack the permissions required to query IIS-related WMI classes (Correct answer)
- SAM does not support IIS monitoring via WMI
- The polling engine cannot reach TCP port 161 on the server
Correct answer: The WMI credentials lack the permissions required to query IIS-related WMI classes
WMI monitoring requires the credential account to have sufficient DCOM and WMI namespace permissions; insufficient rights return 'Unknown' status.
Question 7: During a post-incident review, the team wants to correlate a server crash with network events that occurred in the same 10-minute window. Which SolarWinds feature enables this cross-domain correlation?
- Orion PerfStack, which overlays metrics from multiple modules on a single timeline (Correct answer)
- Separate NPM and SAM reports exported to Excel and compared manually
- A custom SWQL query joining the NPM and SAM database tables
- The Network Atlas map with color-coded node status
Correct answer: Orion PerfStack, which overlays metrics from multiple modules on a single timeline
PerfStack lets engineers drag and drop metrics from NPM, SAM, NTA, and other modules onto a unified timeline to identify cross-domain correlations.
SCP-500 Case Studies & Practical Application 3
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?