Interested to Buy Any Domain ? << Click Here >> for more details...
How do you fine the performance tunning?
- 2 Answers
- 8525 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 is triggers and stored procedures?
What is data mart? : sql server analysis services, ssas
How to add code to the existing article (using improve article)?
What does <> symbol mean?
Can we hide the definition of a stored procedure from a use?
What are the advantages of sql stored procedure?
What are different types of views?
Why do we use trigger?
What is the difference between lock, block and deadlock? : sql server database administration
How many ways to create table-valued functions?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is parameterized reports in ssrs ?
What command is used to create a database in the sql server and how?
How to access the deleted record of an event?
How to retrieve error messages using mssql_get_last_message()?
