SQL Profiler remains as the client tool. Not only have its components’ names been fine-tuned, but the trace utility’s capabilities have evolved as well.

SQL Server Profiler is a separate application that lets you view the queries being run on the SQL Server database engine in real time as they complete.

The SQL Profiler has a neat Deadlock Graph feature which is very useful. Let’s take a look…. When SQL Server detects a deadlock, it has to do something about it.

SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our ...

A recently discovered vulnerability in Microsoft Corp.s SQL Server 2000 database allows users to mask their log-in names. The vulnerability was discovered by Imperva, a researcher and vendor of ...

SQL Server has long offered a two-part toolkit for basic instrumentation of its engines, both relational and analytical: SQL Profiler and Windows Performance Monitor (PerfMon), also known as Windows ...

Here’s a bit of trivia—due to its Sybase heritage, SQL Server was the only Microsoft product to offer the CPU affinity and affinity masking configuration setting for decades. In those early days of ...

Idera, a leading provider of application and server management solutions, today announced the availability of SQL XEvent Profiler 1.0, a free tool that allows DBAs to create, run and view SQL ...

SQL Data Profiler analyzes database schema and data to illuminate if data fields accurately follow declared data types and constraints, the number and percentage of “NULL” values, data ...

SQL Server Profiler is a separate application that lets you view the queries being run on the SQL Server database engine in real time as they complete.