Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Unanswered: session/shared locks

    hi,
    recently i found that on one of the remote test databases servers there were about 2575 session/shared locks held on three tables each in different database.
    these three tables are most frequently used. The problem was with the application, the developers had opened the connection but had not closed the connection anywhere in the application.
    I found that, when i tested some report queries on my local machine and on this test server with the same data, the results on my local machine was faster.
    I would like to have your view on how shared/session locks affect the performance of the queries.

    Regards,
    Harshal.
    Last edited by harshal_in; 05-04-04 at 02:55.

Posting Permissions

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