ananda.murugesan (9/24/2013)
I got call from user side for they are not able to do DML operation
Often These maintenance tasks run at Off-Peak hours.(during nights). so avoid these kinds of conflicts.
Database maintenance such as index reorg or rebuilds will pull a lot into cache, and updating stats will pull about 1% of the data into cache with default settings. These are expected. It’s also why these jobs should be kicked off outside of peak hours for that server.
AND
also you can do thses on some selective tables (scripts can be use to choose them).
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)