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
What do mean by xml datatype?
Why is replication required on the sql server?
What is a natural primary key?
What are number line correlation administrators will use while working with a subquery?
Can we perform backup restore operation on tempdb?
Explain system rowset functions?
How can you insert values in multiple rows using one Insert statement?
What is the exact numeric data type in sql?
How to define and use table alias names in ms sql server?
Working with TLogs
What is an index in a database?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Explain about Views?
How you can get a list of all the table constraints in a database? : Sql server administration
How to throw custom exception in Stored Procedure?