:::: MENU ::::

Purpose and use of profiler

  • Mar 30 / 2009
  • 0
DBA Interview questions, dbDigger, Monitoring and Analysis, SQL Server tools

Purpose and use of profiler

Profiler is very useful tool for repeatable and insight analysis/monitoring of SQL Server database engine, SSAS and SSIS. Profiler is a GUI used to utilize SQL Trace. SQL tarce is a used to capture client-server communication. Profiler may server following major purposes for a SQL Server DBA

  • Query analysis of execution plans
  • Analyze errors and warnings of SQL Server
  • Analyze the user activities
  • Create traces to reuse later also
  • Save trace results for later analysis
Consult us to explore the Databases. Contact us