SQL Server Profiler

This post is more than 2 years old.

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 HERE Technologies. He focuses on JavaScript, serverless and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support. You can even buy me a coffee!

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