I have been tasked with the responsibility of “preventing or resolving as many chronic server issues as posible”. I have come up with a method of running queries aginst our ticketing system, coupled with queries against the server event logs in hopes of detecting trends. At this point I have reached a bit of a sticking point, and was in hopes I might get some extra ideas if I posted it here. Any ideas would be greatly appreciated.