I have a contractlet right now where somebody (AGAIN) is paying me because they found out that Excel isn't a DBMS. So, they want Access. Since I'm getting back into the market after about 2 years out, this is actually a decent scope for me right now.
Access has been using about 80 percent of my CPU time for the last 20 minutes. My crime? Query|New. I have no idea what the fuck it's doing. This database is fairly big for Access (~900MB), I wish I could use something better but it won't happen. So maybe it arbitrarily decided that now was the time to optimize something. Maybe it's in a loop. Maybe it's background processing SETI data. Maybe it's downloading database porn and gratifying itself. No way of knowing of course, no monitoring, no logs, no current activity to look at, jack shit.
Killing the process would solve the problem if it's just abcess looping or playing with itself or whatever but then I'd have to wait for it to repair the database, which is a lot to ask with a database of this size and a manager of this quality.
Fuck.