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 oltp (online transaction processing)?
How to search for a string in all stored procedure in sql server?
Explain the truncate command? : SQL Server Architecture
can you any body tell me the how to decrease the logfile
Explain the disadvantages/limitation of the cursor?
What are different types of statements that are supported by sql?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What are a database and a data warehouse?
Differences between functions and stored procedures?
8 Answers 247Customer, Accenture,
what is the main difference between constraints(like primary key etc..)& joins?
What are the disadvantages of primary key and foreign key in SQL?
sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters