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.

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,

---

How to create a testing table with test data in ms sql server?

0 Answers  

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

---

What is the difference between substr and charindex in the sql server?

0 Answers  

---

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

What do you mean by SQL injection attack?

0 Answers   Ittiam Systems,

---

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

---

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

---

Define ACID properties in a Database?

0 Answers   iNautix,

---

What is an indexed view?

0 Answers  

---