Tech Off Thread

1 post

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

SQL IX lock

Back to Forum: Tech Off
  • User profile image

    I have a SQL view that grabs data from various tables. One of those tables is table Y. The view is kinda slow and while the view is running I am unable to run any update statements on table Y. So I ran a stored procedure to view the current locks on the SQL server while the view is running. There was an IX lock on table Y. Now this view is only used to "View" data; why would the SQL server lock that table while it's running? Is there anything I can do to prevent this from happening? :/

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.