OK - beating my head against the wall here so turning to anyone that can help. Here are a few more symptoms...just to recap:
We recently migrated our courses to our own in-house Moodle on a Windows 2012R2 Server. We use the build v 3.0 with IIS and MySQL
10 GB RAM, 80 GB Hard Disk, 2.67 GHz Processor, dedicated.
Opening the gradebook is not a problem. Opening grader report, usually in under 3 seconds. Single view, any of them just fine.
Scenario #1: Edit the grader report. Collapse the table to show only the information you need. The more grades you change during one session in the grader report, the longer it takes to load. The theme loads, the header loads, it take up to 10 minutes for the table to load!! Performance monitor on Windows Server shows less than 50% during this time.
Scenario #2: Edit a quiz or assignment. Go into the quiz or assignment. Change anything BUT the grade category. If you change the category and click save, be ready to wait at least five minutes.
Scenario #3: Single View Grades. Same thing. Edit nothing and click save, the page reloads fine. Change one grade, the theme and header loads, wait one minute for it to return the page saved. Change 10 grades, wait almost 10 minutes.
Here is the interesting part: Open a new TAB, go to moodle. NOTHING. You cannot open a new moodle page until the grades are finished saving. Doesn't matter which page you attempt. **SO HOW ABOUT THIS** Go incognito on your browser, or open a different browser, say IE. Homepage loads fine and nothing slows down. HOWEVER, DO NOT CLICK THE GRADEBOOK or anything to do with it. If you do, your browser is stuck until the grades save in the original browser window.
So, do we think this is a gradebook thing, Webserver, Moodle setting, MySQL??? I am all ears.
THANK YOU to anyone that read this!