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? :/
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.