SQL SERVER – Introduction to SQL Server 2008 Profiler

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 (http://blog.SQLAuthority.com)

2 thoughts on “SQL SERVER – Introduction to SQL Server 2008 Profiler

  1. @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: http://msdn.microsoft.com/en-us/library/cc645993.aspx
    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.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s