How to find out what's the Database server is used in Transaction Flow?
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:
It seems that dynaTrace is not able to identify the connection pool for this connection. What database driver and type are you using?
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
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
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.
We use Microsoft SQL Server 2000 - 8.00.2305 (Intel X86)
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
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
?an you advise how to install host agent on SQL Server? Are there the instructions anywhere?
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.......
Thank you, Jerry.
Is it a separate license?
what kind of tier I should use for that?
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
