Use of SQL Server Profiler

use of SQL Server Profiler

Open the System main Menu--sqlserver several---performance tools--->>sql server Profiler; you got it? Brother Wait for you, give you a picture of open him, let you see.

Then the file--new trace--Displays the Tracking Properties window

First of all, the select% is a screening and monitoring textdata. That percent is a wildcard, and what he means is to filter the statements of the select openings. Of course you can define it yourself, like update%,delete% ...

Take the line that excludes the value, and then OK, run. Then run a select in the database. You'll find him detected.

Each column to the right, starting from EventClass, I'll tell you what it is.

Event classification, request statement, application name, operating system user, database user, CPU occupancy, read database times, write database session, execute script time, application process number, start time, end time, etc.

Event selection, you put the mouse up, he has the Chinese comments below. Take a good look at it and pick up the event according to your own needs.

Then the file-->> saved as, you can save these monitored data as a file, or a data table.

Analysis:

1. Find the longest-lasting query

Use of SQL Server Profiler