Database Becomes Unresponsive, Admin Console Shows Multiple Logins for Same Individuals
We have had this problem recur increasingly frequently lately, particularly with one of our larger databases. Users will complain that the database has become unresponsive, particularly when moving from one table to another. We will check the admin console; there will be multiple logins listed for the same accounts. We end up having to reboot the physical server. This occurred just last week, and I did a recover on the main file. It happened again this morning at 7:48, and then again just now.
Server is a Windows Enterprise 2007 SP2, 64bit with quad-core & 4 GB of RAM. FMS is 220.127.116.115, although we had the same issue with FMS v11 at this client as well, just nowhere near as frequently.
Anyone have any ideas for things we can try, or what may be causing this?