I have manually started index rebuild on one system and noticed that it goes slower that I would expect. I issued sp_who2 to see what is happening and noticed that some other application is doing backup of the same database I am rebuilding the index. I got frustrated with that fact.
And how would I even know that this backup is scheduled, when this application has its own schedule which is not present in SQL Server, but in this application.
So, I have been thinking that all maintenance should be done in SQL Server. Or, that SQL Server is aware of that maintenance, and if someone is issuing something that SQL Server is not aware then SQL Server would, for example, forbid this action. So, maybe one way of protecting SQL Server (and other systems) would be that all the actions (all or some of them) should be pre-announced.
And how would I even know that this backup is scheduled, when this application has its own schedule which is not present in SQL Server, but in this application.
So, I have been thinking that all maintenance should be done in SQL Server. Or, that SQL Server is aware of that maintenance, and if someone is issuing something that SQL Server is not aware then SQL Server would, for example, forbid this action. So, maybe one way of protecting SQL Server (and other systems) would be that all the actions (all or some of them) should be pre-announced.
No comments:
Post a Comment