Searching Multiple Trace Files ?

Question

Searching Multiple Trace Files ?

homebrew01

SSC Guru

Points: 55548
More actions
November 30, 2010 at 8:47 am

#144173

I have a server side trace running, and have several months worth of files on the server. I got a request to try and find out when a table was last modified. Since I have no idea what time frame to look at, I'm wondering if there's a way to scan all the trace files for a character string. I'd like to avoid having to open them all and set a filter on each one in the textdata column.
Any thoughts ?

Viewing 6 posts - 1 through 5 (of 5 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

homebrew I've got an old script contribution out there that takes every trace file that happens to be in the same folder as the default trace, and imports it into a table. from there, you can query the contents of that.

you could modify it so it only gets your specific trace files, based on a naming conventions or something.months worth of data may pig up your disk space, so you might want to filter them even more.

see if this gets you close to where you want:

http://www.sqlservercentral.com/scripts/SQL+Trace/65790/

it might not be exactly what you are after, but give a bit of feedback and i'll look at tweaking it. there's some WHERE statements on it you probably want to remove, and maybe make the table have every column, but it's a framework to look at.

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!

Adiga One Orange Chip Points: 27284 More actions · Answer 2

Here is an article posted few days back. You may find this useful.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

homebrew01 SSC Guru Points: 55548 More actions · Answer 3

Lowell, I tweaked that a bit for my situation, and it worked quite nicely ... Thanks !

Lowell SSC Guru Points: 323518 More actions · Answer 4

homebrew01 (11/30/2010)
Lowell, I tweaked that a bit for my situation, and it worked quite nicely ... Thanks !

sweet ! i was hoping to fiddle with that old thing after you posted back, but you are one of the power posters who can roll with any idea. good job!

glad it greased the wheels of thought for you;

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!

homebrew01 SSC Guru Points: 55548 More actions · Answer 5

Lowell (11/30/2010)
homebrew01 (11/30/2010)
Lowell, I tweaked that a bit for my situation, and it worked quite nicely ... Thanks !
sweet ! i was hoping to fiddle with that old thing after you posted back, but you are one of the power posters who can roll with any idea. good job!
glad it greased the wheels of thought for you;

I wish ! ...... I may have quantity, but not a lot else .... always humbled by the experts here.