Answer Posted / arun yadav
There could be 'n' reasons for slow performance. For tuning
the performance of a SP we need to know how much resources
it is using and how much time it takes in execution. We can
check this using the performance monitor (for example, RPC
Counter) and execution plan. Check if we are using
appropriate joins, table defrag, index rebuilt can be the
solutions.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How data can be copied from one table to another table?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is the difference between lock, block and deadlock? : sql server database administration
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Can an entity have two primary keys?
Explain the xml support sql server extends?
What is the library index called?
How to transfer an existing table from one schema to another schema in ms sql server?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Explain log shipping and mention its advantages.
What is difference between table aliases and column aliases? Do they affect performance?
Can we do dml on views?
When a primary key constraint is included in a table, what other constraints does this imply?
How to create database with physical files specified in ms sql server?
What is user-defined inline table-valued function?
