What are the factors you will check for the performane
optimization for a database query?
Answer Posted / ponguru
It is very big thing...Let me explain in short..Run the
profiler and catch the Logical reads/Physical reads/CUP
values.
find out where values are more(huge) and take Excution plan
and study it ...here you can find out where the problem.
In general scenarios Data also matters that means If your
Dev/Test enviroment not having that much Data which has
Prod.
Get the large Data and do above scenarios and you came know
what is cause.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
You want to implement the one-to-many relationship while designing tables. How would you do it?
How to provide values to stored procedure parameters in ms sql server?
Describe the left outer join & right outer join. : sql server database administration
List the various tools available for performance tuning?
What are the system database in sql server 2005?
Does partitioning ssd reduce performance?
Explain how does the report manager work in ssrs?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is sub-query in sql server? Explain its properties.
How to find the second highest salary of an employee?
What is difference between global temporary tables and local temporary tables?
how would you troubleshoot blocking? : Sql server database administration
Explain about nested stored procedure?