How do you fine the performance tunning?
- 2 Answers
- 7821 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / visala
first we have to check indexes are there or not,
check whether the statistics are updated or not,
check fragmentation is there or not,
check availability of joins,
check availability of aggregatefnctions,
may be networking problem,
may be hardware problem
then we tunne according to these problems
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can we call future method from queueable?
Do I need a report server to run reports in my application?
What is temporal table?
How does the report manager work in SSRS?
What are the advantages of using a stored procedure?
What is reference section?
Explain candidate key, alternate key, and composite key?
What are three major types of constraints?
What is the boxing and unboxing concept in .net?
How to use user defined functions in expressions?
What is the New in SQL server 2008?
Can you explain what is sql server english query?
What is apply operator in sql?
What are the differences between stored procedure and the dynamic sql?
Describe in brief authentication modes in sql server.
