Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors you will check for the performane
optimization for a database query?
- 7 Answers
- 11389 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
Mention the differences between local and global temporary tables.
What are key, name and value columns of an attribute? : sql server analysis services, ssas
How do you troubleshoot errors in a SQL Server Agent Job?
What does it mean to be in union?
What are different types of collation sensitivity?
What do you mean by data integrity?
How to delete database objects with "drop" statements in ms sql server?
How do I connect to sql server database?
Explain ms sql server reporting services vs crystal reports?
what is denormalization and when would you go for it? : Sql server database administration
Which autogrowth database setting is good?
How can I create a new template for import ? : sql server management studio
Explain a differential backup?
Define union, union all, minus, intersect?
What is sqlcmd?
