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)
but i still wonder where to download ‘sql profiler 2008’ as it does not come with standard package…….
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
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