Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 7318 Views
- Satyam, I also Faced
- E-Mail Answers
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
Tell about MOM Tool(Microsoft Operator Manager)?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What is change data capture (cdc) feature?
List out the differences between the clustered index and non-clustered index in sql server?
What are types of scd? : sql server analysis services, ssas
What is database architecture? : SQL Server Architecture
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What is indexing in sql server with example?
What is the order by used for?
What is ms sql server reporting services?
What happens if you insert a duplicate key for the primary key column in ms sql server?
How to get the definition of a user defined function back?
What is difference between inner join and join?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What do you understand by replication in sql server? Mention the different types of replication in sql server.
