SQL Server Performance Blog

By Mitch Bottel, April 19, 2011 Ever receive a late afternoon call just as you are unplugging your laptop to head home from an angry developer complaining about latency in his application trying to return data from your server? I know, I know, your first thought is “why did I answer that phone?” He claims [...]

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 [...]

By Michael Campbell, March 14, 2011 Performance tuning tips come in many different shapes and sizes. Some represent technical ‘deep-dives’ into aspects of how SQL Server’s storage engine or query process tackles certain tasks – while others represent simple (or even complex) best practices for avoiding certain behaviors or problems. The key thing that all [...]

Brett Hawton – 3 November 2010 Typically DBA’s are not network gurus and the only time they are pretty sure that the network is in trouble is when the server cannot be remotely accessed. However when I was a DBA there was always a suspicion that there were times when the network was working sub-optimally. [...]

Brett Hawton – 3 September 2010 A great many articles have been written about using the /3GB setting to optimize the performance of SQL Server on systems having 4GB of memory. Typically on a 4GB system 2GB is reserved for the OS (more technically Kernel-mode virtual memory) with the other 2GB able to be consumed [...]