What are the main events and columns helpful in troubleshooting perfor

1.	What are the main events and columns helpful in troubleshooting performance issues using a profiler?
Answer» Events: Event Group: Performance Event: ShowPlan_ALL (BinaryData COLUMN must be SELECTED) Event: ShowPlan_XML Event Group: T-SQL Event: SQL:BatchStarted Event: SQL:BatchCompleted Event Group: Stored Procedures Event: RPC:Completed Event Group: Locks Event: Lock: Deadlock Graph Event: Lock: Lock Deadlock Chain (Series of events that leads to a deadlock) Event Group: Sessions Event: Existing Connection Event Group: Security Audit Event: Audit Login Event: Audit LOG Out Columns: Below are the most common columns that HELP us in understanding the trace file to troubleshoot the problems. TextData ApplicationName NTUserName LoginName CPU Reads Writes Duration SPID StartTime EndTime Database Name Error HostName LinkedServerName NTDomainName ServerName SQLHandle All these columns need not be available for all of the events but depend on the event select we have to choose the appropriate columns. Filters: ApplicationName DatabaseName DBUserName Error HostName NTUserName NTDomainName

What are the main events and columns helpful in troubleshooting performance issues using a profiler?

Answer»

Events:

Event Group: Performance

Event Group: T-SQL

Event Group: Stored Procedures

Event Group: Locks

Event: Lock: Deadlock Graph
Event: Lock: Lock Deadlock Chain (Series of events that leads to a deadlock)

Event Group: Sessions

Event Group: Security Audit

Columns:

Below are the most common columns that HELP us in understanding the trace file to troubleshoot the problems.

All these columns need not be available for all of the events but depend on the event select we have to choose the appropriate columns.

Filters: