I implemented a script recently that uses an update and search cursor on a large feature class database of over 20,000 records. This script runs nightly. This is an SQL Server database with an ArcSDE connection. However, the physical memory of the server (sqlserver.exe) has been running at over 86% and bogging down any edits that users want to make. Prior to this script, the server was running normally.

The script currently does not delete any cursors, and I'm wondering if this is causing a load up of information in the system. If so, how do I go about deleting the information?

  • be sure after your script finishes it drops the connection. and set to create a new connection in the start of your script – NULL.Dude Jun 23 '17 at 18:41
  • @Joe, that's how I have it as of now. I set up the database connection, then arcpy.ClearWorkspaceCache_management() at the end – saoirse Jun 23 '17 at 18:49
  • it runs nightly after office hours but when does it complete? before the next morning when users log in? – NULL.Dude Jun 23 '17 at 18:53
  • @Joe, that is correct, it starts and ends between 7:30PM-8PM – saoirse Jun 23 '17 at 18:56
  • It would be a lot easier to offer help if you post the script. – Dowlers Sep 12 '17 at 17:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.