Answer / guest

First check the processor and memory usage to see that
processor is not above 80% utilization and memory not above
40-45% utilization then check the disk utilization using
Performance Monitor, Secondly, use SQL Profiler to check for
the users and current SQL activities and jobs running which
might be a problem. Third would be to run UPDATE_STATISTICS
command to update the indexes

Answer / abc

we can check for the cpu utilization from the task manager
and if it above 80% then we have to check the status of
indexes or we can say we have to recreate the statics as
well as indexes.
there are many other factors but in production servers
indexing causes a great performance enhancement.Also we
have to check whether large I/o operations are not
hindering the performance.

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

---

What are trace flags and mention a few common trace flags used with sql server?

0 Answers  

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

0 Answers  

---

What are scheduled tasks in sql server?

0 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

---

What does the on update no action do?

0 Answers  

---

Explain the phases a transaction has to undergo?

0 Answers  

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

What is the difference between stored procedure and functions?

0 Answers   MCN Solutions,

---

Explain the cursor lock types?

0 Answers  

---

Is mysql better than sql server?

0 Answers  

---