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?