Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

describe middleware applications that ease the connection of databases to web?

924


Mention the differences between trigger and stored procedures

1125


What is the e-r model?

868


In which phase of mload can I use .filler?

916


How do you performance tune a database?

931


Explain the architecture of reporting services?

969


What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?

818


Where is data stored in database?

859


How do you create a database for an organization?

841


What are its two major subsystems of r?

1124


What is the function of DML Compiler?

1179


What is database partition key?

911


Define atomicity and aggregation.

1016


What is artificial key?

868


How to connect Silverlight application to database?

1046