Why do all .Net apps show up as “.Net SqlClient Data Provider” in traces?

Have you ever been asked to get involved in diagnosing a problem for a .Net application only to find that your diagnostic tool of choice shows “.Net SqlClient Data Provider” for all applications running on the database?  I’ve encountered this frequently and it makes filtering out activity to the application of interest difficult.  Fortunately there is a very […]

Read More

Are .Net TransactionScope Objects Creating Serializable Transactions In Your Database?

On more than a few occasions I’ve noticed that systems developed in .Net were running into lock waits due to serializable transactions.  After further research I realized that developers were taking advantage of a feature for managing transactions within their .Net code.  This feature is known as System.Transactions.TransactionScope.  This feature is quite handy when it […]

Read More