• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. SQL Server Basics > Introduction to the Profiler

Introduction to the Profiler

The SQL Server Profiler (pictured in Figure 4.30) is a tool that you can use to capture SQL Server events. It allows you to:

  • Diagnose bottlenecks in slow-running queries

  • Determine the cause of deadlocks or blocking

  • Troubleshoot problems between client and server applications

  • Run security audits to record login attempts


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint