February 16, 2011 at 7:41 am
I have been developing a measuring system by starting a small and constant running trace file per database. With setfilter and setevent I collect a few figures from my running queries. Every trace file refreshes on the hour so they are handsomely small. Big question: how many of those traces can be run at the same time? Is there a limit?
February 16, 2011 at 7:51 am
You'll run into performance issues because of I/O way before you run into hard limits on the number of traces.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 16, 2011 at 8:15 am
I ran a series of tests, years ago, where I opened multiple default traces on SQL Server. I had 20 running at the same time and i didn't change performance on the server. The way it works, if you're looking at the same event from any given trace, it reuses that event from the other trace instead of instatiating a new event.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply