Recommendations for Optimal Instance Performance

[GTSPerformance]

Performance is a matter that we can all agree on. We are sure customers and admins alike are not ecstatic when they receive notification of a default semaphore exhausted, instance response time high, or abnormal SQL response time alerts from Technical Support. In a perfect world, we would all want every single customer production environment to perform up to potential all the time. Unfortunately, this expectation breaks down in the face of reality. The truth is that every instance will deal with performance issues from time to time. The good news is that there are tools, methods, and information at the disposal of every single person desiring to improve their instance.

This article and the linked articles below are written by the Global Technical Support Performance team. We are a cross functional group of ServiceNow employees in the Technical Support department who live and breath the performance world. Many of ServiceNow's largest customers have benefited from the lessons presented in the documents below and we believe these lessons should be in the hands of every single person implementing ServiceNow.

Instance Performance Maintenance	Data Maintenance & UI Design	Server Side Scripting	Building Efficient Queries	IntegrationPerformance
Performance Maintenance and Administration Viewing statistics (xmlstats.do & stats.do) for all my nodes?	Maintaining Task table Growth Demystifying table rotation, extension, and table cleaner Optimizing the Service Portal Typeahead search widget Reducing the burden of home pages	Performance Best Practices for Server-side Coding in ServiceNow Performance Best Practice for Before Query Business Rules Caching data to improve performance Performance Best Practices for Coding Comma Separated Lists	Best Practice for Building Efficient Queries Improving Slow OR and JOIN Queries	Outbound Integrations Using SOAP / REST: Performance Best Practices An Introduction To The Batch REST API (/api/now/batch) Controlling session utilization from inbound integrations (sticky sessions)

Lets ensure all implementers of ServiceNow are equipped to build with performance in mind by bookmarking this article (and/or the linked KB) and sharing it with everyone who cares about performance; which should be anyone working on a ServiceNow Instance. The content in this KB will be updated as new information and methods are provided. We hope you will adopt the guidance in these articles as you establish your own quality control standards including Peer Review Checklists and the like.

This article is maintained by the ServiceNow Performance team in Global Technical Support. We are a cross-functional group of experts working at ServiceNow in the Support department. We are located around the world but share a passion to help our customers solve their performance issues! If you have questions about the content of this article or the linked articles, you can ask a question directly on the community by adding a “comment” and we will try to respond. However, if you have urgent questions or specific issues, please see the list of resources in the Bio section of our profile page: ServiceNowPerformanceGTS

Best regards,

Your Performance Team

Mirror article on ServiceNow Support Portal: KB0952746 - Performance Recommendations for Best Instance Management

[Michael83]

What a great series team! I'm glad I stumbled upon this.