connection string
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>