what is performance tunning in sql server ? explain.



what is performance tunning in sql server ? explain...

Answer / 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

More SQL Server Interview Questions

What is difference between sql and sql server?

0 Answers  


What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,


Is the primary key column of a table an index in ms sql server?

0 Answers  


What can be used instead of trigger?

0 Answers   ADITI,


How to find the source of a table in sql server?

0 Answers  






What is a coalesce function?

0 Answers  


What is the size of transaction log file?

0 Answers  


What are the requirements for sql server 2016?

0 Answers  


How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,


What are the different SQL Server Versions you have worked on?

0 Answers  


What is normalization? Explain its different types?

0 Answers   GE, Maveric,


What does man by sql wildcard characters in sql server?

0 Answers  


Categories