Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Testing with Profiler Custom Events and Database Snapshots
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 06/22/2009 :  16:56:16  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
We've all had them. One of those stored procedures that is huge and contains complex
business logic which may or may not be executed. These procedures make it an absolute
nightmare when it comes to debugging problems because they're so complex and have
so many logic offshoots that it's very easy to get lost when you're trying to determine
the path that the procedure code took when it ran. Fortunately Profiler lets you
define custom events that you can raise in your code and capture in a trace so you
get a better window into the sub events occurring in your code. I found it very
useful to use custom events and a database snapshot to debug some code recently
and we'll explore both in this article. I find raising these events and running
Profiler to be very useful for testing my stored procedures on my own as well as
when my code is going through official testing and user acceptance. It's a simple
approach and a great way to catch any performance problems or logic errors.

Read Testing with Profiler Custom Events and Database Snapshots

Patron Saint of Lost Yaks

30421 Posts

Posted - 06/22/2009 :  17:50:01  Show Profile  Visit SwePeso's Homepage  Reply with Quote
For User Configurable events, also see

E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000