• You could pull this off with SQL Server profiler along with some well written queries to pull the server level performance metrics. As far as a third party tool, Spotlight on SQL Server may work. I used to work with a guy that loved it because of the graphical display. Personally, I do all monitoring with Profiler and Windows Perfmon.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden