Can someone, please explain to me how to troubleshoot out sql server2000 db? We upgraded our server memory to 2g because we thought we had server issues. Then performed maintenance checks on the server. It turned out that our sql server is the problem. We have two apps running on sql server. Both are so slow you could sleep and wake up but the apps are still trying to load. I went to the db, it took forever to open the db. When I try clicking on Meta Data Services, the system hangs. Any help would be greatly appreciated.