What are the factors you will check for the performane
optimization for a database query?
- 7 Answers
- 10530 Views
- CarrizalSoft Technologies, DELL, SoftSol, I also Faced
- E-Mail Answers
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 we can compare two database data?
What is #table in sql server?
‘Order by’ is not allowed in a view how can you sort information from a view?
How do you delete a data source?
What is the purpose of the tempdb database?
What is the chart in report?
How to encrypt data between dialogs?
What is role playing dimension with two examples? : sql server analysis services, ssas
How to get the definition of a trigger back?
How to optimize stored procedures in sql server?
What is filestream?
How to delete duplicate rows?
What is replication with database mirroring? : sql server database administration
What is spid in sql server profiler?
What is the difference between createstatement and preparedstatement?
