This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 22%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Hi, I have to alter a view. We ran that view in production For some reason, it took 1:05 time. After that jobs depending on that view started failing. No issue with jobs. We thought some issue with view.
We restored old production db backup copy in lower lanes and ran that view, it took a min.
We are trying to understand what would be the issue. How do we fix issue in production? What are all different things need to consider to fix the issue.
Any help is really appreciate
Hi,
Are you sure that your issue is with ALTER the view and not with executing queries on the view?!?
You use the term ALTER view "I have to alter a view", but your description is about running queries on the view "jobs depending on that view started failing" , "ran that view, it took a min"
My guess is that you mean running the view is slow but your message is so confusing
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @dinesh ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi @dinesh ,
In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.
Best regards,
Seeya
We are trying to understand what would be the issue.
Altering a view (or any other database object) requires an exclusive access on it and as long as an other process accesses the view, you can not alter it and have to wait, till no other process accesses it.
Hi @dinesh ,
Welcome to Microsoft Q&A!
jobs depending on that view started failing, ran that view, it took a min
We need to know if the view is being used inappropriately.
1. Check View Dependencies
2. See Actual Execution Plan
3. Try Indexed Views
It can give a performance boost to SELECT statements. But like table indexes, it can impact performance if the base tables are large and continuously updated. Also, check the STATISTICS IO if there’s a decrease in logical reads after adding the index.
For more information, please read this article: https://codingsight.com/top-3-tips-you-need-to-know-to-write-faster-sql-views/
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.