June 3, 2016 at 6:59 am
I have a replicated database in one server, the stored procedures I am running does cross join between this database n database residing in the same server, the query runs for more than 10 minutes.
We have another database being replicated in another server as well, so what we did was restored the other database which has the stored proc, in this server , it gives output in 5 secs.
What do we need to check for this performance isuue ?
Thanks
June 3, 2016 at 7:12 am
I'd start by looking at the execution plan, and by checking for blocking issues.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 7, 2016 at 7:54 am
Same data, same hardware?
June 7, 2016 at 10:22 pm
you are saying that it is on the same server, well it is been replicated from the other server. check the execution plan how the query is being executed and see the statistic information are up to date and no blocking when your run the query on these tables.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply