Do you want to only store commands sent Sql Server Database you are profiling? - More Wally - Wallace B. McClure
in

MoreWally.com

Giving people what they want, More Wally. This is the technical and personal blog site of
Wallace B. (Wally) McClure.

This Blog

Syndication

News

Please goy buy 3-4 copies of my book on MonoTouch titled "Professional Android Programming with Mono for Android for .NET/C# Developers." They make great gifts all year round. Plus, I get about $.25 when you buy a copy.

Technical Sites

More Wally - Wallace B. McClure

This blog will have all kinds of posts about Wally McClure. In it, there will be tons of .NET and computer programming posts as well as Wally's views on life in general. As you might guess, this site and blog help you get More Wally in your life. What more could anyone want? iPhone, Android, MonoTouch, MonoDroid, Mobile, HTML5, .NET, ADO.NET, ASP.NET, AJAX, jQuery, jQuery Mobile, ASP.NET AJAX, and Windows Azure............follow me on twitter at Wally

Do you want to only store commands sent Sql Server Database you are profiling?

By default, the Sql Server 2005 profiler stores all commands sent to the database during a session.  As a result, I get a lot of gunk in the file.  It was hard to search through the gunk.  I wanted a way to only see the commands that were being sent to my database.  How the heck do you do that?  Well, I found a pretty simple way to do it.  First off, go and select all of the columns that you can choose to filter.  Then edit the columns and only select commands sent to your database.  And that solved the problem.

 

Comments

No Comments
2006 - Wallace B. McClure
Powered by Community Server (Non-Commercial Edition), by Telligent Systems