Post reply

SQL Server Profiler Issue (Save to file not working)

  • September 7, 2011 at 2:49 am

    #247426

    Hi everyone.

    I installed SQL Server 2008 R2 SP1 instance on my PC and I was trying to run a trace using SQL Profiler(10.50.1600.1), and then save this trace to a file, but ran into a problem.

    On the Trace Properties dialog, there is a "Save to file" checkbox. For some reason, I am unable to check this box. It shows up as enabled, but as soon as I click on it, the "check" goes away. Even if I "tab" over to this field so the focus is on this checkbox, and press the spacebar, it does the same thing (the "check" flashes real quick, but then goes away). The "Save to table" checkbox works just fine (I even tested this out, and I am able to save a trace to a table in the database).

    If I log on to the SQL Server where I work and open the profiler, the "Save to file" works just fine.

    Any ideas what might be going on?

    Thanks.

  • September 7, 2011 at 10:21 am

    #1378111

    You should be getting a "Save As" file dialog box that pops up. My guess is that this is coming up in the background. Try minimizing and then returning to Profiler.

    As a side note, I don't recommend using the Save to a file while a trace is running as Profiler can cause performance problems and adding the file writing to it adds an even bigger performance hit. I recommend running profiler and then saving the results to a file when you are done or running a server-side trace.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • September 8, 2011 at 12:16 am

    #1378369

    Thank you Jack for your reply.

    I Minimize the profiler window and attempt to check the save as option but no save dialog box appears.

    It seems that the checkbox is disabled as soon as I want to enabled it.

    You are right , I can run the trace and save it when the job is done.

    Nevertheless , this issue is very strange .

Viewing 3 posts - 1 through 2 (of 2 total)

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