User Profile

Tancy

Microsoft

Joined 4 years ago

15 Posts12 Likes

View All Badges

User Widgets

Recent Discussions

No content to show

Recent Blog Articles

Persistent Version Store (PVS) can cause fluctuations in size of an Azure SQL DB
Issue We recently received an end user case where the customer complained of fluctuations in size of an Azure SQL DB. Error The cx noticed this on their Azure Portal Monitoring screen, the ...
Oct 27, 2025 Place Azure Database Support Blog
108Views
0likes
0Comments
How to skip external data source references while doing export/Restore of an Azure SQL DB
Issue We recently encountered a support case where a customer was getting an error message while trying to restore a bacpac to an Azure SQL DB as the bacpac file was pointing to Prod external data...
Feb 13, 2025 Place Azure Database Support Blog
442Views
0likes
0Comments
How to query .xel log files in Azure SQL DB using T-sql
Issue A recent issue was brought to our attention that customers could not query .xel log files in an Azure SQL DB using t-sql command. The customers complained that when they ran the command, they...
Oct 11, 2024 Place Azure Database Support Blog
1.5KViews
0likes
2Comments
TempDB space in Azure SQL DB appears much less than the published values
Issue An issue was brought to our attention recently where an azure SQL DB was throwing TempDB related errors although the customer felt that the TempDB usage never came close to the value publishe...
Jun 07, 2024 Place Azure Database Support Blog
2.8KViews
1like
1Comment
RestorableDroppedDatabases in Azure SQL DB & their naming convention
Issue An issue was reported recently where the customer complained that in their cost analysis report of their Azure SQL DBs, the db name appears appended with a comma(,) and a number. While they a...
Mar 18, 2024 Place Azure Database Support Blog
2.1KViews
0likes
0Comments
Migrating an Azure SQL DB to a SQL MI by utilizing SqlPackage/ADF
Scenario: We have an Azure SQL DB that needs to be migrated to a SQL MI. Problem: At the time of writing the article, the Azure portal doesn`t provide a graphical interface to perform such ...
Feb 20, 2024 Place Azure Database Support Blog
4KViews
1like
2Comments
In-memory table in Azure SQL DB doesn’t release memory- Msg 41823, Level 16, State 109, Line 1
Issue We recently encountered a support case where a customer using In-memory tables in an Azure SQL DB, receives an error message while trying to insert data into the table that also has a cluster...
Oct 07, 2023 Place Azure Database Support Blog
2.8KViews
0likes
0Comments
Query performance impact due to a poorly managed mapping Index on an Azure SQL DB
Issue We recently received customer complaints on an Azure SQL DB (Hyperscale) where a Large table (in TBs) having a clustered columnstore Index (& a non-clustered Index as well) was not performing...
Jul 09, 2023 Place Azure Database Support Blog
3.2KViews
0likes
0Comments
Impact of Memory Grant Feedback on Azure SQL Managed Instance
Issue Incorrect memory grants on certain queries can lead to extremely high CPU spikes in an Azure SQL MI. This is usually expected in high workload production Azure SQL MI systems that have high r...
Jun 12, 2023 Place Azure Database Support Blog
2.4KViews
0likes
0Comments
How to prevent Page corruption scenarios while restoring SQL DB backup from On-prem to Azure SQL MI
Issue While trying to restore the backup of an On-prem DB (That was moved from 1 server to another & Contained memory optimized table) on a managed instance, there could be a possibility of DB corr...
Feb 28, 2023 Place Azure Database Support Blog
3.3KViews
3likes
0Comments