Platform Performance

 

Topics

1. Objective is to find the bottleneck. Is there something slowing loading a project. 
2. Indexing
3. Related Lists - with many records or loading synchronizing
4. Can we produce reports from System Logs -> Transactions ?

Platform Performance Metrics

How long does it take to load a form?

1) There is a little clock in the bottom right - Click on it :)
2) System Logs -> Transactions (Check for response times for a specific Project)
Look for the sys_id of the project. Show the column "View" - shows which view is loading
e.g. https://xxx.service-now.com/syslog_transaction_list.do?sysparm_query=sys_created_onONToday%40javascript%3Ags.beginningOfToday()%40javascript%3Ags.endOfToday()%5EurlLIKE6441ab2a1b492c1800a9117a3b4bcb60%5Etype%3Dform%5Esys_created_by%3Dadm-joe.jarrett&sysparm_view=
3) Another way is to open the project and the Developer Console F12. Click on Network and reload the Project
4) https://xxx.service-now.com/now/nav/ui/classic/params/target/%24pa_dashboards_overview.do
Go to Dashboards and search for "ServiceNow Performance" -> Here you see CPU, Database, UI Transactions, Response Time, Semaphores, events, etc
5) Use "Debug"

Understanding the Response Times

Response time(ms): 5810, Network: 3, server: 3467, browser: 2340
https://docs.servicenow.com/bundle/rome-platform-user-interface/page/use/common-ui-elements/concept/c_ResponseTimeIndicator.html#:~:text=Click%20the%20clock%20icon%20again,tooltip%20with%20the%20response%20time.

How can I get metrics on related lists loading?

1) If a related list has a large number of records, consider limiting the number that are displayed originally -> Done
2) For everyone -> By default, ServiceNow loads related lists synchronously, which means that the entire form, including related lists, must be loaded before the user can interact with it. The glide.ui.defer_related_lists system property allows you to modify this behavior. When set to true, the related lists are not loaded automatically when the form loads. I tried this in DEV and couldnt see what difference it made when I openned a Project.
3) A User -> can go to "Preferences" and select "Display" and select an option under "Load related lists in Classic forms". sys_user_preference.list glide.ui.related_list_timing

Indexing

Both the indexes have the same purpose one at the application level and the other at the database level.

Text index -> Enables search on a field

In sys_dictionary.list there is the "Text index" field
-> Text indexing is what allows you to search on text fields for a table. If you want to be able to search, you need to activate text indexing on the table. It really has nothing to do with performance.
https://www.servicenow.com/community/now-platform-forum/what-is-text-index-and-database-index-purpose-of-those/m-p/1091737

no_text_index=true set in sys_dictionary attributes column. We have none in fenaco Servicenow
Good article to explain it -> https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0859922

Database Index -> This has an impact on Performance

Go to System Definition -> Tables and scroll to the bottom (sys_db_object)
Its all here -> https://www.servicenow.com/community/now-platform-forum/what-are-text-index-database-index-how-to-create-the-both/m-p/1194435

Like all databases, MySQL is designed to handle large volumes of information in the most efficient manner possible. To do this, MySQL has a concept known as indexes. These work very much like the index in the back of a book. Instead of flipping through every page looking for something, a quick trip to the index can let you find all the references for a subject in one spot. In the same way, table indexes increase the speed of database queries

Potential Reasons for slowness

Troubleshooting Slow Performance - Support and Troubleshooting (servicenow.com)

Other stuff to do with Platform performance

Connection Test -> Output from the Network
https://xxx.service-now.com/connection_test.do


Comments

Post a Comment

Popular posts from this blog

Email Templates and Emails

 Email Templates and Emails Email Templates Links: To create a link, click on the link icon and in the URL add the link without the instance. e.g. /now/nav/ui/classic/params/target/pm_project.do%3Fsys_id=${sysapproval.sys_id} For approvals it will act on the table: Approval (sysapproval_approver) Use this type of syntax for getting variables when its to do with a Project: ${sysapproval} -> Gives the project number Approval Sys ID: ${sys_id} -> Gives the Approval Sysid ${sysapproval.sys_class_name} -> e.g. "Project" ${URI} -> Takes you to the approval record ${sysapproval.URI} -> Link to the project URL: sysapproval_approver.do?sys_id=${sys_id} Project sysid:  ${sysapproval.sys_id} Subject : ${sysapproval.short_description} Description : ${sysapproval.description} Click here to view Approval Request: ${URI} Click here to view ${sysapproval.sys_class_name}:  ${sysapproval.URI} Priority: ${sysapproval.priority} Category: ${sysapproval.category} Click...
Read more

Arrays

// Single Array - Push single values into an array.  // If there is a field which doenst have a single value but comma seperated values then split it and adds it to the arra y var x = 0; var st = ''; var ar = new Array(); var gr = new GlideRecord('cmdb_ci_service'); gr.addEncodedQuery("u_search_tagsISNOTEMPTY"); gr.query(); while (gr.next()) {   x++;   // gs.print(x + "  " + gr.u_search_tags);  // e.g.  Azure, Joe, Harry, OR Azure   st = gr.u_search_tags;   st = st.replace(/,\s*$/, ""); // Remove the last comma and any spaces if there are any   // Does it have a comma   if (st.indexOf(',') != -1) {     var sts = st.split(',');     for (var i = 0; i < sts.length; i++) {       //gs.print("----  " + x + "  --" + i + "  --" + sts.length + "  " + sts[i]); e..g        ar.push(sts[i]);       if (sts.length - 1 != i) {         x++; ...
Read more

ServiceNow tips

Logging gs.info("JJJJ " + JSON.stringify(taskCreate)); Default columns Go to List Layout Script to pad out a number to 7 digits var z = '' ; var x = 10 ; var gr = new GlideRecord ( "alm_hardware" ); //gr.setLimit(20); gr . query (); while ( gr . next ()){ x ++; z = padDigits ( x , 7 ); z = "R" + z ; gr . asset_tag = z ; gr . update (); //gs.print (z); } gs . print ( "DONE" ); function padDigits ( number , digits ) { return Array ( Math . max ( digits - String ( number ). length + 1 , 0 )). join ( 0 ) + number ; } Quick way to get GlideRecord var grpRec = new GlideRecord('sys_user_group'); grpRec.get(current.group); var grpMgr = grpRec.getValue('manager'); if (grpMgr != gs.getUserID()) { current.setAbortAction(true); gs.addErrorMessage('You must be a Group Manager to add members'); } var msg = gs . getMessage ( 'Hello' ) ; gs . addInfoMessage ( msg ) ; Dates Get the last day of t...
Read more