-
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.
http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en
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
http://www.microsoft.com/downloads/details.aspx?familyid=5564386A-28C2-4483-8293-76FFF67B9EB3&displaylang=en
PAL (Performance Analysis of Logs) - used to analyze the data collected by the Performance Monitor
http://www.codeplex.com/PAL
Itay Braun
Veni Vidi Fixit