SQL Server Session Management for NAV Environments
Project Overview
SQL Server Session Management for NAV Environments: a Business Central / NAV implementation and support project delivered by Sumit Shede. Designed SQL Server jobs to identify and terminate idle user sessions across NAV environments. Industries: Information Technology, Eye Ware, Retail, Pharma, Printing.
My Role & Contributions
- Designed SQL Server jobs to identify and terminate idle user sessions across NAV environments
- Reduced system blocking and performance issues caused by inactive connections
- Implemented automated cleanup routines for NAV 2009 R2, NAV 2013, and NAV 2016 R2
- Optimized database performance by minimizing session locks and resource contention
- Ensured stable system operations during peak usage by proactive session management