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.
Answer Posted / 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 |
Post New Answer View All Answers
Explain syntax for viewing, dropping and disabling triggers?
What is difference between rollback immediate and with no_wait during alter database?
What are different types of raid levels?
Difference between aggregate functions of sql?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
List out what other servers you can use with ssrs?
What are various aggregate functions that are available?
How you provide security to cube? : sql server analysis services, ssas
How do you use a subquery to find records that exist in one table and do not exist in another?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is format parameter in ssrs?
What is repeatable read?
List some case manipulation functions in sql?
Explain the use of containers in ssis?
How to update a field in SQL after ALTERING a row?