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
What is row_number function?
How to bind a view to the schema of the underlying tables?
Do you have any idea about the tcl commands?
what are the different stages of Report Processing?
How can you know if the row fetched from cursor is still valid in underlying table?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How do I connect to sql server database?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
Explain primary key?
What is a heap?
Can a database be shrunk to 0 bytes, if not, why?
What is filestream?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How to create a large table with random data for index testing in ms sql server?
Can we deploy SSRS reports on our personal website?
