- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2024 08:50 AM
Hello Everyone,
I would like to know how exactly do developers troubleshoot performance issues related to Glide Record queries in ServiceNow? Is there any tools and techniques used?
Solved! Go to Solution.
- 2,216 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2024 09:11 AM
I would suggest you to follow the best practices in scripts And avoid DOM manipulations in client side. Give proper Name to it without duplicates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2024 09:25 AM
Hi @VishaalRanS
To troubleshoot GlideRecord performance issues in ServiceNow, developers use:
- SQL Debugging (System Diagnostics > SQL) to analyze slow queries.
- Script Execution Tracker to track script execution times.
- Slow Query Logs for identifying problematic queries.
- Query Optimization: Use indexed fields, limit results, avoid unnecessary .next() or .updateMultiple().
- Database Indexing: Ensure proper indexing for frequently queried fields.
- Debug SQL Sessions to log SQL activity during testing.
These techniques help identify and optimize slow GlideRecord queries.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2024 03:54 AM
Hi @VishaalRanS
When developers troubleshoot performance issues related to GlideRecord queries in ServiceNow, they focus on identifying inefficient queries that may cause slow response times or increased server load. Here are the tools and techniques commonly used:
Debugging Tools in ServiceNow
Techniques for Optimizing GlideRecord Queries
System Log and Transaction Log
Performance Analytics and Metrics
Review Query Execution Plan
Best Practices:
1.Use cache wisely: In cases where similar queries are repeatedly run, caching the results might reduce query execution time.
2.Avoid large datasets: Where possible, divide large datasets or use pagination to limit the load on the database.
3.Scheduled Jobs: Run heavy or complex queries during off-peak times using Scheduled Jobs to avoid impacting real-time performance.
These tools and techniques, when used appropriately, help ensure that GlideRecord queries are optimized and do not become a bottleneck in the system.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-30-2024 02:48 AM
Hi @VishaalRanS ,
To troubleshoot GlideRecord query performance issues in ServiceNow, developers can use the following tools and techniques:
Tools:
- Debug SQL: Identifies inefficient SQL queries.
- Slow Query Logs: Tracks long-running queries.
- Debug Business Rule: Shows how business rules impact query performance.
- Execution Plan & Script Debugger: Profiles query execution and script performance.
Optimization Techniques:
- Index Fields: Ensure frequently queried fields are indexed.
- Limit Query Results: Use conditions and setLimit() to reduce dataset size.
- Efficient Conditions: Use specific addQuery() filters and avoid complex operations.
- GlideAggregate: Use for aggregate operations instead of looping over records.
These tools and techniques help identify bottlenecks and improve the performance of GlideRecord queries.
Thanks & Regards,
Ramesh
Please mark this response as correct or helpful if it assisted you with your question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2024 09:11 AM
I would suggest you to follow the best practices in scripts And avoid DOM manipulations in client side. Give proper Name to it without duplicates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2024 09:25 AM
Hi @VishaalRanS
To troubleshoot GlideRecord performance issues in ServiceNow, developers use:
- SQL Debugging (System Diagnostics > SQL) to analyze slow queries.
- Script Execution Tracker to track script execution times.
- Slow Query Logs for identifying problematic queries.
- Query Optimization: Use indexed fields, limit results, avoid unnecessary .next() or .updateMultiple().
- Database Indexing: Ensure proper indexing for frequently queried fields.
- Debug SQL Sessions to log SQL activity during testing.
These techniques help identify and optimize slow GlideRecord queries.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2024 03:54 AM
Hi @VishaalRanS
When developers troubleshoot performance issues related to GlideRecord queries in ServiceNow, they focus on identifying inefficient queries that may cause slow response times or increased server load. Here are the tools and techniques commonly used:
Debugging Tools in ServiceNow
Techniques for Optimizing GlideRecord Queries
System Log and Transaction Log
Performance Analytics and Metrics
Review Query Execution Plan
Best Practices:
1.Use cache wisely: In cases where similar queries are repeatedly run, caching the results might reduce query execution time.
2.Avoid large datasets: Where possible, divide large datasets or use pagination to limit the load on the database.
3.Scheduled Jobs: Run heavy or complex queries during off-peak times using Scheduled Jobs to avoid impacting real-time performance.
These tools and techniques, when used appropriately, help ensure that GlideRecord queries are optimized and do not become a bottleneck in the system.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-30-2024 02:48 AM
Hi @VishaalRanS ,
To troubleshoot GlideRecord query performance issues in ServiceNow, developers can use the following tools and techniques:
Tools:
- Debug SQL: Identifies inefficient SQL queries.
- Slow Query Logs: Tracks long-running queries.
- Debug Business Rule: Shows how business rules impact query performance.
- Execution Plan & Script Debugger: Profiles query execution and script performance.
Optimization Techniques:
- Index Fields: Ensure frequently queried fields are indexed.
- Limit Query Results: Use conditions and setLimit() to reduce dataset size.
- Efficient Conditions: Use specific addQuery() filters and avoid complex operations.
- GlideAggregate: Use for aggregate operations instead of looping over records.
These tools and techniques help identify bottlenecks and improve the performance of GlideRecord queries.
Thanks & Regards,
Ramesh
Please mark this response as correct or helpful if it assisted you with your question.