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
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is sql server profiler?
Mention the different types of triggers?
What is the significance of master, tempdb and model databases?
What happens if null values are involved in string operations?
Which trace flags are enabled in sql server?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
Explain the architecture of ms sql reporting service?
What is surrogate key? : sql server analysis services, ssas
What is a transactions?
What is full outer join in sql server joins?
What is right outer join in sql server joins?
What command must you use to include the not null constraint after a table has already been created?
what are constraints? Explain different types of constraints? : Sql server database administration
What is the difference between clustered index and primary key?