Access "The most dangerous game: Hunting down bad SQL query performance"
This article is part of the July 2011, Vol. 6 issue of SQL Server virtualization best practices: A checklist for success
Once you’ve fine-tuned your databases’ indexes, maxed out your hardware and gotten the fastest disks money can buy, you’ll hit a limit on how much performance you can squeeze from your SQL Server machines. At some point you have to focus on fine-tuning the applications rather than beefing up SQL Server itself. That takes you into the somewhat tricky world of query analysis, where you try to identify database queries that -- because of the way they are written --aren’t performing as well as they could be. SQL Server comes with an excellent tool, SQL Profiler, that’s designed to capture traces. Think of these as similar to a network packet capture: You’re actually capturing the raw queries being fed to SQL Server, along with information about their execution time. Using this raw data, you can spot bad SQL query performance, and then offer advice to the application developers on how to improve them. For more on SQL query performance Find out how statements can help SQL query performance Learn to predict SQL query performance on larger sets Actually improving ... Access >>>
Access TechTarget
Premium Content for Free.
What's Inside
Features
-
-
As Microsoft's SQL Azure gains altitude, industry eyes chances of reign
by Beth Stackpole, Contributor
As independent software vendors begin to roll out core business systems on Microsoft SQL Azure cloud service, larger enterprises are slower to migrate.
-
As Microsoft's SQL Azure gains altitude, industry eyes chances of reign
by Beth Stackpole, Contributor
-
-
The most dangerous game: Hunting down bad SQL query performance
by Don Jones, Contributor
SQL Server is faster when the queries behind your applications are faster. Learn how to spot bad SQL query performance, and then work with developers so you can improve throughput.
-
The most dangerous game: Hunting down bad SQL query performance
by Don Jones, Contributor
-
News
-
SQL Server virtualization risks: among all the pros, some cons
by Alan R. Earls, Contributor
Virtualization promises big savings for businesses, and few are decrying its influence. But is it always the answer? Are there SQL Server virtualization risks to learn about first?
-
SQL Server virtualization risks: among all the pros, some cons
by Alan R. Earls, Contributor
More Premium Content Accessible For Free
-
E-Zine
Should you upgrade to SQL Server 2012?
Are you going to upgrade to SQL Server 2012? This edition of SQL Server Insider sets out to help you decide whether the investment is worth it or not...
-
E-Zine
SQL, NoSQL technologies coming together in new Microsoft project
Everyone knows SQL and NoSQL technologies don't co-exist well. But can they? Check out Issue 3 of SQL Server Insider E-Zine to find out about the ...
-
E-Zine
Azure Cloud testing tips for SQL Server shops
As Microsoft continues to extend its reach with its most recent offerings, customers are presented with new opportunities and challenges alike. Read ...