February 21, 2018 at 6:34 am
Hello, I am attempting to start an XE session on one of my databases and I keep getting the following error. Any ideas on how to fix this?
===================================
The specified buffer size is less than the minimum size. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.6251&EvtSrc=MSSQLServer&EvtID=25632&LinkId=20476
------------------------------
Server Name: srvngsql
Error Number: 25632
Severity: 16
State: 28
Line Number: 1
------------------------------
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.XEventUI.QuickSessionModel.CreateSession()
at Microsoft.SqlServer.Management.XEventUI.QuickSessionModel.PerformTasks(Action`3 status)
Thank you!
February 21, 2018 at 8:19 am
oradbguru - Wednesday, February 21, 2018 6:34 AMHello, I am attempting to start an XE session on one of my databases and I keep getting the following error. Any ideas on how to fix this?===================================
The specified buffer size is less than the minimum size. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.6251&EvtSrc=MSSQLServer&EvtID=25632&LinkId=20476------------------------------
Server Name: srvngsql
Error Number: 25632
Severity: 16
State: 28
Line Number: 1------------------------------
Program Location:at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.XEventUI.QuickSessionModel.CreateSession()
at Microsoft.SqlServer.Management.XEventUI.QuickSessionModel.PerformTasks(Action`3 status)Thank you!
Please post the code you are using to setup and start your XE session. At this point we really don't have anything to work with other than to tell you to check your buffer size.
February 21, 2018 at 8:28 am
I am just launching it from SSMS. See attached screenshot.
Thank you!
February 21, 2018 at 9:25 am
Okay, I try it on my local system and no problem. Guess I won't be of much help. Can't try it on any of our servers unfortunately as our network is down. Hitting the internet using my phone as a hotspot.
February 21, 2018 at 9:29 am
Okay, i tried it on another instance/server and it worked fine.
Thank you!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply