THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance   (RSS)
Showing page 4 of 16 (160 total posts)
  • Wait Statistics in Microsoft SQL Server

     (Originally appearing at http://kevinekline.com/2013/10/09/wait-statistics-in-sql-server/).When it comes to troubleshooting in relational databases, there's no better place to start than wait statistics.  In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular ...
    Posted to Kevin Kline (Weblog) by KKline on October 9, 2013
  • Stats on Stats

    I have been working on new features for the Rules-Driven Maintenance Solution, including per-index maintenance preferences and more selective processing for statistics. SQL Server stats is a topic I knew about at a high level, but lately I have had to take a deeper dive into the DMVs and system views and wrap my head around things like ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on September 18, 2013
  • Hear the SQL Server 2012 story on DotNetRocks

    I was privileged to have a chat with my buddies over at www.dotnetrocks.com, Carl Franklin and Richard Campbell, episode number 876 (876!). Listen to the most popular internet audio talk show for .NET developers!  Here's the abstract:Carl and Richard talk to Kevin Kline about the latest features in SQL Server 2012. The conversation ...
    Posted to Kevin Kline (Weblog) by KKline on May 31, 2013
  • Read the New TPC Database Benchmarking Series

    Let's talk about database application benchmarking.This is a skill set which, in my opinion, is one of the major differentiators between a journeyman-level DBA and a true master of the trade. In this article published in my monthly column at Database Trends & Applications magazine, I'll give you a brief introduction to TPC benchmarks and, ...
    Posted to Kevin Kline (Weblog) by KKline on April 22, 2013
  • Storage Performance

    Storage has changed dramatically over the last three years driven by SSD developments. Most of the key components necessary for a powerful storage system are available and the cost is highly favorable for direct placement of data files. Some additional infrastructure elements could greatly enhance the flexibility of storage systems with ...
    Posted to Joe Chang (Weblog) by jchang on March 24, 2013
  • Halloween Protection – The Complete Series

    I have just published a four-part series for SQLPerformance.com on the Halloween Problem. Some of you will never have heard of this issue, and those that have might associate it only with T-SQL UPDATE queries. In fact, the Halloween problem affects execution plans for INSERT, UPDATE, DELETE and MERGE statements. This is a topic I have been ...
    Posted to Page Free Space (Weblog) by Paul White on February 20, 2013
  • One more reason to to understand query plans, not directly performance related

    One of the things that separates a good programmer from a great one is a firm understanding about what is going on inside the computer. For some programming languages, it is very obvious what is going on inside the computer because you are working at a very low level. For example, if you are a C/C++ programmer writing an OS, you will know a lot ...
    Posted to Louis Davidson (Weblog) by drsql on January 22, 2013
  • Learn More About SQL Server IO and Query Tuning in These Webcasts

    I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.   SSDs are a Game Changer for SQL Server Storage No, session is not exclusively about SSDs.  But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks.  As Bob Dylan said ''Times, they ...
    Posted to Kevin Kline (Weblog) by KKline on December 14, 2012
  • Quick Tip - Speed a Slow Restore from the Transaction Log

    Here's a quick tip for you:During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time.  Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. ...
    Posted to Kevin Kline (Weblog) by KKline on November 14, 2012
  • The Zombie PerfMon Counter That Never Dies! Quick Tip

    The PerfMon Counters That Just Won't DieOne of the things that's simultaneously great and horrible about the Internet is that once something gets posted out in the ether, it basically never goes away.  (Some day, politicians will realize this.  We can easily fact check their consistency).  Because of longevity of content posted to ...
    Posted to Kevin Kline (Weblog) by KKline on October 8, 2012
« First ... < Previous 2 3 4 5 6 Next > ... Last »
Privacy Statement