Posted on Leave a comment

SQL Profiler

Is an optional component of Management Studio since SQL Server 2000 version, a graphical user interface to SQL Trace for monitoring an instance of the Database Engine .
Show you Transact-SQL SELECT, INSERT, UPDATE, and DELETE statements. An other error log

It’s basically a four steps process:
Step 1: Generate a TRACE/LOAD file for selected database. Open SQL Server Profiler. And click in Play
Step 2: Put the cursor an click button in software ERP or LOAD information in Database
Step 3: Automatically show you the event and the name of table and field
Click in Stop and analyze all the information generate

This book talk about Mastering_Profiler_eBook.pdf spend a weekend reading and practicing, and you’ll have locked down the skills on the most important tool in the Sql toolbox.

Actually is a great tool , but have a significant problem a lot of information to analyze RPC event , TSQL , Security Audit

Actuall is Azure Data Studio to adopt Sql Profiler whit XE Extended Event
All the new features in SQL Server like Azure event is tracker by XE Extended Event
This article talk about

The advantage XE is lightweight performance monitoring 

Leave a Reply

Your email address will not be published. Required fields are marked *