Web Development Business

Quick Introduction To SQL Server Profiler

Brian Clay .NET, Databases, Technology Snapshot, Tutorial Leave a Comment

When working with SQL Server, you might run across a situation where it is just not running fast enough. While there could be many reasons for this, there are tools that can help you track down just what is going on behind the scenes. SQL Server Management Studio’s SQL Server Profiler or just (Profiler) is a tool that can be used to monitor queries run on your database.

In this blog post I’ll give a brief demonstration of the SQL Server Profiler tool. I’ll show you how to keep an eye on all the queries that are being run against your database, as well as how to use a filter to narrow your search to just slower-running queries…