Results 1 to 2 of 2

Thread: sprpt_Productivity_d_samp

  1. #1
    Join Date
    Aug 2007
    Posts
    177

    sprpt_Productivity_d_samp

    Not sure if this is the correct place for this question, but does anyone else experience severe database performance issues when this procedure is being run?

  2. #2
    Join Date
    Jun 2007
    Location
    Milwaukee, WI
    Posts
    1,207
    What version of CIC are you on? That stored procedure is called by the User Productivity Detail report.The stored procedure doesn't do much so I'm surprised it would be causing issues. The stored procedure is referencing the iAgentQueueStats_NoCnfg view. How much data is in the SQL database, do you purge data? Also do you have jobs to update indexes and statistics as I have seen fragmented indexes cause issues.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •