SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

AskSQLTeam
Ask SQLTeam Question

USA
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

SwePeso
Patron Saint of Lost Yaks

Sweden
30241 Posts

Posted - 06/22/2009 :  17:50:01  Show Profile  Visit SwePeso's Homepage  Reply with Quote
For User Configurable events, also see
http://weblogs.sqlteam.com/mladenp/archive/2008/10/16/Custom-user-configurable-SQL-Server-Profiler-events.aspx



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.03 seconds. Powered By: Snitz Forums 2000