• 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
  • 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
  • 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
  • AUTOMATIC SCHEDULLER AS  A TASK OR REPORT WITH GRAPHICS  OF OPCION "RESOURCES"

    I would like to know and suggest the opcion to add the graphics or other information and send it by mail in AUTOMATIC way or using the SCHEDULLER as a task scheduled at night to send by mail. I found a manually opcion...
    Profile Photo
    last modified by oscarguevara
  • Trend Reports + Annotations

    Hi,   Does anyone know is it possible to include annotation tags on trending reports. I want to create weekly\monthly reports for management that show how tool is been used by DBA team and having annotations inc...
    Profile Photo
    last modified by dmulpeter
  • 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
  • How to grant the AD authenticated user access in DPA

    I had tried to add users and with AD group but not able to login with that users, Can anyone suggest for me step by step its DPA installed at Windows OS.   Thanks Subhash
    Profile Photo
    last modified by subhamrenu
  • 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
  • Custom Report Searching for Query Text

    Looking for documentation on how to create and run a custom query/report looking for any queries ran that contain a specific string. Our repository is in SQL Server.
    Profile Photo
    last modified by brian.clinger
  • 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
  • Custom Report - Metric Values

    Description The query below will provide detailed metric values for any metric in the instance, e.g. the metrics shown on the Resources tab in DPA>   Query DECLARE @DBID varchar(100), @MetricName varchar(50), ...
    Profile Photo
    last modified by darichar
  • Duplicate reports in the same repository for another database

    We migrated our servers to a new hardware, new names.  I reconfigured the licenses in SW DPA so the old server is no longer licensed, and the new server is.  However we have a LOT of reports setup in the old...
    Profile Photo
    last modified by tony.fountain@wtainc.com
  • Need to report on TOP SQL by Machine

    I do not see a standard report where we can specify a machine and return top SQL statements.  Does anyone have a report or raw SQL for that?  I am on DPA version 12. Thank you, David kranes
    Profile Photo
    last modified by dkranes
  • 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
  • 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
  • Custom Report or query for extract the querys for a specific user and specific date

    Hello, I'm trying to extract a report with all querys (not only the top querys) for a specific user in a specific date. There is a custom report or query for this? Thanks for your attention.
    Profile Photo
    last modified by thiagomartins3