I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer.
Answers were Sorted based on User's Feedback
Answer / prasad
Im giving few suggestions known to me.
- Update table statistics regularly.
- ur log might be full. clear the log using dump tran with
no_log
- if u r connecting ur server in a network, check the
network connections.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / arun sql gamer
Might be a performance tuning problem.Previously it may
have less data ,since it wont give u that much trouble in
processing the query.Subsequently the size of the data may
get increased which leads to more processing time of query
hence forth arrive with the problem of tuning and to check
for proper indexing in table and also in query.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / jerry joseph
Number of hits might have increased..
you can try increasing the timeout
Is This Answer Correct ? | 0 Yes | 2 No |
What is Transparent Data Encryption?
Define Joins?
What are the differences between stored procedure and view in sql server?
What are information schema views?
Difference between report and query parameter. Why do we need different type of parameter?
Can we insert data into a view?
CLR Integration ? what is Notification services ?
Explain about Joins?
What is a data collection table?
How can you find out how many rows returned in a cursor?
select top 5 * from emp order by newid() my question is , how this query get executed?
Differentiate between a local and a global temporary table?