Sample Azure Function application to test SQL Connectivity
Azure function expect parameter
- "ConnectionString" that you can copy directly from Azure Portal. But should looks like sample below
Server=tcp:XXXXXXX.database.windows.net,1433;Initial Catalog=sandbox;Persist Security Info=False;User ID=XXXXXXXX;Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;
Azure function expect parameters:
- "ServerName"
- "DatabaseName"
Azure function expect parameters:
- "HighCPU" (1 or 0) When set to 1 Azure Function will do some math to increase CPU usage
- "LoopLimit" that should int (Sample: 5000)
- "ConnectionString" like sample below, and you can change parameter Max Pool Size=10
Server=tcp:SERVERNAME.database.windows.net,1433;Initial Catalog=sandbox;Persist Security Info=False;User ID=User;Password=XXXXXXXXX;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Max Pool Size=10;