Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuNí thacaítear leis an mbrabhsálaí seo a thuilleadh.
Uasghrádú go Microsoft Edge chun leas a bhaint as na gnéithe is déanaí, nuashonruithe slándála, agus tacaíocht theicniúil.
Applies to:
SQL Server
Azure SQL Managed Instance
SQL Server Profiler shows how SQL Server resolves queries internally. This allows administrators to see exactly what Transact-SQL statements or Multi-Dimensional Expressions are submitted to the server and how the server accesses the database or cube to return result sets.
Using SQL Server Profiler, you can do the following:
Create a trace that is based on a reusable template
Watch the trace results as the trace runs
Store the trace results in a table
Start, stop, pause, and modify the trace results as necessary
Replay the trace results
Use SQL Server Profiler to monitor only the events in which you are interested. If traces are becoming too large, you can filter them based on the information you want, so that only a subset of the event data is collected. Monitoring too many events adds overhead to the server and the monitoring process, and can cause the trace file or trace table to grow very large, especially when the monitoring process takes place over a long period of time.
Nóta
Trace column values greater than 1 GB return an error and are truncated in the trace output.
Topic | Description |
---|---|
SQL Server Profiler Templates | Contains information about the predefined trace templates that ship with SQL Server Profiler. |
Permissions Required to Run SQL Server Profiler | Contains information about the permissions that are required to run SQL Server Profiler. |
Save Traces and Trace Templates | Contains information about saving trace output and about saving trace definitions into a template. |
Modify Trace Templates | Contains information about modifying trace templates by using SQL Server Profiler or by using Transact-SQL. |
Start a Trace | Contains information about what happens when you start, pause, or stop a trace. |
Correlate a Trace with Windows Performance Log Data | Contains information about correlating Windows performance log data with a trace by using SQL Server Profiler. |
View and Analyze Traces with SQL Server Profiler | Contains information about using traces to troubleshoot data, displaying object names in a trace, and finding events in a trace. |
Analyze Deadlocks with SQL Server Profiler | Contains information about using SQL Server Profiler to identify the cause of a deadlock. |
Analyze Queries with SHOWPLAN Results in SQL Server Profiler | Contains information about using SQL Server Profiler to collect and display Showplan and Showplan Statistics results. |
Filter Traces with SQL Server Profiler | Contains information about setting filters on data columns to filter trace output by using SQL Server Profiler. |
Replay Traces | Contains information that explains what replaying a trace means and what is required to replay a trace. |
Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuOiliúint
Deimhniú
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Doiciméadúchán
Templates - SQL Server Profiler
Learn about the predefined templates SQL Server Profiler provides and how to use them. See how to create user-defined templates and change the default template.
Create a Trace Template - SQL Server Profiler
Discover how to create a new trace template in SQL Server Profiler. Learn how to add filters to the template and how to add or remove events and data columns.
Create a Trace - SQL Server Profiler
Learn how to capture event data in SQL Server Profiler by creating a trace. Read about the various options you can specify for traces.