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

what is performance tunning in sql server ? explain.

Answer Posted / karthikeyathirughanashamphanth

Step-1:Capturing Performance metrices.
Step-2:Find the problem Queries with Profiler.
Step-3:Define Mitigation for the Problem Queries.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create a scrollable cursor with the scroll option? : Sql server database administration

1027


What is sql server profiler?

957


Mention the different types of triggers?

1010


What is the significance of master, tempdb and model databases?

1025


What happens if null values are involved in string operations?

921


Which trace flags are enabled in sql server?

943


Which is the best place or learning center for MS SQL?????In Bangladesh?????

2018


Explain the architecture of ms sql reporting service?

873


What is surrogate key? : sql server analysis services, ssas

1056


What is a transactions?

973


What is full outer join in sql server joins?

986


What is right outer join in sql server joins?

1122


What command must you use to include the not null constraint after a table has already been created?

1053


what are constraints? Explain different types of constraints? : Sql server database administration

921


What is the difference between clustered index and primary key?

870