query is running slow from one site

Question

I have two site Site A, Site B.

From Site A it takes 20 sec to get the SQL query result but from Site B it takes 30-40 sec for the same query.

Both of the sites are on 100MB line.

Is they any test I can run to see why its taking longer from site B

Answer 1

Maybe, but you need to explain a lot more closely what you are doing.

Are Site A and Site B accessing the same SQL Server instance and database?

How much data does the query return?

From what are you running the queries? SSMS? An application? Are you using the same login?

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 2

Both site are access same database.

The return of query is not more then 400KB

Answer 3

Both site are access same database.

The return of query is not more then 400KB

You did not say how you are running the queries. Are you running them from an application? From SSMS? Do you use the same login?

What does the query look like?

Does it only happen with this particular query or does it happen with any query that returns a result set of the same size?

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 4

Hi lalaJee,

Are both sites having the total same environment?

For example, CPU, memory,disk,OS, statistics and so on.

If not, the performance of query could be affected by them.

In addition, you could use performance counters to check whether this is a pressure with CPU, Memory or Disk on your Site B.

Please refer below as an example:

15 SQL Server Performance Counters to Monitor In 2020

Best regards,

Melissa

-------------------------------------------

MSDN Community Support

Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact [e-mail]

Answer 5

Hi lalaJee,

Could you please provide any update about this?

 

Best regards,

Melissa

-------------------------------------------

MSDN Community Support

Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact [e-mail]