Hi,
Dev server performance was good before restoring the prod server backup files on it. After restoring the backup file on the dev server database is impaired. Both dev and prod server objects are in sink. what could be the reason for it ? should i rerun the sql server rebuild index after restoring the databases ?
Please update your comments on this.
Thanks in Advance.