January 2008 - Posts

New version of SQL Server 2005 Best Practices Analyzer (January 2008)

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.

A new version of the Best Practice Analyzer was recently released. I strongly recommend monitoring the configuration of the she SQL Servers using this great utility.

There are some major improvements regarding the Analysis Services cubes and dimensions design.



  Itay Braun                Premier Field Engineer - SQL Server                    Microsoft Services - UKE-Mail: itayb@microsoft.com          Mobile: +44-796-928-9996       Blog: http://sqlblogcasts.com/blogs/thepremiers/Veni              Vidi              Fixit 
Monitoring SQL Server using Performance Monitor

Monitoring SQL Server using Performance Monitor


Many customers asked me pretty much the same question: “I want to monitor the SQL Server 2005 using Performance Monitor. What are the most relevant counters?”

To answer this question I attached my list of counters. This is not an official list from Microsoft, just my recommended list.


Feel free to comment about my suggested list.



Relevant Links:

PSSDiag – configure pre-defined sets of Performance Monitor counters



PAL (Performance Analysis of Logs) - used to analyze the data collected by the Performance Monitor




Itay Braun

Veni      Vidi     Fixit



This Blog