In production database, i have few tables which are consuming much time or it goes out with time out for a simple select and update queries. Please suggest what and all i need to check and what has to be done to resolve this. As these fetching takes more time, the application gives time out error.
I have restarted the sql server and agents. I also tried with taking a full backup of the database, even after it has the same problem. Please suggest what and all i have to do to get rid out of this.