SQL Trace

Question

SQL Trace

Henry_Lee

SSCrazy

Points: 2714
More actions
May 13, 2009 at 12:23 pm

#209395

Good day,
I'm trying to gauge the impact of running SQL Trace. All that I've read indicates it is less resource intensive than using Profiler. But nowhere can I find the associated process it runs under - is it just running under the sqlservr.exe process?
Thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

i have this saved, because it is a great resource for determing the minimal impact that a trace incurs:

http://sqlblog.com/blogs/linchi_shea/archive/2007/01/16/performance-impact-of-enabling-page-checksum-and-default-trace.aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

To the best of my knowledge it runs in the SQLServer.exe process. The link Lowell posted is a good resource. Here is another link[/url] about why Profiler is more resource intensive.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Henry_Lee SSCrazy Points: 2714 More actions · Answer 3

Thanks guys. Good reads.

Also, the more I pondered this it occurred to me that since SQL Trace uses stored procedures, that implies that it would run in the sqlservr.exe process.