Browse by Tags
All Tags »
How To (RSS)
It's a long time since I wanted to post some info concerning memory on this blog, but I always been confused on where to start from. To take away any doubt, let's start from scratch. Even amongst the most seasoned DBAs there is some confusion about memory
Read More...
As a second tool to assess your system configuration, today I am going to post about SQL Server BPA (another acronym!) aka SQL Server Best Practices Analyser (better). We have 2 versions available: - one for SQL Server 2000 ( http://www.microsoft.com/downloads/details.aspx?familyid=b352eb1f-d3ca-44ee-893e-9e07339c1f22&displaylang=en
Read More...
Today I want to post about three very useful free tools from Microsoft which can assist you in automating the process of assessing your systems : - MBSA (Microsoft Baseline Security Analyzer) - SQL BPA (Best Practice Analyzer) for SQL 2000 and 2005 -
Read More...
I've already blogged some time ago about Microsoft recommendation for SQL Server Storage Best Practices . Is there anything else you should be aware in order to maximise the performances of your disk subsystem ? Oh yeah. Volume Alignment (Or Sector Alignment)
Read More...
Hi all, Just wanted to thank all the attendees that participated to yesterday's event on SQL Server 2008 in TVP - Reading. We've received great feedback on the content of the day, and I really hope everybody went back home (for some of you I heard it
Read More...
I blogged some time ago about PAL ( Performance Analysis of Logs (PAL) Tool ), a great tool from CodePlex which allows you to quickly and automatically analyze a set of Performance Monitor logs and to easily spot which counters are "misbehaving" in your
Read More...
I've just realized how poorly documented is this great functionality that has been introduced in SQL Server 2005 . On the Microsoft Website, all you can find is this article ( http://technet.microsoft.com/en-us/library/ms175513.aspx ) and few more information.
Read More...
There is always some confusion when it comes to NUMA and few information on which are Microsoft recommended best practices especially when dealing with SQL Server. In this post I've tried to summarize the main considerations you should do concerning Hardware
Read More...
Just came across an issue on installing Litespeed from Quest http://www.quest.com/litespeed-for-sql-server/ on a Windows 2003 64 Bit environment . Litespeed in fact requires Microsoft OLE DB Provider for SQL Server, and after some troubleshooting we've
Read More...
When installing your SQL Server, 2000 or 2005, do never forget to check the recommended configuration of your storage space. I’ve collected over time a series of useful information regarding SQL Server Storage Best Practices , which are as follows: ·
Read More...
Something I should have blogged about some time ago, to save time to myself to send out information when I help my customer to raise a case with Microsoft Support (or to have a review of the system done by me) and to save time to the customer himself.
Read More...
I’ve just tried out this tool that is fantastic! It automatically analyzes a performance monitor output log and generates a HTML based report which graphically charts important performance counters and throws alerts when thresholds are exceeded . The
Read More...
Some useful posts\white papers that you can't miss if you're looking on how to increase or troubleshoot performances of Analysis and Reporting server: Analysis Services Processing Best Practices http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspx#Profile
Read More...
SQLIOSim is a great utility to perform tests on disk subsystems. These tests simulate read, write, checkpoint, backup, sort, and read-ahead activities for Microsoft SQL Server. The SQLIOSim utility has been upgraded from the SQLIOStress utility and more
Read More...
MPS Report is one of the standard tools used by Microsoft Support to facilitate the gathering of critical system and logging information ( view ). If you run it on Microsoft SQL Server 2000 Service Pack 4 though, you'll receive a Buffer Overrun check
Read More...
