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.

How to see existing views in ms sql server?

0 Answers  

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

What is sql server used for?

0 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

---

What are different types of raid levels?

0 Answers  

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  

---

What are logical database components? : SQL Server Architecture

0 Answers  

---

How to create view in stored procedure sql server?

0 Answers  

---

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

---

What are the elements of dbms?

0 Answers  

---