Hello everyone! I got an OLTP system (for www.realmofempires.com) which I am trying to analize. It appear the SQL server takes the bulk of CPU usage, and althought it could be just load, I wonder if there are tools that I could use to see what (what querry perhaps) taking most time/resources. I have a log of a running times, from client application perspective, of every single call to the database and I am unable to spot some long running querries this way but I optimized almost everything there and I am not sure how to move on. It is possible that without some app redesign i cannot squeeze any more from the server but I doubt it. Likely I have some inneficiencies that I can spot simply by looking at the running time of some querries but I am really not sure how to move on, what to look for. Can anyone suggest any tools, articles, books etc to help me shed some light on this? Many thanks!!