Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Define master database?
What is query parameter in ssrs?
What is a trace frag?
How to add additional conditions in SQL?
What is truncate table?
What are the elements of dbms?
How to create a new table in a given schema?
What are the types of sql server?
What are alternate keys?
What is snapshot replication?
What is a trigger in sql server?
How can you fetch alternate records from a table?
What are the database roles? : sql server security
What is field with example?
What is #table in sql server?
