Hi people,
I have a big problem with MICROSOFT SQL FROM KUBERNETES
I have setup my entire cluster.
I thought everything is working fine, then observed that all the api calls are very slow..
SETUP:
My cluster with services is running in my office server room, and i have microsoft sql server running on windows machine just beside it.
Now my requests to that sql server are 5-6x slower than my earlier setup where, requests used to go from services running on IIS on windows machine to MS sql server running on windows.
i ran profiler and saw that
pyodbc.connect is taking 90% of the time
The query which is taking 500ms to be executed on windows machine is taking 5.2seconds out of which 4.46 is consumed by pyodbc.connect
PLEASE HELP
