Page - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Page

Author

Topic

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-14 : 05:17:47

Hi

Can any one please explain the below DMV's...

sys.dm_db_index_operational_stats
sys.dm_db_index_physical_stats
sys.dm_db_partition_stats
sys.dm_db_index_usage_stats
-------------------------
R..

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-07-14 : 06:05:37

http://technet.microsoft.com/en-us/library/ms174281.aspx
http://msdn.microsoft.com/en-us/library/ms188917.aspx
http://msdn.microsoft.com/en-us/library/ms187737.aspx
http://technet.microsoft.com/en-us/library/ms188755.aspx

Google is your friend. It is easier to read what has already been written than re-explaining these.

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-14 : 06:14:37

Thanks..but some of the sites blocked here......:)

-------------------------
R..

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-07-14 : 06:29:33

How can the microsft site be blocked?!?

Tell your employer that you need acess to them. They are work related, especially if you are doing SQL Server or using any other Microsoft program.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-07-14 : 06:32:12