Is SQL Server Profiler in Azure Data Studio?

Introduction Do we have the SQL Profiler in Azure Data Studio? In a previous article, we compared SSMS and Azure Data Studio. Now we will compare the new SQL Profiler against the old one. If you check the SQL Server Profiler documentation, you will find that SQL Profiler is deprecated and that that feature will […]

Data Mining Part 24: SQL Profiler and Data Mining

In this chapter we will detect the Data Mining activity using SQL Server Profiler.

Data Mining Part 24: SQL Profiler and Data Mining

In this chapter we will detect the Data Mining activity using SQL Server Profiler.

Reading, Writing, and Riskmetic

Mastering SQL Server Profiler

SQL Server Profiler can troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive table/index scanning, and a lot more. Brad's book will allow you to master the use of this versatile tool.

Read large C2 Audit Mode trace files

Here's a set of scripts that allow you to save pertinent information from SQL Server Profiler trace files.

Get a Descriptive Name for SQL Server Analysis Services Profiler Event Class and Event Subclass

A customer provides an SQL Server Analysis Services trace file to analyze. You save this file into a trace table and execute T-SQL code to analyze the results. Rather than getting descriptive values for the EventClass and EventSubclass data, you get numerical values. How do you resolve these numerical values to meaningful descriptive names? Check out this tip to learn more.

Server-Side Trace Pack

Loads temporary stored procs that assist in running and monitoring server-side tracing.

Profiler

SQL Server Blocking Monitoring

Monitoring blocking can be problematic when you cannot catch it in the act. This article will show you an easy way to configure a SQL Server Profiler Trace to monitor blocking