• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home
  • Public Forums
  • Application Monitoring & UEM
  • AppMon & UEM Open Q&A
avatar image
Question by Avelina K. · Nov 18, 2014 at 07:12 AM ·

How to find out what's the Database server is used in Transaction Flow?

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

7 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Jerry L. · Nov 19, 2014 at 10:18 AM

It is a host agent that is licensed by count.  For a POC the local team can create a POV license exactly like your here with a couple of host agents

I usually just map it to a Tier called HOST or You can make it the actual server name

 

 

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Jerry L. · Nov 19, 2014 at 09:31 AM

Its a pretty simple install.   On windows run the msi, update the agent .ini with the tier name in your profile and the IP of the collector you want to connect to.

It is a licensed agent so if you would like to try it and see if it will be helpful.   You can contact the sales team in your location and they would be able to assist you with getting access to a key that would let you try it.

Install doc.......   

Host Monitoring Agent

 

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Avelina K. · Nov 19, 2014 at 09:57 AM 0
Share

Thank you, Jerry.

Is it a separate license?

what kind of tier I should use for that?

avatar image

Answer by Jerry L. · Nov 18, 2014 at 12:42 PM

Note sure if this is a viable option.  I have worked with other customers in the past who have put a dynaTrace host agent on the database server.    This would allow you to mouse over the database and via the host health see the IP.    In addition CPU, Memory, Disk and Network I/O

 

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Avelina K. · Nov 19, 2014 at 09:21 AM 0
Share

?an you advise how to install host agent on SQL Server? Are there the instructions anywhere?

avatar image

Answer by Andreas G. · Nov 18, 2014 at 11:01 AM

Thats all the information we get from within the application. But that information should be enough. websql is the hostname of your SQL Server. Simply to a ping on that name from that machine where your application runs and you will have the IP. database= tells you the name of the database on that machine. Because the server name doesnt have a special name for the SQL SErver Instance it means there is a default SQL Server Instance on that machine that is used.

I think this should be enough information to figure out what SQL Server this physically is

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Andreas G. · Nov 18, 2014 at 10:22 AM

On the Transaction flow - ehen you drill to the Database Dashlet - you should see all SQL Statements grouped by Connection Pool. The connection pool should tell you which SQL Server instance is causing this issue. If you dont see connection pool information then it is possible that you are using an ADO.NET Driver that we do not support out-of-the-box. Thats a rare situation but probably what Kristof tried to understand when he was asking about which database driver you are using exactly. Is it SQL Server, SQL Server Compact, ...?

Andi

Comment

People who like this

0 Show 2 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Avelina K. · Nov 18, 2014 at 10:49 AM 0
Share

I can see these derails but under connection pool I can see the aliases (websql) we use in our code to reach the databases:

Is there any chance to see IPs?

If we add all our elements it will be difficult to track DB issues.

avatar image Avelina K. · Nov 21, 2014 at 08:27 AM 0
Share

We use Microsoft SQL Server  2000 - 8.00.2305 (Intel X86)

avatar image

Answer by Kristof R. · Nov 18, 2014 at 07:40 AM

It seems that dynaTrace is not able to identify the connection pool for this connection. What database driver and type are you using?

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Avelina K. · Nov 18, 2014 at 08:59 AM 0
Share

it was basically 2 separate questions:

1) Under Transaction Flow - "SQL" box details I can see only alias for the database.

How can I find out which SQL server is used without logging into the server? Is there an opportunity to show IPs for DB?

2) During this exception using .NET Framework Data Provider for SQL Server

avatar image

Answer by Avelina K. · Nov 18, 2014 at 07:23 AM

Under Transaction Flow - "SQL" box details I can see only alias for the database.

How can I find out which SQL server is used without logging into the server? Is there an opportunity to show IPs for DB?

Also with authentication errors it shows a separate red Database box with no information:

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

3 People are following this question.

avatar image avatar image avatar image

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A