Skip to main content

This is a simple Deploy and its been running for almost 20 minutes.
Whats wrong here?
 

 

Hi ​@aftabp 

Did the deployment complete? Usually in these cases it helps running a SQL profiler session to see what is happening on the server


No, TX just closed. All the services were running but the window for TX shut-down.

How do i run SQL profiler session ?


If the TimeXtender application crashed, please send an email to support@timextender.com and include the steps you took before the crash, as well as any error messages from the event viewer

Regarding how to Run SQL Server Profiler:

  1. Launch SQL Server Profiler

  • From the Windows Start Menu:
    Click the Windows Start button, type "SQL Server Profiler", and select the application from the results.

  • From SQL Server Management Studio (SSMS):
    Open SSMS, go to the Tools menu, and select "SQL Server Profiler".

  • From the Query Editor or Activity Monitor:
    In the Query Editor, right-click and select "Trace Query in SQL Server Profiler". In Activity Monitor, right-click a process in the Processes pane and choose "Trace Process in SQL Server Profiler".

  1. Connect to SQL Server

  • When Profiler opens, select "File" > "New Trace".

  • Enter your SQL Server instance name and authentication details, then click "Connect".

  1. Configure the Trace

  • In the Trace Properties window, you can name your trace (optional).

  • Select a trace template (the default "Standard" is usually fine).

  • Choose whether to save the trace output to a file or table, or just view it in the Profiler window.

  • Optionally, set a stop time for the trace.

  1. Select Events and Columns (Optional)

  • Go to the "Events Selection" tab.

  • Enable or disable specific events and columns you want to monitor, such as SQL:BatchCompleted, RPC:Completed, or ErrorLog.

  • You can also enable "Show all events" and "Show all columns" for more options.

  1. Start the Trace

  • Click "Run" to begin capturing SQL Server activity.

  • The Profiler window will display real-time events as they occur.

  1. Analyze and Save Results

  • Watch events live or stop the trace at any time.

  • To save the results, go to "File" > "Save As" and choose "Trace File" or another format.

  1. Stop the Profiler

  • Stop the trace when finished to avoid using unnecessary server resources. Click the "Stop" button in the Profiler toolbar or close the application.

 


Hi ​@aftabp did you manage to resolve the issue?


@Christian Hauggaard 
Sorry for the late reply, i was not in the office for the last few days.

I am unable to run SWL Profiler
 

 


@aftabp are you running Azure SQL db or Azure synapse?


Azure SQL DB


@aftabp You should be able to use the following extension in Azure Data Studio

Did you try deploying again did it work? Can you please confirm which version of TimeXtender you are using?


Reply