Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > DPA shows a blank hostname, database name, or program name

DPA shows a blank hostname, database name, or program name

Updated February 13, 2018

Overview

When you drill in to a Microsoft SQL Server database instance, DPA displays No Host Name, No Program Name, or No Database. 

 

Capture5.PNGCapture3.PNGCapture4.PNG

Environment

  • DPA, all versions

Cause 

This happens because a third-party application is not reporting this data to SQL Server. 

Resolution

DPA polls this data directly from Microsoft SQL Server upon Quick Poll. To find out which application is not returning data:

  1. Run the following query to execute the stored procedure:
    sp_who2 
  2. Run this query: 
    select login_name,program_name,host_name from sys.dm_exec_sessions
  3. Use SQL Activity Monitor > Processes.
  4. You can filter the application column and click the dropdown to look for blank records.
  5. If you find blank records, contact the application owner to ask why the application is not registering details to SQL Server.

 

 

 

 

Last modified

Tags

Classifications

Public