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 download and install sql server 2005 books online?
What are commit and rollback in sql?
What is use of except clause?
What is a file group?
What is nolock?
How do you create a clustered index?
What is a performance monitor?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What are the types of joins in sql?
How to rename databases in ms sql server?
How to add code to the existing article (using improve article)?
What are the differences between substr and charindex in sql server.
What is default constraint in ms sql server?
What you can do to delete a table without the delete trigger firing?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?