We have an application with SQL 2008 R2 SP1 back end. CPU usage gradually goes up through out the day and then gets to 100% and slow down the application. database size
is about 5 GB ; our server has 8 GB of memory and two CPUs .
we have about 40 users .
any method to start troubleshooting this ? is it safe to run "DBCC FREEPROCCACHE" abd clear CPU cache ?