Premium Content

Access "The most dangerous game: Hunting down bad SQL query performance"

Don Jones, Contributor Published: 13 Oct 2012

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

What's Inside

Features

More Premium Content Accessible For Free

  • Understanding SQL Server virtualization
    Handbook_VirtualizingSQLServer_final.PNG
    E-Handbook

    These days, virtual servers are often seen as time- and money-saving efforts for businesses. When deciding if going virtual is the right thing to do,...

  • Understanding Microsoft SQL Server business intelligence options
    Handbook_cover_understanding_eval_SQL_server.png
    E-Handbook

    Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business ...

  • SQL Server and big data strategies
    Striking_It_Rich_SQL_Server_Joins_the_Rush_to_Harness_Big_Data_final.PNG
    E-Book

    Microsoft has worked to address the big issue of "big data," as companies are dealing with a constant influx of digital information. SQL Server is no...