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
Can you insert NULL in unique column?
What are the advantages of using stored procedures?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
Tell me the difference between clustered and non-clustered index?
State the difference between union and union all?
How to create stored procedures with parameters in ms sql server?
What is nonclustered index with included columns ?
What is partition index in sql server?
What is difference between clustered and non clustered index?
How to check if stored procedure is running in sql server?
Can we store videos inside the sql server table?
How to delete database objects with "drop" statements in ms sql server?
How to modify an existing stored procedure in ms sql server?
what is a self join? Explain it with an example? : Sql server database administration
What is recompile sql server?
