Book Image

Mastering ServiceNow - Second Edition

Book Image

Mastering ServiceNow - Second Edition

Overview of this book

ServiceNow is a SaaS application that provides workflow form-based applications. It is an ideal platform for creating enterprise-level applications giving requesters and fulfillers improved visibility and access to a process. ServiceNow-based applications often replace email by providing a better way to get work done. The book steps through the main aspects of the ServiceNow platform, from the ground up. It starts by exploring the core architecture of ServiceNow, including building the right data structure. To add business logic and control data, and interactivity to user interaction, you will be shown how to code on both server and the client. You will then learn more about the power of tasks, events and notifications. The book will then focus on using web services and other mechanisms to integrate ServiceNow with other systems. Furthermore, you will learn how to secure applications and data, and understand how ServiceNow performs logging and error reporting. You will then be shown how to package your applications and changes, so they can be installed elsewhere and ways to maintain them easily. If you wish to create an alternative simple interface, then explore ways to make ServiceNow beautiful using Service Portal. By the end of the book, you will know the fundamentals of the ServiceNow platform, helping you be a better ServiceNow System Administrator or developer.
Table of Contents (18 chapters)
Mastering ServiceNow Second Edition
Credits
Notice
About the Author
About the Reviewer
www.PacktPub.com
Preface

Finding slow database transactions


The transaction log shows an aggregated performance metric for how long the database is involved. So, how will you know whether the database is struggling for a particular query or whether your reports and lists have inappropriate filters? The Slow Query log gives you valuable insight into how the platform is used. You can access it by navigating to System Diagnostics > Stats > Slow Queries.

The instance uses a concept of total execution time. This is calculated by adding together all the execution times of similar individual transactions. Two transactions are considered similar if their SQL queries are the same, except for the values of the WHERE clause.

Note

As a very simple example, these queries are considered similar since only the value of the WHERE clause changes:

SELECT * FROM task WHERE state = 5; 
SELECT * FROM task WHERE state = 3; 

Note

In contrast, the following queries are not similar since they select different information and...