Author Archives: Santhosh Reddy

If we want to create a copy of the existing cluster we can use the below template to create the new citus cluster using the point time restore. Example: Parameter file: {“$schema”: “https://schema.management.azure.com/schemas/2015-01-01/deploymentParameters.json#”,“contentVersion”: “1.0.0.0”,“parameters”: {“sourceResourceId”: {“value”: “/subscriptions/xxxxxxxxxxxxxxxxxxxxx/resourceGroups/xxxxxxxxxxx/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/tes”},“location”: {“value”: “eastus2”},“sourceLocation”: {“value”: “eastus2”},“enableGeoBackup”: {“value”: false},“serverGroupName”: {“value”: “test1aug”},“pointInTimeUTC”: {“value”: “2023-08-27T02:38:30.000Z”}}}

We will receive the error message 40613 for variety of reasons caused the Azure SQL Database unavailability. Recently, we observed that customer is using the Gen_5 2 vcores database where requests reached the limit 200. https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases?view=azuresql-db We had to restart the Azure SQL Database to resolve the connectivity issue to avoid this issue we haveContinue reading “Azure SQL Database connectivity issue due to the high resource utilization”

Database restore taking long time. Customer is using their application to create the hyperscale database from the bacpac file taking long time. We can create the Azure SQL Database database using the SQLPackage to avoid these issues. https://techcommunity.microsoft.com/t5/azure-database-support-blog/using-sqlpackage-to-import-or-export-sql-server-and-azure-sql-db/ba-p/368861 https://docs.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-import?view=sql-server-ver15

Users get the following connectivity error message while connecting to the Azure SQL Database from the SSMS client. Connection to database master failed (error 10060, state 0): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name isContinue reading “Azure SQL Database connectivity issues”

How can we check if Azure SQL Database “Force_Last_Good_Plan” enabled? select * from sys.database_automatic_tuning_options where name = ‘FORCE_LAST_GOOD_PLAN’

—Step1–Create the Login and user account in the Master database as follow– CREATE LOGIN TEST01 WITH PASSWORD=’cfdfv@123_^92648451′ CREATE USER TEST01 FROM LOGIN TEST01 –step2–create user for the respective login in the user database— CREATE USER TEST01 FROM LOGIN TEST01 –Step3–add the user to required role for eg:datareader– EXEC sp_addrolemember ‘db_datareader’, ‘TEST01’; https://docs.microsoft.com/en-us/sql/t-sql/statements/create-login-transact-sql?view=sql-server-ver15 If the usersContinue reading “How to create the Login and user in the Azure SQL Database/SQL Managed instance”

How SQL MI providing the HA? => if database and SQL MI in the premium and Business Critical service tier automatically provisioned with the primary read and several secondary read only replicas. =>The read scale out feature allows you to offload read only workloads using one of the compute capacity of one of the read-onlyContinue reading “Azure SQL Database & SQL Managed instance HA and DR”

It was easy to create the logins and users in the SQL Server using the SSMS GUI. When we are working with the Azure SQL Server it is not allowed to create the logins and users using the GUI. Here, I am creating the logins and user account using the TSQL Script. —step1: Createlogin inContinue reading “How to create logins and users in the Azure SQL Database”

Common performance issues: Tools: Dataabse maintenace best practices: Often times, customer don’t know that it was a performance issue or connectivity issue. It could be performance issue/connectivity issue. It is good to understand the error message.. Even though error looks similar per eg: Connection Timeout Expired. the timeout period elapsed. Command Timeoutsqlexception: Timeout expired. theContinue reading “SQL Database Performance Troubleshooting basics”