SQL Server Performance Blog

By: Michael K. Campbell, April 11, 2011 Coming to SQL Server from both a database developer and DBA background, I maintain that while tuning SQL Server’s ability to handle your application workloads is a viable way to increase performance, another way to bolster performance is to consider architectural and coding practices within your applications. This [...]

Michael Campbell – December 10, 2010 By default, SQL Server databases are comprised of two files: the primary data file (or .mdf) and the log file (or .ldf). It is, however, possible to configure SQL Server databases to use additional files – which can be an effective means of increasing SQL Server performance in SOME [...]

Brett Hawton 10 November During the talk I gave at the PASS Summit on 10 November entitled “Getting SAN admins good metrics to set up LUN’s which maximize SQL Server performance” I mentioned that the TSQL to run the query and that the Excel spreadsheet to process the results of the query would be available. The TSQL can be [...]

Brett Hawton – 3 September 2010 Over the past few months I have visited a number of large production SQL Server installations at various organizations. Whilst great care had been given to the optimal setup of both the SQL Server and attendant databases, little care was given to the initial sizing of TempDB. One of [...]

Brett Hawton – 7 September 2010 One of the most significant “grey areas” in SQL Server performance is the IO performance of your SAN, NAS or RAID array. To be fair, it’s not easy for a SAN administrator to juggle limited resources in order to provide consistently good performance to SQL Server’s widely varying IO [...]