Answer / neeraj malik

Dynamic management views and functions return server state
information that can be used to monitor the health of a
server instance, diagnose problems, and tune performance.

Example:
sys.dm_db_index_physical_stat gives u stats and
fragmentatin information for the specified index.
sys.dm_db_operational_stat gives information abt latches,
and locks on given index.

Best
Neeraj Malik

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

Data table as parameter in sql server?

0 Answers  

---

Mention the uses of stored procedures.

0 Answers  

---

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

---

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? : Sql server administration

0 Answers  

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

0 Answers  

---

Is a primary key unique?

0 Answers  

---

How to see existing views in ms sql server?

0 Answers  

---

Explain optimistic and pessimistic concurrency?

0 Answers  

---

Can two tables share the same primary key?

0 Answers  

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---