Schlagworte: dmv

SQL Server 2012 Diagnostic Information Queries

Jan 10th

Posted by Christoph Muthmann in SQL Server

No comments

Good news from Glenn Berry! He has finished his update on his set of Diagnostic Information Queries for SQL Server 2012.

Full story »
administration, dmv, entwicklung, performance

September 2011 SQL Server 2008 Diagnostic Queries

Oct 4th

Posted by Christoph Muthmann in SQL Server

No comments

There is a new set auf diagnostic queries by Glenn Berry available:
You will find them here!

administration, dmv, entwicklung, performance

SQL Server 2008 R2 System Views Map

Dec 9th

Posted by Christoph Muthmann in SQL Server

1 comment

The Microsoft SQL Server 2008 R2 System Views Map shows the key system views included in Microsoft SQL Server 2008 and SQL Server 2008 R2, and the relationships between them. The map is similar to the Microsoft SQL Server 2008 version and includes updates which are also applicable for the Microsoft SQL Server 2008.

You can download it from here!

dmv, download, sql server 2008 r2

Missing Indizes DMV hat Schwachstellen

Mai 3rd

Posted by Christoph Muthmann in SQL Server

No comments

Hallo Leute,
dieser Blog Eintrag von Paul S. Randal (er hat u. a. DBCC CHECKDB entwickelt) beschreibt recht anschaulich, dass man sich von den Vorschlägen des Optimizers nicht verrückt machen lassen sollte und selber mit Intelligenz ans Werk gehen muss, wenn man nach fehlenden Indizes fahndet. In der Version 11 (Achtung: SQL Server 2008 R2 ist Version 10.5) wird dies wohl gefixed:

http://www.sqlskills.com/BLOGS/PAUL/post/Missing-index-DMVs-bug-that-could-cost-your-sanity.aspx

dmv, performance, sql server 2008