Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Which Event Classes i should use for finding good indexs ,statistics and etc to optimise queries and SPs. RE: Which Event Classes i should use for finding good indexs ,statistics and etc to optimise queries and SPs.

  • From books online:

    To build a recommendation of the optimal set of indexes, indexed views, or partitions for your databases, Database Engine Tuning Advisor requires a workload. A workload consists of a Transact-SQL script or a SQL Server Profiler trace saved to a file or table. If you are using a SQL Server Profiler trace file or table, they must contain Transact-SQL batch or remote procedure call (RPC) event classes, and the Event Class and Text data columns.

    That's the only requirements. More columns or events will just bloat the trace file without providing any benefit.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass