system sp really slow when fired by Windows Authentification

• GARCIA

  SSC Enthusiast

  Points: 111

  More actions

  October 17, 2005 at 8:09 am

  #110224

  I everybody,

  I'm maintaining a client app using ADO to connect to SQL 2000 through Client cursor and Windows Authentification.

  As expected thousand of sp_indexes_rowset are fired by ADO to get metadata.

  My problem is thoses sp are during a while (over 1000 ms) when they are executed by a Windows Account (Windows 200 AD Domain).

  When sp are executed by a SQL Account they are quite fast (under 100 ms),

  After looking at sp_indexes_rowset code, i think my problem comes from the permissions() function.

  Does anyone can help me or tell me what is doing the permissions function ?

  thanks for your help

  Frederic.

• October 20, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Patrick Trongo

  SSC Enthusiast

  Points: 170

  More actions

  November 22, 2005 at 12:30 pm

  #605307

  I have a simular issue that just "popped up". Ok well maybe I just noticed it. Did anyone ever come up with a reason for this behavior?

  tia