A Sharper Profile An old SQL tool you probably won't recognize in its SQL 2005 incarnation is the SQL Server Profiler, shown in Figure 1 below.

How can understanding wait statistics improve query performance in SQL Server? Understanding wait statistics allows the data professional to tune individual queries or, if necessary, to tune ...

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 ...

SQL Server also has separate logs for the SQL Server Agent, as well as other components of the data platform, such as SQL Server Analysis Services. In each case, SQL Server keeps seven rolling log ...

Database professionals agree - SQL Server performance tuning is hard. And on top of that, it never stops because complex database environments are always changing with upgrades, application updates ...

You can track this through a Counter Log, import the performance data to the SQL Profiler and view a synchronized graph with your trace. In this way it is easy to spot the deadlocks.

We run JD Edwards' One World here on an NT 4 sql server. It's a pretty decent server but lately it's been running like a dog.It's a 4-way 450mhz Xeon(2mb cache) machine with 4gigs of ram. All ...

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 ...

IDERA today announced the availability of SQL Data Profiler, a free tool with a focus on the needs of data architects.