Sql query run in one ssms 10 min, same query runs same ssms in other place take 1 houre , how can we slove this issues.

Question

NN 0

Viorel 102.8K Reputation points

2023-08-27T18:57:16.3433333+00:00

Which of two durations do you want to achieve?
NN 0 Reputation points

2023-08-28T08:25:41+00:00

I think i want same ssms want give me same result for 10 minuts
Craig Fick 0 Reputation points

2023-08-28T15:31:06.0866667+00:00

When you say other place would this be a different database that has more jobs running and instances open? You should run the activity monitor in both locations and see what is going on behind the scenes in terms of resource allocation and management. To access Activity Monitor (CTRL+ALT+A). Hope this helps.

Viorel 102.8K Reputation points

2023-08-27T18:57:16.3433333+00:00

Which of two durations do you want to achieve?
NN 0 Reputation points

2023-08-28T08:25:41+00:00

I think i want same ssms want give me same result for 10 minuts
Craig Fick 0 Reputation points

2023-08-28T15:31:06.0866667+00:00

When you say other place would this be a different database that has more jobs running and instances open? You should run the activity monitor in both locations and see what is going on behind the scenes in terms of resource allocation and management. To access Activity Monitor (CTRL+ALT+A). Hope this helps.

Answer 1

Erland Sommarskog 88,161

As it happens, I have an article on my web site about this specific situation entitled Slow in the Application, Fast in SSMS?

1 answer