Interested to Buy Any Domain ? << Click Here >> for more details...
How do you fine the performance tunning?
- 2 Answers
- 8623 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 the parts of a function?
how many bits ip address consist of? : Sql server database administration
What is ddl command?
What is normalization? Describe its different types.
If a table does not have a unique index, can a cursor be opened on it?
How to delete duplicate rows from table except one?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
How do I find the size of a sql server database?
What is sub-query in sql server?
What are clustered and non-clustered index?
What methods do you follow to protect from sql injection attack?
What is a result set object returned by mssql_query()?
How do you migrate data from mssql server to azure?
Define Wed Edition in SQL Azure?
How to write character string constants or literals in ms sql server?
