Book a Demo
« previous next »
Pages: [1]

Author Topic: SQL Server locks not being released by EA.  (Read 3069 times)

Daniel Machado

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
SQL Server locks not being released by EA.
« on: December 11, 2008, 03:04:11 pm »
Hi,

We have around 100 users of EA (concurrent users). We use SQL Server as our EA repository.
We have developed an Add-in that loads elements in EA (Use Cases, Classes, Actors, UI Elements etc) developed in C# VS2008. The program loads from 10 elements until over 2000 at a time depending on what the user has selected. The locks are not being released and we are not sure if it is related to the Add-in or if it is a generic issue with EA. Every couple of days or so we have to request the DBA to kill all the locks to make EA behave again - otherwise it becomes very slow.

Would someone have a clue on why the db locks are not being released?

I am not really sure if the locks are not being released by the API OR if the regular use of EA causes these locks not to be release in some scenarios.

Thanks
Daniel
Logged
Pages: [1]
« previous next »