This guide will help troubleshoot any database issues related to shift reprocessing. A shift reprocessing time of greater than 15 minutes per shift is taken to be an indication that database maintenance in general and reindexing, in particular, should be undertaken.
This guide uses an SQL script to extract the information. The script is located at the end of this document. The script uses the database: PITRAMReporting.
The time to reprocess a shift is given in the column headed: MinutesToProcess.
- Start SSMS.
- Log onto a server.
- Select New Query.
- Copy the SQL Script to the New Query window
SELECT [SHKEY] ,[Shift] ,[LastReprocStart]
,CAST(DATEDIFF(mi,[LastReprocStart], [LastReprocEnd]) AS VARCHAR) as MinutesToProcess
FROM [PITRAMReporting].[dbo].[SHIFTSUM]
ORDER BY shkey desc
Want to learn more?
Online Help Manuals - Click here for the latest version
Learning Management System - Click here to login or here to request access
Comments
0 comments
Please sign in to leave a comment.