THE SQL Server Blog Spot on the Web

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

Sergio Govoni

A place where share my experience on SQL Server and related technologies

  • SQL Server 2016 Cumulative Update 2

    Microsoft has released the Cumulative Update 2 for SQL Server 2016 (RTM)

    Enjoy! 

  • 24 Hours of PASS (September 2016): Recordings now available!

     
    The Sessions of the event 24 Hours of PASS named "Summit Preview Edition" (held the last September 2016 on 07 and 08) were recorded and now they are available for online streaming!
     
    If you have missed one session in particular or the entire event, you can view or review your preferred sessions.
     
    Each video is available on detail page of the related session.
     
    Enjoy!
  • PASS Summit is back! Looks inside the 2016 edition #Summit16

    The PASS Summit is back! This year, the most important event around the world for Microsoft Data Platform will be held again in Seattle (WA) from 25 to 28 October 2016 and it will be preceded from two pre-conference days from 24 to 25 October 2016.

    I wrote "the most important event around the world" because numbers of PASS Summit 2015 are self explanatory! Last year 5,000 data-geeks have attended the PASS Summit which has become the landmark event for the entire Microsoft Data Platform. Take a look at numbers of the year 2015, that are shown in the following pictures, they are really impressive, aren't they?

    Every year more and more IT Professionals, Technicians, Analysts and Data Scientists consider this event as a unique opportunity to: connect to other people that have the same passion you have, share your experience and the problems you face for your job and learn more and more about the Microsoft Data Platform for choose the best technology to win the challenges of the market.

    Don't forget that you also have the opportunity to meet and talk to people like Conor Cunningham (one of the principal architect of the relational Engine of SQL Server and SQL Azure), David DeWitt (one of the biggest expert of Parallel Databases), Bob Ward (Chief Technology Officer Microsoft CSS) and Mark Souza (General Manager in the Microsoft Data Platform Group). Are you thinking that people are too busy for a talk with you? Nobody of these big names walks away if you try to meet and talk them!

    If you are undecided about the contents provided at the PASS Summit, you can watch the sessions of the previous year on PASS TV and you will touch with your hands the quality of the sessions provided at PASS Summit!

    • PASS Summit 2015 – Day 1
    • PASS Summit 2015 – Keynote Day2 (David DeWitt and Rimma Nehme)
    • PASS Summit 2015 – Day 2
    • PASS Summit 2015 – Day 3 

    Are you a beginner or a "first timers" at PASS Summit? Don't worry there are lots of sessions of 100 and 200 levels and you can count on the "First Timers Guidebook" that it will arrive soon!

    What kind of sessions can you expect to see at the PASS Summit 2016? Find it out from September 07 to 08, 2016 at the 24 Hours of PASS: Summit 2016 Preview Edition, register now at this link, thanks to the sponsors, the 24 Hours of PASS is presented at no cost! This edition of 24 Hours of PASS wants to be a sneak taste of what you can expect from PASS Summit 2016.

    You can find all information you need on PASS Summit 2016 website and for your convenience, here some useful links:


    See you there!

  • SQL Server 2014 SP1 Cumulative Update 8

    Microsoft has released the Cumulative Update 8 for SQL Server 2014 SP1:

    Enjoy!

  • 24 Hours of PASS (September 2016): #SQLSummit Preview Edition

    Which sessions can you expect to see at the PASS Summit 2016? Find it out from September 07 to 08, 2016 at the 24 Hours of PASS: Summit 2016 Preview Edition.

    Register now at this link, thanks to the sponsors, the 24 Hours of PASS is presented at no cost!

    This edition of 24 Hours of PASS wants to be a sneak taste of what you can expect from the next PASS Summit that will be in Seattle (WA) from October 25 to 28, 2016.

    No matter from what part of the world you will follow the event, the important thing is to know that they will be 24 hours of continuous training on Microsoft Data Platform... direct on your computer!

  • SQL Server 2016 Cumulative Update 1

    Microsoft has released the Cumulative Update 1 for SQL Server 2016 (RTM):

    Enjoy!

  • SQL Server 2014 Service Pack 2

    Microsoft has released the Service Pack 2 for SQL Server 2014:

    These are the details of SQL Server 2014 SP2:

    • It contains all fixes released from the Cumulative Update 1 up to Cumulative Update 7 (of SQL Server 2014 SP1)
    • KB 3171021
    • The build number is 12.0.5000.0
    • SQL Server Release Services Blog post 

    Have fun!

  • SQL Server 2012 Cumulative Updates (July 2016)

    Microsoft has released the following Cumulative Updates for SQL Server 2012 (SP2 and SP3).

    Cumulative Update 13 for SQL Server 2012 SP2

    Cumulative Update 4 for SQL Server 2012 SP3

  • SQL Server 2014 Cumulative Updates (June 2016)

    Microsoft has released these Cumulative Updates for SQL Server 2014 (RTM and SP1).

    Cumulative Update 14 for SQL Server 2014 RTM

    Cumulative Update 7 for SQL Server 2014 SP1

  • SQL Server 2014 SP1 Cumulative Update 6 (new build)

    A couple of days ago, SQL Server Team has released a new build of the Cumulative Update 6 for SQL Server 2014 SP1.

    Those are the details:

    The previous build of the Cumulative Update 6, released with the KB 3144524 is now deprecated. If you already downloaded and installed the older CU6 package, it is recommended to install the updated CU6 build (12.0.4457.0) as soon as possible. 

  • 24 Hours of PASS (May 2016): Recordings Available!

    The sessions of the event 24 Hours of PASS The Evolution of the Data Platform edition (held the last May 2016 on 25 and 26) were recorded and now they are available for online streaming!
     
     
    If you have missed one session in particular or the entire event, you can view or review your preferred sessions. Each video is available on detail page of the related session.
     
    Enjoy!
  • Free eBooks from Microsoft Press

     
     
    Microsoft Press (@MicrosoftPress) gives you the opportunity to download many eBooks for free.
     
    There is one eBook for every taste :) to find and download the most interesting eBook for you, point your browser here.
  • 24 Hours of PASS (May 2016) – Agenda and Registration are now available

    Which is the evolution of the Microsoft Data Platform? Find it out on May 25 and 26, 2016 at the "Evolution of the Data Platform" edition of the 24 Hours of PASS!

    Register now, thanks to the sponsors, the 24 Hours of PASS is presented at no cost for you!

    The complete schedule of the event is available here.

    It doesn't matter from which part of the world you will follow the event, the important thing is to know that they will be 24 hours of continuous training on the evolution of the Microsoft Data Platform!

    The 24 Hours of PASS also wants to be a sneak taste what you can expect from the next PASS Summit that will be in Seattle WA from 25 to 28 October 2016.

  • SQL Server 2014 Cumulative Updates (April 2016)

    Microsoft has released the following Cumulative Updates for SQL Server 2014 (RTM and SP1).

    Cumulative Update 13 for SQL Server 2014 RTM

    Cumulative Update 6 for SQL Server 2014 SP1


  • 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? What happens? Everyone is waiting for you to fix the problem as soon as possible! The Boss is over your desk! Have you ever experienced to upgrade an application to the latest version of SQL Server and facing an issue with plan change that slows your application down? Query plan choice change can cause these problems. A performance problem related to the system database tempdb is not as hard to fix as a problem related to a query plan changes. You know, query plan changes give you more and more problems. As far as the tempdb is concerned, you can move it into a faster hard-drive or you can increase the number of the tempdb files, but when you have to find the slow running queries you have to figure out why they are slow!

    Detecting and fixing problems you face for slow running queries takes you long because you have to look into the plan change as well as the lock occur and a question grow up in your mind: What was the former plan like? So you try to find out an answer for this question, but, has the Data Collector been activated on the server? If the Data Collector hasn’t been activated the only tool you have to investigate slow running queries is the plan cache, but it may not be suitable for troubleshooting. When memory pressure occurs on the server, the queries you are finding could be already gone away from the cache. Finally, when you have the issue on your hands, can you modify the query text? If you cannot, do you know the system stored procedures to create and manage the Plan Giude?

    Supposing you are given a query with two predicates on it, one predicate has the highest selectivity, which plan is the best? Supposing you are given a query with two joint tables, for example you have the table A Joined to the table B. Which is the best way to implement the Join? A Joined to B or the opposite? Imagine now a query that has 80 joint tables. Each color in the following picture represents an execution plan generated and evaluated by the Query Optimizer for the same query. In practice we have hundreds or thousands possible plans for a query with medium complexity.

    Picture 1 – Execution Plans (Projects PICASSO: http://dsl.serc.iisc.ernet.in/projects/PICASSO)

    SQL Server Query Optimizer considers many plans, but when your data changes, it might select a different plan. Usually when it crosses a boundary, performance is approximately the same, but sometimes, the actual performance is visibly different.

     

    What does the query store do for you?

    The Query Store stores all the plan choices and related performance metrics for each query, it identifies queries that have become slower recently and it allows DBAs to force an execution plan easily! If you force an execution plan for a particular query, it makes sure your changes work across server restart, upgrades, failover and query recompiles.

     

    How the Query Store captures data?

    Every time SQL Server compiles a query, a compile message comes into the Query Store and the execution plan of the query is stored. In the same way, when a query is executed, an execute message comes into the Query Store, the runtime statistics are stored into the Query Store after the query has been executed. Query Store aggregates the information according to the time granularity you have chosen, the aggregation will be done in memory (because we don't want to kill the server) and then, based on the database option DATA_FLUSH_INTERNAL_SECONDS, aggregated data will be stored on disk in a background asynchronous way like the checkpoint mechanism.

     

     

    Picture 2 – How the Query Store captures data

    I have just told you that the aggregation is done in memory and not on the disk, so suppose an unexpected shutdown occurs, how many in memory data would be lost? If you keep a smaller number of data in memory, you will have bigger IO cost and a smaller number of information will be lost in case of an unexpected shutdown, otherwise, if you keep a bigger number of data in memory, you will lose a larger number of data in case of an unexpected shutdown, but you will have smaller IO cost. This setting is your choice! The important thing is that you have the possibility to choice! If you want to see data captured by the Query Store, you need a tool that combines both In-Memory and On-Disk statistics. Each DMV related to the Query Store, joined In-Memory and On-Disk data. For example, the sys.query_store_runtime_stats table valued function groups In-Memory and On-Disk data in a unified place, so you can use it your scripts or in your application.

    Bear in mind, when memory pressure occurs on the server, some data In-Memory will be flushed to the disk in order to release the memory for others.. read the complete article here..

     

    Additional resources about SQL Server Query Store are available here on docs.com:

    Enjoy the Query Store!

This Blog

Syndication

Privacy Statement