SQL Server Session Management for NAV Environments

Techno-Functional Consultant
SQL Navision
Information Technology Eye Ware Retail Pharma Printing

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

Related Projects

Auto SMS Notifications for Customer Transactions (NAV & Business Central) Navision · Business Central · API View project Excel Reporting Automation using SQL Server SQL · Excel View project GST Localization Patch Implementation (India) Navision · SQL View project
Back to Projects
Sumit's AI Assistant
Ask me anything about Sumit's work

Hi! I'm Sumit's AI assistant. Ask me about his experience, skills, or projects — I'm happy to help!