Step-by-Step Guide

Tracing statements in SQL Server 2000

In SQL Server 2000:

Create a new trace and choose the following events:

Choose the minimal amount of columns (don't forget to add the DatabaseID):

Note: The data columns shown above, make up the minimum list of necessary columns.

Choose the filters, for example:

  • CPU > 500
  • Duration > 500 (half a second)
  • Reads > 10,000
  • Writes > 5000

    Run the trace and script it:


    • Requires Free Membership to View

    There are Comments. Add yours.

     
    TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

    REGISTER or login:

    Forgot Password?
    By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
    Sort by: OldestNewest

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to: