When a SQL MDB is used for CA Service Desk Manager (CA SDM), how is the TEMPDB database used?

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

 How is the TEMPDB database used in CA Service Desk Manager. 

 

Environment

CA Service Management 17.X

Resolution

Answer

Microsoft SQL Server uses the TEMPDB database as a scratch area for MDB temporary tables, sorting, subqueries, and so forth.

The size of the TEMPDB database should be increased based on available disk space and expected usage. Microsoft SQL Server adjusts the size incrementally over time.

There are no settings within CA SDM to control the size of the TEMPDB database- this is controlled by SQL server.

The following Microsoft article provides ways on ow to control the size of the TEMPDB database:

https://support.microsoft.com/en-us/kb/307487