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
 Other Forums
 ClearTrace Support Forum
 ClearTraceCmd.exe 2008.38 .NET issue maybe?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

TCarrier
Starting Member

1 Posts

Posted - 12/21/2012 :  18:58:20  Show Profile  Reply with Quote
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:
-------------------------------
D:
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

graz
Chief SQLTeam Crack Dealer

USA
4137 Posts

Posted - 12/26/2012 :  16:25:15  Show Profile  Visit graz's Homepage  Reply with Quote
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
  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