Interested to Buy Any Domain ? << Click Here >> for more details...
How do you fine the performance tunning?
- 2 Answers
- 8541 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
How do we know if any query is retrieving a large amount of data or very little data?
What are different types of statements that are supported by sql?
Explain difference between cross join and full outer join?
What are data resources?
How is SQL Azure different than SQL server?
How can you start sql server in different modes?
What is SQL Azure?
Explain intellisense for query editing
How many replicas are maintained for each SQL Azure database?
What is dknf in normalization form?
In how many ways you can invoke ssrs reports?
What is difference statement and preparedstatement?
How to create sub reports?
How can we call UDF(User Define Function) using C# code in ASP.net ?
How to use values from other tables in update statements in ms sql server?
