SQL text is not displaying for the deadlocks, "database id" and "object id" is listed instead (4290351)

Our developers have researched this issue and the SQL Server agent it seems that there is no fix required here, there is xml stored in our Foglight topology which is not presented in the dashboard but all the details from the xml are.

Often there is no SQL text available in these circumstances, such as when a .NET SqlClient Data Provider runs an EXEC command which the Deadlocks panel would not be able to collect the SQL text from.

Users could try accessing SQL PI and reviewing the SQL Statements that were collected from the corresponding time range based on the Client Application column (Programs in SQL PI), login name column (Users in SQL PI), database, host name (Client Machines in SQL PI), etc. 

Type "Deadlock" in the Search box in SQL PI to see the list of deadlocks there.
 

 

Additional deadlock information containing the SQL Handle might be also available by reviewing the following topology location for on-premise Foglight systems (non Foglight Cloud).

1. Navigate to Configuration | Data
2. Expand Management Server
3. Expand All Data
4. Expand DBSS_Data_Model
5. Expand SQL-Server Data Model
6. Expand Clusters
7. Expand AGENT NAME
8. Expand Instances
9. Expand AGENT NAME
10. Expand Deadlock Data
11. Expand Deadlock Data Obs
12. Expand History
13. Click History
14. Change the time in the top right corner to when this Deadlock occurred
15. Click Deadlock Data to reset the data, new values should open up below
16. Expand History
17. Continue expanding the levels, until you reach the lowest level, such as SQL Server Deadlock Process, SQL Server Deadlock Process Frame, or Resource Waiter and then click that item (the details if there are any available) to show the SQL handle involved.