Archive for 'Application Performance'

CXPacket What?

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

Ensure Proper SQL Server Connection Pooling

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

Don’t Forget Application Caching

When it comes to SQL Server performance, many organizations look to their DBAs to help fine-tune hardware configurations, optimize indexes, or weed out poorly written code and queries. Consequently, many performance tuning topics and suggestions commonly center upon tasks and changes that DBAs can make to optimize performance.