diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


Optimize Application Performance by uncovering Hidden SQL Server Data

Many application performance problems can be traced to poorly performing database queries; however, there are many ways you can improve database performance. SQL Server 2005 gathers a lot of information that you can use to identify the causes of such performance issues.

In the January issue of MSDN Magazine, Ian Stirk highlights areas where performance can be improved by using information that is already being gathered by SQL Server 2005. Ian demonstrates how to obtain this information, discusses the underlying DMVs, identifies any caveats to be aware of when interpreting the data, and points you to additional areas where you might be able to realize performance improvements.


Ian includes a series of SQL scripts that detail the various aspects of the data collected by SQL Server 2005. The complete and fully commented scripts can be explored online or downloaded from the MSDN Magazine Web site.


SQL Server, Optimization, Application, Performance, Data, Database, Queries, Tips and Tricks, Microsoft

Share This Story, Choose Your Platform!

Do NOT follow this link or you will be banned from the site!