search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 906 forks source link

SQL Server Profiler Extension Execution Error #24972

Open BahadirSoybakis opened 1 year ago

BahadirSoybakis commented 1 year ago

error-azure 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
GeneWebbProfisee commented 1 year ago

I have the same issue and never get any profile vevents

ChrisMyrick commented 9 months ago

I have the same issue. Unable to use profiler extension.

davedraffin commented 8 months ago

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.

GeneWebbProfisee commented 8 months ago

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.