When troubleshooting slowdowns, it is always helpful in knowing who is connected. Luckily there are dynamic management views that provide insight into connection information.
The following query groups the connections according the program that is connected to SQL Server. This information can be spoofed however using a connection string. When running this query, [...]
Archive of posts tagged Add new tag