Mastering SQL Trace Using Profiler - Microsoft SQL Server 2012 Performance Tuning - page 19

Now, we will open two instances of SQL Server Management Studio one by one that connect
to SQL Server with the logins James and Peter respectively and run a few queries.
1. Open the first instance of SSMS and connect to SQL Server with the login credentials
of James . In the query window, type and execute the T-SQL statements as shown in
following script:
USE [AdventureWorks2012]
GO
SELECT * FROM [Sales].[Customer]
GO
USE [master]
GO
SELECT * FROM sys.databases
GO
2. Open a second instance of SSMS and connect to SQL Server with the login
credentials of Peter . In the query window, type and execute the same T-SQL
queries as shown in previous step.
3. Switch to SQL Server Profiler window that is running the trace. Examine the trace data
as shown in following screenshot: