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
How to skip remaining statements in a loop block using continue statements?
What is function of master database?
Explain the steps to create and execute a user-defined function in the sql server?
Describe and explain about SQL native client?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is create statement?
What are the requirements to use odbc connections in php scripts?
What is DCL?
What type of locking occurs during the snapshot generation? : sql server replication
What function does a database engine serve in the sql server?
Explain some stored procedure creating best practices or guidelines?
Why would you use sql agent?
What happens when the SQL Azure database reaches Max Size?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is data source in connection string?
