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
Does sql server use t sql?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
How can you find out how many rows returned in a cursor?
Tell me extended events in sql server 2008?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How is sql used in sql server?
Name the different type of indexes in sql?
Which are the important points to note when multilanguage data is stored in a table?
Explain cdc and sql injection?
What is the difference between grant and with grant while giving permissions to the user?
How to encrypt Strored Procedure in SQL SERVER?
What are the operating modes in which database mirroring runs?
Where are sql server usernames and passwords stored in the sql server?
How to create a dynamic cursor with the dynamic option?
What is the xml datatype?