microsoft
SQL Server Profiler Extension Execution Error
Type: Feature Request
First time, I d like to try profiler on Azure but I cannot. Beacuse of this error. "An exception occurred while executing a Transact-SQL statement or batch. ---> The specified buffer size is less than the minimum size. The minimum allowed size is 10452960 bytes." Same as SSMS I filtrered text data and choose database server to start. Such errors greatly hinder the use of Azure. In terms of performance, when we follow a simple code as a select, we see that SSMS lags behind in many aspects. How can I control Azure with profiler? If you fix this error, I can ask for your help.
Extension version: 0.14.0 Azure Data Studio version: azuredatastudio 1.47.0 (c7c2b2f21505562d21972d4c135119d00806db4f, 2023-11-07T17:17:45.669Z) OS version: Windows_NT x64 10.0.22635 Restricted Mode: No Preview Features: Enabled Modes:
### Tasks
I get the same issue, attempting to connect the profiler to an Azure SQL Database of size Standard S12: 3000 DTUs
When you attempt to use the profiler you get an exception when you try to create the profiling session
An exception occurred while executing a Transact-SQL statement or batch. ---> The specified buffer size is less than the minimum size. The minimum allowed size is 15679440 bytes.
As a fix, I tried completely uninstalling SQL Server, SQL Server Management Studio, Azure Data Studio with a deep uninstaller and even deleting the directories and reinstalling with all the latest and still have the same issue. On a different brand new machine and it works fine and used the same install bits on the good machine.