Platform performance The perceived performance of your ServiceNow instance is made up of certain components. Troubleshooting performance by monitoring and diagnosing the following components helps to ensure system optimization. Application server response: Time for the application server to process a request and render the resultant page. Network latency and throughput: Time for the network to pass your request to the server and to pass the response back. Browser rendering and parsing: Time for your browser to render the HTML and parse/execute Javascript. Instance cache: The amount of system resources available for processing. Instance cache effects on performance There is a performance degradation whenever you purge and rebuild the instance cache. During core business hours, avoid or minimize any of the following actions that cause a purge and rebuild of the instance cache. Adding or updating system properties Adding or updating dictionary entries Committing update sets Adding or updating translations Transaction log response timesThe instance automatically logs the vital statistics of every transaction it processes, and that information is available to you as an administrator.Network response timesTroubleshooting a poor network response time can be difficult, but there are certain quick tests you can perform.Browser settings and performanceDepending on the browser you use, browser settings can affect the peformance of your instance.Database performance tuning toolsTo aid in performance evaluation, the Stats Tools diagnostics plugin records statistics for system activities that affect performance. System activities include execution of queries, scripts, and transactions. Use a slow query logAdministrators can use slow query logs to gain insight into how queries are affecting platform performance. The Slow Queries log aggregates data for similar queries. Use slow query data to evaluate the need for new indexes, changes to existing indexes, or changes to frequent queries.Transaction cancellationA user can cancel a transaction that takes longer than expected to load. Import set performanceAn algorithm is used to transform import sets from their staging table into their final destination.Thread performance monitoringPerformance of individual threads is tracked by the instance. Administrators can view thread performance information.Performance metricsYou can view a wide range of performance metrics for your instance and for the machine on which your instance is running. The information is displayed in a graphical format.System diagnosticsAdministrators can use the system diagnostics page to look for root causes of platform performance issues.Table rotationTable rotation preserves instance performance and averts risk associated with querying growing data sets by using the External Communication Channel (ECC) Queue and the sys_created_on field to separate data sets into multiple tables based on date.Task table flatteningWithin the ServiceNow platform, a logical table, such as the task list, represents one or more physical tables in a relational database.Add a module to test connection speedA connection test can indicate the connection speed between your computer and your ServiceNow instance. A connection speed test (/connection_test.do) is available as a UI page.This ServiceNow instancePerformance graph statistics are attached to the This ServiceNow instance business service. These statistics are the ones you can see on the Admin homepage when you add a Performance Graph Controls widget, and then add one or more performance graphs.Transaction quotasTransaction quotas allow you to define a quota policy for different types of transactions. A transaction quota cancels any transaction in violation of the policy and notifies the user of the cancellation.Application quotasYou can set a limit on the number of events or jobs that can run in an application scope within a specified time. Use table extensionThis example shows you how to set the Table Extension parameter to a table rotation group.
Platform performance The perceived performance of your ServiceNow instance is made up of certain components. Troubleshooting performance by monitoring and diagnosing the following components helps to ensure system optimization. Application server response: Time for the application server to process a request and render the resultant page. Network latency and throughput: Time for the network to pass your request to the server and to pass the response back. Browser rendering and parsing: Time for your browser to render the HTML and parse/execute Javascript. Instance cache: The amount of system resources available for processing. Instance cache effects on performance There is a performance degradation whenever you purge and rebuild the instance cache. During core business hours, avoid or minimize any of the following actions that cause a purge and rebuild of the instance cache. Adding or updating system properties Adding or updating dictionary entries Committing update sets Adding or updating translations Transaction log response timesThe instance automatically logs the vital statistics of every transaction it processes, and that information is available to you as an administrator.Network response timesTroubleshooting a poor network response time can be difficult, but there are certain quick tests you can perform.Browser settings and performanceDepending on the browser you use, browser settings can affect the peformance of your instance.Database performance tuning toolsTo aid in performance evaluation, the Stats Tools diagnostics plugin records statistics for system activities that affect performance. System activities include execution of queries, scripts, and transactions. Use a slow query logAdministrators can use slow query logs to gain insight into how queries are affecting platform performance. The Slow Queries log aggregates data for similar queries. Use slow query data to evaluate the need for new indexes, changes to existing indexes, or changes to frequent queries.Transaction cancellationA user can cancel a transaction that takes longer than expected to load. Import set performanceAn algorithm is used to transform import sets from their staging table into their final destination.Thread performance monitoringPerformance of individual threads is tracked by the instance. Administrators can view thread performance information.Performance metricsYou can view a wide range of performance metrics for your instance and for the machine on which your instance is running. The information is displayed in a graphical format.System diagnosticsAdministrators can use the system diagnostics page to look for root causes of platform performance issues.Table rotationTable rotation preserves instance performance and averts risk associated with querying growing data sets by using the External Communication Channel (ECC) Queue and the sys_created_on field to separate data sets into multiple tables based on date.Task table flatteningWithin the ServiceNow platform, a logical table, such as the task list, represents one or more physical tables in a relational database.Add a module to test connection speedA connection test can indicate the connection speed between your computer and your ServiceNow instance. A connection speed test (/connection_test.do) is available as a UI page.This ServiceNow instancePerformance graph statistics are attached to the This ServiceNow instance business service. These statistics are the ones you can see on the Admin homepage when you add a Performance Graph Controls widget, and then add one or more performance graphs.Transaction quotasTransaction quotas allow you to define a quota policy for different types of transactions. A transaction quota cancels any transaction in violation of the policy and notifies the user of the cancellation.Application quotasYou can set a limit on the number of events or jobs that can run in an application scope within a specified time. Use table extensionThis example shows you how to set the Table Extension parameter to a table rotation group.
