Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Customer Dashboard: Transaction Query Monitor Dashboard

rfb
shared-dashboards

#1

Hi Team

Transaction traces can contain database query data. Use the Database queries page to analyze a slow transaction or change database query collection settings.We have monitor daily basis transaction , transaction error from this dashboard . This is very useful for easily identify in Which Application getting error with same time showing Host name ( Infra Name ) for that we taken action with in few time.

In below Dashboard we can see transaction Time , App Name , Host name , Error message ,Name.transaction error count.

With the help of this we smoothly monitor all transaction in our app and improve the Quality.

Dashboards have the following benefits:

  • Foster a culture of continuous improvements
  • Data transparency throughout the organization
  • Being in control of business decisions by having the right data
  • Save time and money on reporting
  • Improved alignment throughout the organization

Thank you New Relic for this Amazing Feature

Dashboard

dashboard
dashboard.jpeg1891x2020 756 KB

Chart Details:

1. System lacked sufficient buffer space :

i ) Transaction Error Count >

SELECT count(*) FROM TransactionError WHERE error.message LIKE ‘%An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full%’ and host LIKE ‘%DSS%’ TIMESERIES 1 minute SINCE 7 days ago

ii ) Transaction Details >

SELECT timestamp,appName,host,BuyerPartnerCode,errorMessage,name FROM TransactionError WHERE error.message LIKE ‘%An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full%’ and host LIKE ‘%DSS%’ TIMESERIES 1 minute SINCE 7 days ago

2. Prod US Error "Network Related Error :

SELECT count(*) FROM Transaction WHERE UserName != ‘XYZ’ AND appName LIKE ‘Prod_%’ and appName NOT LIKE ‘Prod_EU_%’ AND errorMessage LIKE ‘%A network-related or instance-specific error occurred while establishing a connection to SQL Server%’ SINCE 7 days ago

3. Prod US Error “Timeout Expired” :

SELECT count(*) FROM Transaction WHERE appName LIKE ‘Prod_%’ AND appName NOT LIKE ‘Prod_EU%’ AND errorMessage LIKE ‘%Timeout%’ SINCE 7 days ago

4. Could Not Load Assembly Error :

SELECT Count(*) from Transaction WHERE appName like ‘%prod%’ and appName not like ‘%prodstg%’ AND errorMessage LIKE ‘Could not load file or assembly%’ SINCE 7 days ago

5. Prod EU Error “Connection attempt failed” :

SELECT count(*) FROM Transaction WHERE UserName !‘XYZ’ AND appName LIKE ‘Prod_EU_%’ AND errorMessage LIKE ‘%A connection attempt failed%’ SINCE 7 days ago

6. Endpoint Error In Prod :

SELECT Count(*) from Transaction WHERE appName like ‘%prod%’ and appName not like ‘%prodstg%’ AND errorType like ‘%EndpointNot%’ SINCE 7 days ago

7. Index Exception on Prod US :

SELECT Count(*) FROM Transaction WHERE appName LIKE ‘Prod_%’ AND appName NOT LIKE ‘Prod_EU%’ AND errorMessage LIKE ‘%index was%’ SINCE 7 days ago