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

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,

---

What is normalization?

9 Answers  

---

What are the properties and different types of sub-queries?

0 Answers  

---

How can I tell if sql server is 32 or 64 bit?

0 Answers  

---

how to find 6th highest salary

0 Answers   Chetak Logistics,

---

How can a user-defined datatype be created?

0 Answers  

---

How to create a simple user defined function in ms sql server?

0 Answers  

---

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

---

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

---

Can two tables have the same primary key?

0 Answers  

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

How do you delete duplicate rows in sql server?

0 Answers  

---