Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL server profiler 2012 - failed to start a new trace Expand / Collapse
Author
Message
Posted Sunday, August 3, 2014 3:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 4, 2014 2:20 AM
Points: 9, Visits: 64
Hi folks

I am attempting to create a new trace but I get the following error message: "failed to start a new trace".

I have been doing some digging and as I understand it, I had to find the directory Profiler uses for temporary files. So, I typed the following in the command window "SET TMP" and I received the following reply:

C:\Users\Ross\AppData\Local\Temp

Now, according to the forum:
[url=http://social.msdn.microsoft.com/Forums/en-US/93022060-ee6f-4c1b-a37a-e78dfbb2badb/failed-to-start-a-new-trace?forum=sqldatabaseengine][/url]

I am supposed to check that the system folder pointed to by the TMP environment variable exists and is not crammed with files.

Well, when I went to the directory C:\Users\Ross\AppData\Local\Temp, it is indeed full of both files and directories. The size is 16.3 MB and has 133 files and 63 folders.

When I had a look at the Environment Variables window and chose TMP the value is "%USERPROFILE%\AppData\Local\Temp" which according to my limited understanding is the equivalent to C:\Users\Ross\AppData\Local\Temp.

So, what I am wondering is am I supposed to totally clear out this directory? I am not too keen on doing this because I don't want to stuff my PC up.

If somebody could help me out I would really appreciate it.

Kind regards

Ross




Post #1599007
Posted Sunday, August 3, 2014 3:15 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:06 AM
Points: 895, Visits: 2,523
Through profiler GUI if you are trying to save a trace to file or configure a trace to write to a file, you can save it anywhere you want. I generally save these to C:\Temp if I am using Trace.


Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #1599008
Posted Monday, August 4, 2014 1:27 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 1:21 AM
Points: 210, Visits: 644
Alternatively you can try to create trace using TSQL, which provides you more flexibility...

http://msdn.microsoft.com/en-us/library/ms188662.aspx


Cheers
Post #1599137
Posted Monday, August 4, 2014 4:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:27 PM
Points: 13,776, Visits: 28,178
Better still, don't use trace and start using extended events. You're running 2012, so the excuse of not having a GUI has been eliminated.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1599193
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse