I'm looking to bag Perfmon for diagnosing SQL problems. Has anyone found or used a good third party tool for SQL monitoring? I used a trial version or Spotlight on SQL Server today and it's looks pretty good. Is there anything better out there before I start doing some research on the net? Has anyone tried a DEMO of MOM (Microsoft Operations Manager) along with the SQL pack? I have a demo of this which I will try. Any insights will be appreciated. Should I write my own transact sql code to monitor anything specific?
I would say nothing is really missing from perfmon or profiler. I guess I want something that can get me all of the info I need quickly in one location. Spotlight looks okay but it might not look that attractive if the cost is too high. What would be real nice is some real time sp_who that could also show me the code that is running within the spid quickly. Things on a Trading floor happen fast. Traders want things fixed yesterday when they break. I work for AIG Trading in Greenwich CT, we trade Foreign Currency, Precious Metals and Energy and it's a real circus.