Christopher H. Laco

Always Set Application Name In SqlClient Connection Strings

Friday, February 13th, 2009 | Manifesto | Comments Off

If you’re using connection strings on the web, set Application Name to the domain name. If you’re using connection strings with an executable, set Application Name to the executable name. If you have to use SQL Profiler to diagnose performance issues, it will be easier to filter out a specific application or web site.

<connectionStrings>
  <add name="LocalSqlServer" connectionString="... Application Name=mywebsite.com;" />
  <add name="LocalSqlServer" connectionString="... Application Name=myapp.exe" />
</connectionStrings>

Tags: .net, application name, configuration, connection string