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

How do you fine the performance tunning?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a function and a stored procedure?

1050


What are the requirements on sql server network connections?

948


What are the hotfixes and patches in sql server?

1003


Explain what are the basic functions for master, msdb, model, tempdb databases?

951


What is difference between commit and rollback when used in transactions?

946


What is a not null constraint?

1007


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1238


Can you please explain the difference between primary keys and foreign keys?

1092


How to disable triggers using "disable trigger"?

1033


Can we hide the definition of a stored procedure from a use?

1200


Explain nested join?

959


What are unicode character string data types in ms sql server?

1219


What is an execution plan? When would you use it?

957


How many non clustered indexes there can be on table ?

895


How you would rewrite the sql query to return the customerid sorted numerically?

972