Interested to Buy Any Domain ? << Click Here >> for more details...
How do you fine the performance tunning?
- 2 Answers
- 8392 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
What are Row versions of DataRow?
Why do we use stored procedures in sql server?
what data regions are and what are the different data regions?
What happens if you add a new index to large table?
What is it’s similarity with sql server?
What is the sql case statement used for? Explain with an example?
How do I create an extended event in sql server?
Do you know what are acid properties?
What is openrowset sql server?
What happens if null values are involved in datetime operations?
How to execute multiple stored procedures at one time in sql server?
After removing a table from database, what other related objects have to be dropped explicitly?
Explain indexed views?
How to create a stored procedure with a statement block in ms sql server?
Explain how would you store your query in an SSRS report or a Database server?
