I have a SQL Server running about 3 databases. 1 is hit pretty hard from time to time by our data analysts. Every now and then that single database begins to respond very slowly to queries that make it hard to work with. When this happens a reboot of the server after hours will resolve the issue for them. Is there a better way to handle this without rebooting the server or that won't affect the other databases?