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 5 of 21 (208 total posts)
  • sys.dm_exec_query_profiles – FAQ

    As you probably know, this DMV is new in SQL Server 2014. It had been first announced in CTP1 but only in BOL. Now in CTP2 everyone can “play” with it. Since BOL is a little bit unclear (understatement detected), I’ve prepared this small FAQ as a result of discussion with Adam Machanic (blog | twitter) and Matan Yungman (blog | twitter). Q: What ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on October 21, 2013
  • New DMV–yes… no… that’s complicated

    Remember the excitement about new sys.dm_exec_query_profiles DMV? It promised to be a gamechanger, providing query visibility at a runtime and easily extractable information about heavy iterators in execution plan. So it has been announced but missing. Now in CTP2 it is finally here. So, singing one of my favorite Queen songs “… It finally ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on October 16, 2013
  • SQL Server 2014 – delayed transaction durability

    As I’m downloading SQL Server 2014 CTP2 at this very moment, I’ve noticed new fascinating feature that hadn’t been announced in CTP1: delayed transaction durability. It means that if your system is heavy on writes and on another hand you can tolerate data loss on some rare occasions – you can consider declaring transaction as DELAYED_DURABILITY = ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on October 16, 2013
  • 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
  • New DMV… not yet

    Downloaded and installed new toy: And while reading BOL, stumbled upon new extremely useful DMV: sys.dm_exec_query_profiles. This DMV enables DBA to monitor query progress while it is being executed. Counters in the DMV are per operation per thread. So we’ll be able to monitor in real time which thread (even for parallel processing) processes ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on July 1, 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
  • Israeli SQL Server Usergroup: Locking and Blocking in active environment

    A week ago I gave my session on the subject. It is only first part of the two – second will be next time when there is an open slot. Demos from my session are available here.
    Posted to Michael Zilberstein (Weblog) by mz1313 on May 13, 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
« First ... < Previous 3 4 5 6 7 Next > ... Last »
Privacy Statement