Whenever I’m trying to debug a problem using sp_whoisactive or Extended Events (XE) and I see either
Core Microsoft SqlClient Data Provideror
.Net SqlClient Data Provider, my blood begins to boil.
It means I’ll probably spend hours asking around to try and find the owner. Sometimes knowing the
host_namehelps, but there can be a multi-purpose host that runs many applications – which one is having the problem?
How do you set the name? Read the post to find out.