SQL Server Profiler

Ok - I’m probably the last one on the planet to know this - but just in case I’m not - I thought I’d share.

I’ve been trying to debug an issue with a .Net application. I don’t have access to the source code, and the application was throwing an error with a SQL statement.

I needed some way to see what SQL was being executed so I could see if there was a way to fix it on the data side. Turns out you can use SQL Server Profiler to monitor SQL calls being run against the database. I ran this - watched as the SQL came in, and was able to find the problem in a few minutes.

Again - I’m probably the last one to discover this. I wonder if MySQL has anything like this?

Raymond Camden's Picture

About Raymond Camden

Raymond is a developer advocate for Extend by Auth0. He focuses on serverless and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support.

Lafayette, LA https://www.raymondcamden.com

Comments