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
how can u get last observation in an unknown dataset ?
What is surrogate key? : sql server analysis services, ssas
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
Explain datetimeoffset data type in sal server 2008?
How many types of triggers in sql server?
How to insert data into an existing table?
How to define and use table alias names in ms sql server?
What happens if ntwdblib.dll is missing on your machine?
How to use transact-sql statements to access the database engine?
How to provide default values to stored procedure parameters?
What is always encrypted?
What are the main sources of data?
Tell me the difference between clustered and non-clustered index?
what is spatial nonclustered index
How can delete duplicate records in cte in sql server?