Post reply

Track t-sql Queries

  • October 29, 2008 at 7:23 am

    #195095

    What is the best way for an admin to track t-sql qieries executed on the box, I am looking for an option where i can find users and their queries running as there are many developers who just exec queries without knowing thier impact on the box.

  • October 29, 2008 at 8:45 am

    #891261

    Idera Diagnostic manager does a good job for us with putting the history in a database.

    But, you can accomplish this with a Server-Side trace.

    Read up on SQL Profiler, and how to run server-side rather than Client-based, and capture the TSQL event SQL:StntCompleted with the columns for duration, NT User, etc.

    God Bless,

    Thomas

    Thomas LeBlanc, MVP Data Platform Consultant

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply