Sql Server Profiler How To Use It

Is there a more widely used database server profiler that I could use in order to better pinpoint issues like this.

If the server is normally very heavily loaded then keep the duration of runs short.

If the server usually has spare capacity then there will probably not be any issue.

Its likely youll have to do some tweaking of your trace config and rerun a few times in order to see the information you need.

IdealSqlProfiler can be used to quickly grab all of the sql that is generated behind a particular individual web page or desktop application.

Sql Server Profiler How To Use It

You can find an 11-minute video tutorial on how to use it at IdealSqlTracer Overview.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged sql-server-2005 or ask your own question.

This data is stored in a trace file and can be used to troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive tableindex scanning, and a lot more.

This must be due, at least in part, to the fact that it is occasionally a frustrating tool.

The user interface is poor, it lacks many important features, it is poorly documented and, unless you have a lot of experience as a DBA, it is often hard to analyze the data you capture.

As such, many DBAs tend to ignore it and this is distressing, because Profiler has so much potential to make a DBAs life more productive.

Brad is a frequent speaker at SQL PASS, SQL Connections, SQL Server user groups, and other industry seminars, and he is the author or co-author of more than 12 technical books and over 100 published articles.

Sql Server Profiler Download