Improving SQL Performance in Servicedesk Incident Management

Products

• ServiceDesk

Issue/Introduction

 

Resolution

The attached pdf file documents the problem that can occur on heavily loaded Servicedesk servers, and their related SQL database servers.  Specifically, there is a stored procedure, SP_SaveExchangeMessage, which executes often during the incident management process.  The attached document outlines a process to reduce those executions and improve performance for your Servicedesk environment.