We are having a SQL Server R2 Web Edition database, based on Windows Server 2008 R2 with a strong CPU and 32GB RAM DDR3.
Our database works very hard (we run around 600,000 queries in 1 minute) and its CPU is going crazy (25% to 90%).
I was looking after slow queries, found some, fixed them, some other I just canceled to check if it will help, but it didnt, CPU is still very high.
I was wondering what else could it be? I am not a DBA, but I am working with a very experiense one, he create all the indexes and re-configured the DB, but CPU is still very high, and this DBA (with more than 20 year of experiense) is kind of hopeless and dont really know how to find the problem.
I was wondering, could it be caching problem? like that queries are not cached?
Anyone know what can it be? what could we do? how can we investigate it?
Maybe its just the high amount of queries?
I'd love to get every small piece of information you can give!