I am not a dba, but am hoping I can get some general advice. Here's my situation: Running SQL server 2008 in Win Serv 2008 on a hyper-v VM. We have plenty of ram and cpu for the VM. We are running Sage CRM and Accpac databases on the same instance of SQL server. In Activty Monitor, i am noticing anywhere from 0-8 Waits due to Locks. The locks are for the CRM database and either say pagelock or keylock. These Waits are anywhere from 1000-4000 (is that miliseconds?) which cause the CRM web application (running on IIS in a windows 03 server, also a VM) to tank, or be completely unresponsive. Is there anything that can be tweaked in SQL server, or does this sound like an issue with the CRM application? If I completely reboot the CRM server, it will again function correctly someone does something to create the locks again. Any ideas would be much appreciated! Thanks!