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 2 of 49 (488 total posts)
  • Log Page Life Expectancy over time

    You often see Page Life Expectancy referred to as an interesting performance monitor counter. And it can be! It indicates for how long a page is expected to stay in cache, from the time it was brought into cache. But just looking at a snapshot value doesn't say that much. It might be high, but that is because you haven't had a high turnover ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on September 7, 2016
  • The DIY guide for local-global aggregation

    If you have read the title, you will not be surprised when I tell you that this blog is about a thing called “local-global aggregation”, and on how to do that yourself. So let’s start with the two obvious questions: what the heck is local-global aggregation anyway, and why the heck would you ever want to do it yourself?   What is ...
  • How TOP wrecks performance (part 2)

    In my previous post, I showed how the vanilla version of TOP can really help performance by nudging the optimizer into picking an execution plan that is optimized for returning just a few rows instead of the entire result set. But I also showed that adding WITH TIES causes a cardinality misestimate, which may lead to suboptimal or downright ...
  • 24 Hours of PASS - Evolution of the Data Platform - The Grand Finale - Schedule Change

    I was originally schedule in the 24th slot of the upcoming 24 Hours of PASS which was to begin at 7am ET on May 26.  I called it the Grand Finale. As with many events, schedule conflicts arise. So, the Grand Finale session will now be referred to me as the Grant Finale session.  Grant Fritchey will now be speaking at 7am ET on May 26. ...
    Posted to Rick Heiges (Weblog) by RickHeiges on May 22, 2016
  • SQL Server 2016 Query Store: How to fix problems you face for slow running queries

    This article allows us to focus on a new feature of SQL Server 2016 known as Query Store. We will talk about performance issues related to the query plan choice change and how the Query Store can help us to identify queries that have become slower.   Introduction Have you ever experienced to have your system slowed down or completely down? ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 30, 2016
  • New Article: What's New in SQL Server 2016 Availability Groups

    I am pleased to announce that I had another article published at TechTarget.com (SearchSQLServer.com). The topic is focused on what's new in SQL Server 2016 Availability Groups.  I actually created this article a while back and finally got published. It does not have information about Basic Availability Groups, but I will be blogging about ...
    Posted to Rick Heiges (Weblog) by RickHeiges on January 20, 2016
  • A new superpower for SQL query tuners – Number of Rows Read

    There’s a technique that I’ve been using for some time now, and been looking for going even further back, which has become immediately available to everyone who can see a query plan (version permitting). Some years back (ok, it was 2010), I started to present at conferences about SARGability and residual predicates. I had a session at SQLBits ...
    Posted to Rob Farley (Weblog) by rob_farley on December 11, 2015
  • The free #eBooks series #SQLServer and .NET Blog

    The series of free eBooks ''The SQL Server and .NET Blog eBook Series'' by Artemakis Artemiou (@artemakis) collects dozens of articles explaining how to solve practical problems in these areas: Database DevelopmentDatabase AdministrationPerformance Tuning Developing SQL Server (The SQL Server and .NET eBook Series)This ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on November 16, 2015
  • Revised File & Wait Statistics Procedures

        For many years I have been using a set of stored procedures to capture and report on both the file and wait statistics inside of SQL Server and I just recently did some more modifications that I wanted to make available. Since many of you have received copies of the past revisions via conferences or articles and such I ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 2, 2015
  • SQL 2014 queries under a strobe light

    I just wrote a post about Live Query Statistics. Let me show you how this technology in SQL Server 2014 can be used for some amazingly cool (nerdy cool, at least) stuff. Behind the scenes, LQS uses a DMV called sys.dm_exec_query_profiles. When you run a query with SET STATISTICS PROFILE ON, the engine puts data into this DMV for every operator in ...
    Posted to Rob Farley (Weblog) by rob_farley on August 31, 2015
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement