Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can you name some of the dml commands in sql?
What is the security principal at the server level that represents your session?
How to generate random numbers with the rand() function in ms sql server?
how you can deploy an ssrs report?
What are the main sources of data?
What is the difference between for xml raw and for xml auto?
How to use union to merge outputs from two queries together in ms sql server?
What are the ways available in sql server to execute sql statements?
Explain the different types of backups available in sql server? : sql server database administration
How to recreate an existing index in ms sql server?
explain declarative management framework (dmf) in sql server 2008?
What is a view in sql?
what is a schema in sql server 2005? : Sql server database administration
How to receive returning result from a query?
What is lock escalation and what is its purpose?
