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
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What are different replication agents and what's their purpose? : sql server replication
What is the contrast between sql and pl/sql?
Explain sql delete command?
what stored procedure can you use to display the current processes? : Sql server administration
Do you know what is replace and stuff function in sql server?
What is the purpose of update statistics and scope_identity() function?
How to delete duplicate rows?
How to delete database objects with "drop" statements in ms sql server?
What is NOT NULL Constraint in sql server 2012?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is a scheduled job or what is a scheduled task?
Describe in brief authentication modes in sql server.
How to convert a numeric expression from one data type to another?
Is it safe to delete log files?
