Estimated members, I had a SQL Server 2008 R2 performing poorly with out SharePoint; I did some minor changes (e.g. stopping a weekly maintenance of statistics rebuild statistics, also a rebuild of tempdb and other non-sense of jobs.) the SQL Server performed perfect for about 4 or more weeks. I had more changes or improvements to accomplish but priorities did not give me the time needed. Now I'm hearing that suddenly performance is an issue because a user introduced the use of AutoCAD in the entire mixed.
I am convinced that it is AutoCAD only I don't know where or how to look to fixed this problem.
This is a physical server with 64GB of RAM and I've proven for 2 days that CPU remains idle at 95%,, my queries indicate that disk I/O is also a non-issue. I basically ask for any help or idea on where to look for or how to look for a simple solution. As I said I have more changes to implement but priorities prevent me to do soo even though these changes are 'not' as significant as the first ones I made.
Thanks so much in advance for any help or ideas you can provide..
Other DBAs are sure the problem is RAM maxim out and having to bounce the server weekly, I do not believe that is a permanent solution.
Again, once again for any prompt reply!!