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

​Hi people,I have a big problem with MICROSOFT SQL FROM KUBERNETESI 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 thatpyodbc.connect is taking 90% of the timeThe query which is taking 500ms to be executed on windows machine is taking 5.2seconds out of which 4.46 is consumed by pyodbc.connectPLEASE HELP   Read More

​