Azure / Azure/azure-functions-host
Investigate why running sql queries takes a long time
- Dominant language
- C#
- Stars
- 2k
- Forks
- 482
- Avg merge
- 2d 12h
- Merged PRs (30d)
- 38
Description
Customer reported issue on SO:[azure-function-slow-executing-a-stored-procedure]( https://stackoverflow.com/questions/49356866/azure-function-slow-executing-a-stored-procedure)
Systemlogs for the invocationId =186ef503-9053-4be2-9e4c-e6b525fcfa6f
AppName: NewVIPMember
FunctionName: vipazurefunction
|FunctionInvocationId |Source |Summary|
| ------ |---- |------
|186ef503-9053-4be2-9e4c-e6b525fcfa6f |Script.Host |Function started (Id=186ef503-9053-4be2-9e4c-e6b525fcfa6f)
|186ef503-9053-4be2-9e4c-e6b525fcfa6f |WebJobs.Execution |Executing 'NewVIPMember' (Reason='Timer fired at 2018-03-20T03:45:00.0336427+00:00', Id=186ef503-9053-4be2-9e4c-e6b525fcfa6f)
|186ef503-9053-4be2-9e4c-e6b525fcfa6f |Script.Host |Function completed (Success, Id=186ef503-9053-4be2-9e4c-e6b525fcfa6f, Duration=406851ms)
|186ef503-9053-4be2-9e4c-e6b525fcfa6f |WebJobs.Execution |Executed 'NewVIPMember' (Succeeded, Id=186ef503-9053-4be2-9e4c-e6b525fcfa6f)
From the logs duration= 406851ms
Need to investigate why running simple sql stored procedure is taking long. Also, need to figure out if there are any diagnostic tools that we can point customers to.
Contributor guide
Assessment
This issue has not been assessed yet.