February 13, 2014 at 7:12 am
I have been getting complains about the application we have. When users click to open up an existing ticket, it's taking them 30 sec for a window to pop up. Any help or advise will be appreciated. Thanks!
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 13, 2014 at 7:21 am
What exactly are you asking for help with?
Does the page contain a call to a database? If so, what is it calling? A procedure, a SELECT statement, etc? What do you see running on your SQL server? Anything taking 30 seconds (if it's even DB-related) will be easily picked up by running a trace or by checking your existing sessions.
Check for blocking, PAGEIOLATCH, CXPACKET, etc wait types - could be something as simple as a few new columns added to a SELECT statement or a WHERE clause that a simple index tweak may correct.
Hard to really offer many suggestions with such little information...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply