Ó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
You can run SQL Server Profiler in several different ways, to support gathering trace output in various scenarios. You can start SQL Server Profiler from the Windows Start menu, from the Tools menu in Database Engine Tuning Advisor, and from several locations in SQL Server Management Studio.
When you first start SQL Server Profiler and select New Trace from the File menu, the application displays a Connect to Server dialog box where you can specify a SQL Server instance to connect to.
You can start SQL Server Profiler from several locations in SQL Server Management Studio. When SQL Server Profiler starts, it loads the connection context, trace template, and filter context of its launch point. SQL Server Management Studio starts each SQL Server Profiler session in its own instance, and Profiler continues to run if you shut down SQL Server Management Studio.
In Query Editor, right-click and then select Trace Query in SQL Server Profiler.
Nóta
The connection context is the editor connection, the trace template is TSQL_SPs, and the applied filter is SPID = query window SPID.
When you start SQL Server Profiler in SSMS 20 from the Query Editor, the connection context isn't loaded, and a trace isn't automatically configured. You must manually create a trace and start it.
In Activity Monitor, click the Processes pane, right-click the process that you want to profile, and then click Trace Process in SQL Server Profiler.
Nóta
When a process is selected, the connection context is the Object Explorer connection when Activity Monitor was opened. The trace template is the default based on the server type, and the SPID equals the SPID for the selected process.
SQL Server Profiler overview
Use SQL Server Management Studio
Ó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
SQL Server Profiler - SQL Server Profiler
Explore the features of SQL Server Profiler. Get help troubleshooting problems by using this tool to create traces and analyze and replay trace results.
SQL Server Profiler Templates and Permissions - SQL Server Profiler
Learn how SQL Server Profiler works, how to use it to trace events, and where to find more information on its features.
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.