Santhosh Reddy

Error message 512

Customer getting the error message (Error Message 512)when tried to open the SQL Managed instance database properties from SSMS client? This error message due to multiple database_guid for the same database_name in themsdb_backupset you can avoid this error message by deleting the database backuphistory as follow. msdb.sp_delete_database_backuphistory @database_name=database_name msdb.sp_delete_database_backuphistory @database_name=db physical id

Azure SQL Database connection timeout

https://azure.microsoft.com/en-us/blog/connections-and-sql-azure/ If we dont perform any action (idle session without any active request)on the Azure SQL DB session it will throw the time out error message after 30 minutes.

Locks

Locking is the essential because to manage the transaction concurrency in multi-user environment. Locks are in-memory structure of 96 bytes in size which has its owner, resource type, lock modes. SELECT * FROM SYS.DM_TRAN_LOCKS Shared locks(S) SELECT Exclusive Locks(X) During the data modification operators such as insert, update or Delete. This prevent one object toContinue reading “Locks”

Azure SQL Database and Managed instance Scale up operation impact

I have received a case where customer wants to know the database scale up operation time. what will happen in the backend when database scale up operation begin in the Azure SQL DB and Azure SQL Managed instance? https://docs.microsoft.com/en-us/azure/sql-database/sql-database-single-database-scale As mentioned in the link, Impact Changing the service tier or compute size of mainly involvesContinue reading “Azure SQL Database and Managed instance Scale up operation impact”

Azure SQL Database Read Only Replica

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-read-scale-out As part of the High Availability architecture, each database in the Premium and Business Critical service tier is automatically provisioned with a primary replica and several secondary replicas. The secondary replicas are provisioned with the same compute size as the primary replica. The Read Scale-Out feature allows you to load-balance SQL Database read-only workloads using the capacityContinue reading “Azure SQL Database Read Only Replica”

How to Restore the Azure SQL Managed instance DB using Azure CLI/Poratl

https://docs.microsoft.com/en-us/azure/sql-database/scripts/sql-database-restore-database-cli Limitations Point in time restore to a managed instance has the following limitations: When you’re restoring from one managed instance to another, both instances must be in the same subscription and region. Cross-region and cross-subscription restore aren’t currently supported. Point-in-time restore of a whole managed instance is not possible. This article explains only what’sContinue reading “How to Restore the Azure SQL Managed instance DB using Azure CLI/Poratl”

semaphore timeout error message

Customer is able to connect the Azure SQL Database any other machine successfully.Here, the client request is not reaching to the Gateway if it is failing at Gateway level we can say that there is issues with the SQL DB gateway.https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture This is not because DB memory resource pressure. At pre-login handshake stage, the requestContinue reading “semaphore timeout error message”

Azure Vnet 101

VPN Gateway: A VPN gateway is Azure virtual network gateway used to send the encrypted traffic to on premises from Azure Vnet over the public internet. You can also use VPN Gateways to sen the encrypted traffic between Azure Vnets over the Microsoft networks. Each Vnet can have only one VPN Gateway but you canContinue reading “Azure Vnet 101”

Introduce Yourself (Example Post)

This is an example post, originally published as part of Blogging University. Enroll in one of our ten programs, and start your blog right. You’re going to publish a post today. Don’t worry about how your blog looks. Don’t worry if you haven’t given it a name yet, or you’re feeling overwhelmed. Just click theContinue reading “Introduce Yourself (Example Post)”