How do you fine the performance tunning?
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
List few advantages of stored procedure.
What happens when converting big values to numeric data types?
How do you create type- insensitive operator?
how to overcome kernel isssues
How do I create a partition table in sql server?
what is the difference between Delete and Truncate command in SQL
How to test subquery results with the exists operator?
What is the security principal at the database level that represents your session?
Explain timestamp datatype?
Do you think BCNF is better than 2NF & 3NF? Why?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
what is isolation level at dead lock?
Tell me about joins in database system and explain each in detail.
What is the correct order of the logical query processing phases?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration