If you are concerned with SQL Server application performance and want to learn how to fully optimize for performance, we have some great new materials for you. We recently recorded a webinar that we sponsored with Pinal Dave from SQLAuthority.com. He provides some excellent tips for tuning SQL Server that include some obscure but simple settings that can result in a dramatic improvement in performance. It’s not all about NitroAccelerator, but his demo at the end is excellent and a powerful reminder of how you can improve performance with the product in just minutes.
We have also just released a tech brief targeted at application developers that gives some good reasons for them not to immediately discount the venerable 2-tier architecture. For SQL Server and .NET developers there are some important considerations for them in making decisions on their application architecture.
Last, but not least, you may want to refresh your knowledge on how to diagnose and optimize SQL Server network performance. Read our white paper or read Pinal’s excellent blog, SQL SERVER – Identifying Application vs Network Performance Issues.
Many people think that applications, databases, and networks are all completely separate areas relating to performance and security. At Nitrosphere, we are committed to breaking down those walls and enabling the owners of the applications to fix performance regardless of who might be “responsible”. The materials I mention above can help you learn more about this approach.