user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?
Answer Posted / basanti
1. Check the volume of data.
2. check whether index need to be rebuild or not.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
describe middleware applications that ease the connection of databases to web?
Mention the differences between trigger and stored procedures
What is the e-r model?
In which phase of mload can I use .filler?
How do you performance tune a database?
Explain the architecture of reporting services?
What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?
Where is data stored in database?
How do you create a database for an organization?
What are its two major subsystems of r?
What is the function of DML Compiler?
What is database partition key?
Define atomicity and aggregation.
What is artificial key?
How to connect Silverlight application to database?