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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How do you fine the performance tunning?

Question Posted / prasadhari_m@yahoo.com

Answers were Sorted based on User's Feedback



How do you fine the performance tunning?..

Answer / visala

first we have to check indexes are there or not,
check whether the statistics are updated or not,
check fragmentation is there or not,
check availability of joins,
check availability of aggregatefnctions,
may be networking problem,
may be hardware problem

then we tunne according to these problems

Is This Answer Correct ?    5 Yes 0 No

How do you fine the performance tunning?..

Answer / shivaraj

it is depends on
Data base design.
Hardware Sizing,
Application T- SQL codes- Indexes,Stored
Procedues,constraints
no of clients
no users
Type of data and Quantity base storage capacity on daily
basis

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

Why is the need for data conversion transformations?

0 Answers  

Explain some stored procedure creating best practices or guidelines?

0 Answers  

What are different types of schemas?

0 Answers  

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

Do you know what is fill factor and pad index?

0 Answers  

how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

What are the advantages of user defined function?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories