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 lookup override?
any one can explain Self mapping Delegation Remote Credentials
why SQL server is more used to store database rather than Access
What is merge statement?
What is the difference between clustered and non-clustered indexes in ms sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is cdc in sql server?
List the various tools available for performance tuning?
Explain Capacity planning to create a database? and how to monitor it?
Write the syntax for stuff function in an sql server?
Can we drop user if user mapped to any logins
Write an sql query to find first weekday of the month?