Interested to Buy Any Domain ? << Click Here >> for more details...
what is IDE,DMV in sql server?
- 1 Answers
- 8708 Views
- Value Labs, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 6 Yes | 1 No |
What are differences in between sql server 2012 and sql server 2016?
What is transcation?Plz give One example?
What is system stored procedures?
can primery key be a non clustered index?
What is table level trigger?
explain declarative management framework (dmf) in sql server 2008?
How to use go command in "sqlcmd"?
What is an indexing technique?
What are the types of subquery?
How is a full-text index updated?
What is transact-sql ddl trigger?
Which institute is best for SQL Server 2005 Training?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
