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
Explain what is the difference between a local and a global temporary table?
How to modify existing triggers using "alter trigger"?
What are the advantages of the mirroring?
How to delete duplicate rows from table except one?
What is the difference between executequery () and executeupdate ()?
Working with TLogs
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is a result set object returned by mssql_query()?
what is bit datatype? : Sql server database administration
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is cursor in ms sql server?
Is ssrs support other database except ms sql server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What are the different types of normalization?
How to use subqueries with the in operators in ms sql server?