WorkloadTools: Capture the workload Error

I am feeling like a common visitor at this point.

We have this error: Before pasting it:

1. We checked that no instance of workload is running 2. We have all permissions (tried few accounts with different permissions) 3. Directory is in exceptions 4. Both files are good, they ran before, this is the first time that we got this error

2023-05-01 01:20:06.7604 - Info - SqlWorkload.Program : Reading configuration from ‘d:\WorkloadTools\Workload-Prod.json’ 2023-05-01 01:20:06.8852 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Reading Extended Events session definition from C:\Program Files\WorkloadTools\Listener\ExtendedEvents\sqlworkload.sql 2023-05-01 01:20:06.9009 - Error - WorkloadTools.WorkloadController : Uncaught Exception 2023-05-01 01:20:06.9009 - Error - WorkloadTools.WorkloadController : The event, “sqlserver.attention”, can not be added to an event session that specifies no event loss. Cannot alter the event session ‘sqlworkload’, because it does not exist or you do not have permission. 2023-05-01 01:20:06.9477 - Error - WorkloadTools.WorkloadController :    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()    at WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener.Initialize() in C:\github\WorkloadTools\WorkloadTools\Listener\ExtendedEvents\ExtendedEventsWorkloadListener.cs:line 135    at WorkloadTools.WorkloadController.Run() in C:\github\WorkloadTools\WorkloadTools\WorkloadController.cs:line 42 2023-05-01 01:20:06.9477 - Info - SqlWorkload.Program : Controller stopped. 2023-05-01 01:20:07.0884 - Info - WorkloadTools.Consumer.WorkloadFile.WorkloadFileWriterConsumer : Closing the connection to the output file 2023-05-01 01:20:07.0884 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Disposing ExtendedEventsWorkloadListener. 2023-05-01 01:20:07.0884 - Warn - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Error disposing ExtendedEventWorkloadListener: Object reference not set to an instance of an object. 2023-05-01 01:20:07.0884 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Extended Events session [sqlworkload] stopped successfully. 2023-05-01 01:20:07.0884 - Info - SqlWorkload.Program : Controller disposed. 2023-05-01 01:21:11.6626 - Info - SqlWorkload.Program : Reading configuration from ‘d:\WorkloadTools\Workload-Prod.json’ 2023-05-01 01:21:11.7564 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Reading Extended Events session definition from C:\Program Files\WorkloadTools\Listener\ExtendedEvents\sqlworkload.sql 2023-05-01 01:21:11.7564 - Error - WorkloadTools.WorkloadController : Uncaught Exception 2023-05-01 01:21:11.7564 - Error - WorkloadTools.WorkloadController : The event, “sqlserver.attention”, can not be added to an event session that specifies no event loss. Cannot alter the event session ‘sqlworkload’, because it does not exist or you do not have permission. 2023-05-01 01:21:11.7720 - Error - WorkloadTools.WorkloadController :    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()    at WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener.Initialize() in C:\github\WorkloadTools\WorkloadTools\Listener\ExtendedEvents\ExtendedEventsWorkloadListener.cs:line 135    at WorkloadTools.WorkloadController.Run() in C:\github\WorkloadTools\WorkloadTools\WorkloadController.cs:line 42 2023-05-01 01:21:11.7720 - Info - SqlWorkload.Program : Controller stopped. 2023-05-01 01:21:11.7720 - Info - WorkloadTools.Consumer.WorkloadFile.WorkloadFileWriterConsumer : Closing the connection to the output file 2023-05-01 01:21:11.7720 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Disposing ExtendedEventsWorkloadListener. 2023-05-01 01:21:11.7720 - Warn - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Error disposing ExtendedEventWorkloadListener: Object reference not set to an instance of an object. 2023-05-01 01:21:11.7720 - Info - WorkloadTools.Listener.ExtendedEvents.ExtendedEventsWorkloadListener : Extended Events session [sqlworkload] stopped successfully. 2023-05-01 01:21:11.7720 - Info - SqlWorkload.Program : Controller disposed.

MicrosoftTeams-image (2)

Capture JSON:

{ “Controller”: {

    "Listener":
    {
        "__type": "ExtendedEventsWorkloadListener",
        "ConnectionInfo":
        {
            "ServerName": "ServerName",
            "UserName": "",
            "Password": ""

        },
        "TimeoutMinutes": 480,
        "DatabaseFilter": "DB"
    },

    "Consumers":
    [
        
        {
            "__type": "WorkloadFileWriterConsumer",
            "OutputFile": "D:\\WorkloadTools\\File_Trace1.sqlite"
        }
    ]
}

}

CMD File:

“%programfiles%\WorkloadTools\sqlworkload.exe” --File “Workload-Prod.json”

Have no idea what to do with it. Restarting server did not help, reinstall did not help, shutting down antivirus did not help. I have checked all files but i do not see any problem, as said, this is first encounter with this error. I would like to ask for some guidance. The last time we ran this was it went as expected (start of April). Now it does not work, so maybe some Microsoft patches of server could interfere with this.

About this issue

  • Original URL
  • State: open
  • Created a year ago
  • Comments: 16 (5 by maintainers)

Commits related to this issue

Most upvoted comments

Hi I want to use this tool too and I have the same problem and I can’t understand how to resolve that question. Do you have a solution for this?

Navigate to your installation folder of WorkloadTools (C:/ProgramFiles/WorkloadTools) and i think it is in one of the subfolders, there you will find .sql file and almost down there is EVENT_RETENTION_MODE, change the value to ALLOW_SINGLE_EVENT_LOSS (more on this here: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-event-session-transact-sql?view=sql-server-ver16)