Category Archives: DMV

TempDB Contention 2.1.%

Problem: When you are performing many DML operations and makes tempdb contesnion on it, You may get wait_resource of  2.1.103 check perfomance counter: Temp Tables Creation Rate Temp Tables For Destruction When you are performing many DML operations and makes … Continue reading

Posted in DB Design, DMV, Internal, Lock/Blocking, Performance Tuning, TempDB, Troubleshooting | Leave a comment

Sql server 2012 links

Feature of sqlserver 2012 http://arifudin.com/sql_server_2012_features good alternative to dbcc ind in sqlserver 2012 SYS.DM_DB_DATABASE_PAGE_ALLOCATIONS http://www.jasonstrate.com/2013/04/a-replacement-for-dbcc-ind-in-sql-server-2012/

Posted in Denali, DMV, What I learned today, Whats New, Whitepapers | Tagged , , , | Leave a comment

Denali – Day 14: New DMV & DMF

Denali – Day 14: New DMV & DMF   As there has been so many DMV/DMF already introduced in earlier version of Sql server, Denali does not have much on this part, but 5 new dmv/dmf and 1 modified here … Continue reading

Posted in Add/remove, Denali, DMV, Whats New | Tagged , | Leave a comment

Performance Tunning Part 2

After checking on the net found that there are lots of lots of good stuff (queries) already describe the performance related information, so I would like the share and refer some of the very good site. I have already blog … Continue reading

Posted in DMV, Lock/Blocking, Performance Tuning, Whitepapers | Tagged , , | Leave a comment

Miscellaneous Info

Some undocumented and important stuff   DMV: dbcc showcontig – index_physical_stats will scan complete index pages even if you use where clause Backup : uses 960k speed can reduce to 64k. Virtual File Space … for 32 bit system. Default big … Continue reading

Posted in DMV, Experts, General, Others, Tool | Tagged , , | Leave a comment

Important: System Objects/Views/DMV/DMF

Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF. Catalog View: All system information is stored on catalog views which look like Sys.xxx Eg. Sys.databases Compatibile views: This are views to manage old compatibility Select * … Continue reading

Posted in DMV, General, Index, Memory, Performance Tuning | Tagged , | Leave a comment