Setting Up System Health Monitoring for SyteLine
SyteLine system health monitoring tracks the vital signs of your ERP infrastructure—SQL Server performance, IIS responsiveness, application server availability, and business process throughput. Without proactive monitoring, administrators only discover problems when users start calling, by which time the issue has already impacted operations. A comprehensive monitoring setup detects degradation early, alerts the right people, and provides diagnostic data that accelerates root cause identification.
SQL Server Performance Monitoring
The SQL Server database underpinning SyteLine is typically the first bottleneck to manifest under load. Key metrics to monitor include CPU utilization, memory pressure (buffer cache hit ratio, page life expectancy), disk I/O (read/write latency, queue depth), and query performance (long-running queries, blocking chains, deadlocks). SQL Server's Dynamic Management Views (DMVs) provide real-time access to these metrics, and tools like SQL Server Management Studio's Activity Monitor, SQL Sentry, or SolarWinds DPA provide dashboards and alerting. For SyteLine-specific monitoring, track the execution time of frequently called stored procedures and the growth rate of the transaction log to detect unusual activity patterns.
- Monitor SQL Server CPU via sys.dm_os_ring_buffers and alert when sustained CPU exceeds 80% for more than 5 minutes
- Track Page Life Expectancy (PLE) through sys.dm_os_performance_counters—alert when PLE drops below 300 seconds indicating memory pressure
- Monitor disk latency using sys.dm_io_virtual_file_stats—alert when average read latency exceeds 20ms or write latency exceeds 10ms
- Detect blocking chains using sys.dm_exec_requests and sys.dm_os_waiting_tasks—alert on blocks lasting longer than 30 seconds
- Schedule weekly index maintenance (reorganize/rebuild) using the Ola Hallengren maintenance solution to prevent index fragmentation degradation
Application Server and IIS Monitoring
The SyteLine application server (Mongoose process) and IIS web server are the middleware layer between users and the database. Monitor the Mongoose Windows service for availability, memory consumption, and thread pool utilization. IIS metrics include active requests, request queue length, application pool recycling events, and HTTP error rates. The SyteLine Application Server log (SLAppServer.log) captures runtime errors, IDO exceptions, and performance warnings that indicate emerging issues. Configure Windows Performance Monitor (PerfMon) counters or integrate with monitoring tools like PRTG, Nagios, or Azure Monitor for continuous tracking with threshold-based alerting.
- Monitor the Mongoose Windows service (SyteLineAppServer) status and auto-restart on failure using SC failure recovery actions
- Track IIS application pool memory and recycle events using the W3SVC performance counters in Windows Performance Monitor
- Set alerts on IIS request queue length > 10 indicating the application server cannot process requests fast enough
- Monitor SLAppServer.log for ERROR and CRITICAL entries using a log monitoring agent (Datadog, Splunk, or Windows Event Forwarding)
- Configure HTTP health check endpoints that verify SyteLine web client responsiveness every 60 seconds from the monitoring tool
Business Process KPI Monitoring
Beyond infrastructure metrics, monitor SyteLine business process health indicators that signal operational issues before they become crises. Track daily transaction volumes (orders entered, shipments posted, invoices generated), queue depths (unprocessed EDI documents, pending approvals), and process timing (MRP run duration, cost rollup execution time). Abnormal patterns—a sudden drop in order entry volume, a spike in EDI errors, or MRP taking twice as long as usual—indicate problems that infrastructure monitoring alone would miss. Build a SyteLine operations dashboard that displays these KPIs alongside infrastructure metrics for a complete health picture.
- Track daily transaction counts from key tables (SLCos, SLShipments, SLInvHdr) and alert on deviations > 30% from rolling average
- Monitor EDI inbound queue depth from EDIInbound table—alert when unprocessed documents exceed threshold (e.g., > 50 pending)
- Measure MRP run duration by timestamping the scheduled job and alerting when execution time exceeds 150% of historical average
- Track SyteLine background task completion rates from the Background Task Log to detect failed scheduled processes
- Build an executive dashboard combining infrastructure health (green/yellow/red) with business KPIs for daily operations review
Want proactive SyteLine monitoring? Netray's AI agents configure monitoring dashboards, set intelligent alert thresholds, and automate incident response—schedule a demo.
Related Resources
SyteLine Log Analysis and Troubleshooting Guide
Analyze SyteLine application logs, IIS logs, and SQL Server traces to troubleshoot errors. Step-by-step guide for identifying root causes in CloudSuite Industrial.
Infor SyteLineSyteLine Database Backup and Recovery Strategy Guide
Plan database backup and disaster recovery for Infor SyteLine SQL Server environments. Configure full, differential, and transaction log backup strategies.
Infor SyteLineSyteLine Environment Management Guide: Dev, Test, Prod
Manage SyteLine development, test, and production environments with database refresh, configuration sync, and promotion workflows. Complete environment admin guide.