• Solarwinds DBA Guide.pdf

    Briefly written step by step Solarwinds Database monitoring guide.
    Profile Photo
    last modified by Farhood Nishat
  • Solarwinds Database Monitoring

    I have been assigned a task to monitor the database of our company. We have around 25 SQL servers and I am currently looking for a tool to monitor the best. The major KPI's that we want to monitor are 1- CPU Wise Mos...
    Profile Photo
    created by Farhood Nishat
  • Custom Metric - Index Fragmentation

    DESCRIPTIONThis custom metric will track the fragmentation of an index   METRIC DEFINITIONTo create the custom metric, click on Options > Custom Resource Metrics and configure the metric similar to this:  ...
    Profile Photo
    last modified by mike.miller@impact-ps.com
  • The job [SummaryPollJob] has not been run in [1202] seconds, and its tolerance is set for [1200].

    Hi All,   I'm having below alert from DPA for all of our monitored servers. But i'm not able to figure it out what it is?   The job [SummaryPollJob] has not been run in [1202] seconds, and its tolerance i...
    Profile Photo
    last modified by lakshmananthati
  • Query to monitor free space for file group instead individual file

    Hello,   This question is about monitoring a free space in data files. Right now we have alert configure to monitor the free space inside a individual database file and we would like to change this to monitor a ...
    Profile Photo
    last modified by mssqldba
  • DPA Custom Metrics - Hiding tabs on non-applicable SQL Server Instances

    Hi all, I've set up a custom metric that does a SQL query to find out how many users have registered in the past day from a specific application database.  This query only applies to one of our database instance...
    Profile Photo
    last modified by garyrevans
  • Metrics and / or components monitored by DPA

    Hi everyone, I wonder if DPA has any list of monitored components without SAM (SAM Component Monitor Types and SAM Template Reference). Thank
    Profile Photo
    last modified by faspmg
  • Number of CPU & Memory Spike of a Node information Stored in which Database table

    Hello,   I want to know in which database table of solarwinds the number of CPU & Memory spike of a Nodes information gets stored.
    Profile Photo
    last modified by datta.sakore@bentley.com
  • Is it possible to configure MS SQL DPA to monitor only one database in instance

    Is it possible to configure MS SQL DPA to monitor only one database in instance? Thanks
    Profile Photo
    last modified by ipolishchukparker
  • Need a tempdb alert for actual space used

    Hi,   I need an alert that sends a message when the actual tempdb usage is 80%. Our tempdb is pre-sized but I need to know when it close to filling up.
    Profile Photo
    last modified by philter
  • How to create a custom alert/message on DPA for deadlocking or locking taking more than 1 minutes of time

    How to create a custom alert/message on DPA for deadlocking or locking taking more than 1 minutes of time   thanks Subhash
    Profile Photo
    last modified by subhamrenu
  • SQL Server Max Server Memory

    DESCRIPTIONGet the Max Server Memory and plot it over time. Adjust the frequency accordingly, but typically, this metric will not change often.   METRIC DEFINITIONTo create the custom metric, click on Options -&g...
    Profile Photo
    last modified by mandevil
  • Upgrade DPA from version 10.0 to 12.0 for SQL Server

    I have been tasked with upgrading DPA that we have running on SQL Server 2014.  The current version is 10.0 and we would like to upgrade to 12.0.  I have a few questions.   1. Can I upgrade from 10.0 t...
    Profile Photo
    last modified by pholtquist
  • Purge Database

    Hi Everyone !!   I don't have hard disk space to the SolarWinds(DPA) database server. Is there any way to delete old data by the tool? Br,
    Profile Photo
    last modified by claytonxavier
  • Managed Service Provider approach for DPA

    Is DPA suitable to be used in an MSP approach to capture and report metrics (i.e. resource and SQL alike) with external clients?  If so, is there any documentation on architecture configurations that SolarWinds s...
    Profile Photo
    last modified by tony.fountain@wtainc.com
  • Required CPU and memory report in DPA

    Hello Team,   We are using DPA  11.1.468 to monitor the SQL Server. Now we want the CPU and memory usage report. I can only able to see the CPU and memory charts. But not the report. Could you please help...
    Profile Photo
    last modified by surya7482
  • O/S CPU Queue Length - uses WMI

    Description DPA stopped using the sp_OA procedures to collect O/S level metrics and started using DMVs. However, the metric O/S CPU Queue Length was not available within a DMV so it was excluded. This document explain...
    Profile Photo
    last modified by darichar
  • certificate error when accessing DPA site

    Although I have added the certificate to the certificate store using the instructions on Thwack documentation, I still keep getting this error when I go to the DPA site. Please help set this up so that I done get this...
    Profile Photo
    last modified by dkv
  • queries and session ids in deadlock alert

    I have enabled deadlock alert shipped with DPA 11.1. It sends me the alert notifications, but does not tell what queries and session ids were in the deadlock, How do enhance it to show the queries and session ids. ...
    Profile Photo
    last modified by dkv
  • Need to filter usage by user

    Hi,   Can somebody please help. Is there a way to filter/drill for a specific user only? I need to send out a report that shows the past month's usage for a user.
    Profile Photo
    last modified by philter