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 cte (common table expression)?

0 Answers  

Can we check locks in database? If so, how can we do this lock check?

0 Answers  

What does nvl stand for?

0 Answers  

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

0 Answers  

What is the use of =,==,=== operators?

0 Answers  

How do you troubleshoot SQL Server if its running very slow?

2 Answers   HP,

What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

How are the exceptions handled in sql server programming?

0 Answers  

Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,

How to move database physical files in ms sql server?

0 Answers  

Can you explain what are commit and rollback in sql?

0 Answers  

What is cursor in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories