SQL SERVER – Introduction to SQL Server 2008 Profiler – Summary

Introduction

SQL Server Profiler is a powerful tool that is available with SQL Server since a long time; however, it has mostly been underutilized by DBAs. SQL Server Profiler can perform various significant functions such as tracing what is running under the SQL Server Engine’s hood, and finding out how queries are resolved internally and what scripts are running to accomplish any T-SQL command. The major functions this tool can perform have been listed below:

  • Creating trace
  • Watching trace
  • Storing trace
  • Replaying trace

Trace includes all the T-SQL scripts that run simultaneously on SQL Server. As trace contains all the T-SQL scripts running on SQL Server, it often tends to become considerably huge. Hence, it is always a good practice to capture only those data that are actually required for analysis.

Dilemma to use on Production Server

SQL Server Profiler has a lot of potential as a tool and offers several advantages. Unfortunately, developers have been keeping their hands off from this tool and usually give two major excuses.

  • Reason 1: Profiler adds too much overhead to production server.
  • Reason 2: Profiler accumulates plethora of data making it extremely intricate to analyze them afterwards.

Read Complete Article here.

Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL Profiler, SQL Utility
Previous Post
SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009
Next Post
SQL SERVER – Leading Zero to Number

Related Posts

2 Comments. Leave new

  • but i still wonder where to download ‘sql profiler 2008’ as it does not come with standard package…….

    Reply
  • Imran Mohammed
    February 2, 2010 10:29 am

    @Singh,

    SQL Server Profiler is installed when you install SQL Server Client tools. It is only available with following Editions of SQL Server 2008.
    1. Enterprise Edition.
    2. Standard Edition
    3. Work Group Edition
    4. Developer Edition
    5. Web Edition

    Source: https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2017
    Check under Development Tools Section.

    Meaning SQL Server Profiler is not available in SQL Server Express edition.

    But there are few free open source software that acts as Sql server profile, they are free to download and use, But I do not know how secure they are, I have not used them.

    So check your edition, which edition of SQL Server have you installed.

    ** Script to check your SQL Server Edition **
    Select Serverproperty (‘edition’) SQLServerEdition

    ~ IM.

    Reply

Leave a Reply

Menu
Exit mobile version