When empty, application name is set to the default “SQLTest Workload: 1 Connection: 1 (SQLWorkshops\SQL2012) Thread: 1”, where the workload, connection and thread number are derived from connecting thread properties.
When not empty, the specified application name prefix is added to the default application name.
For example, application name prefix of “LoadTest1” will lead to “LoadTest1, SQLTest Workload: 1 Connection: 1 (SQLWorkshops\SQL2012) Thread: 1” as the application name.
To observe the application name during workload execution, one can execute the below SQL statement in SQL Server management Studio.
select program_name from sys.dm_exec_sessions
where is_user_process = 1
Please help us improve this page by entering your comments and suggestions below: