Huh? What does an indexed view have to do with anything?
I'm not sure I understood your question totally. You have an application that's exhibiting poor performance. Using profiler, you've identified some big queries that are running?
Best thing, if you know what queries are hogging your system is to take those queries and see if you can improve their performance. That may be by createing or modifying indexes, or it may require modification of the query itself. If you're runing into hardware bottlenecks, it may require a hardware upgrade. I don't have enough information on your problem to be more specific.
If you're not sure how to improve the speed of a query, start a thread here and post the query and the schema of the tables involved. There are a few of us around here who love tuning queries (myself included)
If this problem is widespread, you don't know how to improve it and its a serious problem, you may want to consider hiring a SQL consultant for a few days to look specifically at performance and to show you some tricks. I don't know where you're situated, so I can't make any suggestions.
What is the maximum response duration for TSQL Query?
Are you asking what's the maximum amount of time a SQL query can run? There's no limit. Timouts are a client-side restriction, not server side.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass