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.

 All Forums
 Other Forums
 ClearTrace Support Forum
 ClearTraceCmd.exe 2008.38 .NET issue maybe?

Author  Topic 

Starting Member

1 Post

Posted - 2012-12-21 : 18:58:20
Hiya all,

I have a sql agent job that scoops up a 3 minute duration trace file and populates the CTTables.

One step calls a Operating System(CmdExec) command as such D:\BaselineTrace\DIR\ClearTrace.bat

ClearTrace.bat looks like this:
CD D:\BaselineTrace\DIR
ClearTraceCmd.exe /s SERVERNAME\INSTANCENAME /d DATABASENAME /f D:\BaselineTrace\DIR\*.trc /group [DIR]

All has been running well, but recently ran into some troubles where the ClearTrace.exe process periodically hangs. I've checked the trace files that it's hanging on, and they are valid. As a matter of testing, I can manually execute the CMD and it loads just fine. Some servers work fine, others hang (but not every time)

Sometimes works, sometimes not. Trace files are not particuarily large and load in a couple of seconds.

A big clue came when we added a new node to our cluster and moved the SQL Service. All of the sudden, it began happening on a server that I hadn't experienced the issue on. I did notice that the servers it hangs on have .NET 4.0. The servers with .NET 3.5 have never had a problem. Indeed, the old node had 3.5... new node 4.0

Have any of you experienced issues with .NET version? Seems like I'm on the right track. Everything is super great with ClearTrace... just this one issue is a dealbreaker.

Now that I'm thinking about it... I might ship off my trace files to another server for processing. I can pick a server with .NET 3.5

Happy Holidays, and thanks again for a great tool.

~Todd Carrier

Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2012-12-26 : 16:25:15
Hmmm. I haven't experienced anything like that. I'm not sure why a later version would cause it to break. You didn't change SMO versons or install a service pack? Can you run it interactively on that same box? Meaning is it really related to .NET version and not some peculiarity of your service account?

Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

- Advertisement -