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

How to loop through the result set with @@fetch_status?

0 Answers  

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

How do I find the query plan in sql server?

0 Answers  

What is the difference between substr and charindex in the sql server?

0 Answers  

What is 2nf normalization form?

0 Answers  

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

What are partitioned views and distributed partitioned views?

0 Answers  

How dts is used to extract, transform and consolidate data?

0 Answers  

What is BCP? When do we use it?

2 Answers  

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

For more SQL Server Interview Questions Click Here
Categories