I have two DBs with the same schema and tables in the same elastic pool. One is super slow and other is fast.

Question

I have two DBs with the same schema and tables in the same elastic pool. One is super slow and other is fast.

Dubravko Kišić 0

One DB from the elastic pool is slow, other is fast.

They have the same schema and structure.

If I compare same tables from these differenct DBs, a simple query like SELECT COUNT(*) on one will last 1500 ms, and 100 ms on the other (they have similar number of rows).

Thought at first it was a fragmentation issue, and I've rebuilt all the indexes but it's still the same.

Saraswathi Devadula 2,095 Reputation points Microsoft External Staff

2025-04-01T09:09:13.11+00:00

Hello Dubravko Kišić

Greetings!

Kindly request you to please share the details requested over the private message for further investigation.
Saraswathi Devadula 2,095 Reputation points Microsoft External Staff

2025-04-02T04:01:27.1166667+00:00

Hello Dubravko Kišić
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Saraswathi Devadula 2,095 Reputation points Microsoft External Staff

2025-04-03T03:16:45.2966667+00:00

Hello Dubravko Kišić
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Oury Ba-MSFT 20,716 Reputation points Microsoft Employee

2025-04-14T22:41:16.44+00:00

@Dubravko Kišić Thank you for reaching out.

Could you please follow the steps in the following doc to troubleshoot the issue https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-query-perf-between-servers#scenario-1-only-one-single-query-performs-differently-on-the-two-servers

Please let me know if more assistance is needed.

Regards,

Oury
Saraswathi Devadula 2,095 Reputation points Microsoft External Staff

2025-04-21T14:19:12.65+00:00

Hello Dubravko Kišić
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Narendra Pakkirigari 0 Reputation points Microsoft External Staff

2025-04-22T09:30:01.6566667+00:00

Hi Dubravko Kišić

Could you please follow the document to troubleshoot the issue https://learn.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver16#index-maintenance-methods-reorganize-and-rebuild

1 answer

Your answer

Saraswathi Devadula 2,095 Reputation points Microsoft External Staff

2025-04-01T09:09:13.11+00:00

Hello Dubravko Kišić

Greetings!

Kindly request you to please share the details requested over the private message for further investigation.
Saraswathi Devadula 2,095 Reputation points Microsoft External Staff

2025-04-02T04:01:27.1166667+00:00

Hello Dubravko Kišić
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Saraswathi Devadula 2,095 Reputation points Microsoft External Staff

2025-04-03T03:16:45.2966667+00:00

Hello Dubravko Kišić
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Oury Ba-MSFT 20,716 Reputation points Microsoft Employee

2025-04-14T22:41:16.44+00:00

@Dubravko Kišić Thank you for reaching out.

Could you please follow the steps in the following doc to troubleshoot the issue https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-query-perf-between-servers#scenario-1-only-one-single-query-performs-differently-on-the-two-servers

Please let me know if more assistance is needed.

Regards,

Oury
Saraswathi Devadula 2,095 Reputation points Microsoft External Staff

2025-04-21T14:19:12.65+00:00

Hello Dubravko Kišić
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Narendra Pakkirigari 0 Reputation points Microsoft External Staff

2025-04-22T09:30:01.6566667+00:00

Hi Dubravko Kišić

Could you please follow the document to troubleshoot the issue https://learn.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver16#index-maintenance-methods-reorganize-and-rebuild

Answer 1

Hi Dubravko Kišić •,

Welcome to Microsoft Q&A forum.

As I understand, you are facing slowness in two DBs with the same schema and tables in the same elastic pool.

If multiple queries run slower on one server than the other, the most probable cause is the differences in server or data environment. Go to Diagnose environment differences and see if the comparison between the two servers is valid.

Refer https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-query-perf-between-servers#diagnose-environment-differences for deeper insight.

Let us know if above helps, or if you still facing issue please share your server level details over the opened private message so that we can troubleshoot and understand the reason of slowness.

Thanks

Share via

I have two DBs with the same schema and tables in the same elastic pool. One is super slow and other is fast.

1 answer

Your answer