It’s going to be a busy second half of the year in my calendar. I have been trying to be very restrictive in putting events there, just because I strongly believe that speaking at a technical event should be something special, deserving all my energy and at a place and audience that I love or would like to go. And because I am not targeting a speaker career only, I want to perform this part of my job with special attention and planning. I would like to give myself enough time between the events to not get exhausted. I would like to have enough energy to be able to give people something valuable.
Following that, I ended up with speaking at my favorite events – Oslo, Copenhagen, and Seattle. (See my new events calendar)
Today Microsoft has announced the CTP2 of SQL Server 2016 (http://sqlmag.com/sql-server-2016/ctp-2-sql-server-2016-now-available), the long waited public preview of the new SQL Server version. And as one of my friends said some time ago, “I was just about to retire when they release a new version and it became exited again”. Speaking of myself, I am not planning to retire soon, but a first CTP of a new SQL Server version is truly exciting event, like taking a new adventure, it is like getting a new motivation for the job.
So what motivates me in this new version and what I am planning to write and speak about in next few months (years) (and hopefully implement in practice and production environments).
I am rarely doing one of those posts that just targets clicks by fancy title and says nothing but a link that you could find by yourself. So beside giving you links and keywords of the product, let me share with you my favorite features that I am going to test and blog, and some info about how to start your own testing of this newly released CTP2.
After having a very intensive training at a customer site in Copenhagen, I am returning back to Sofia just a night before the third Bulgarian SQL Saturday event.
The training in Denmark was very exciting for me! I had a group of about 18 people, all of them curious, polite and eager to understand and get everything I had to talk to them. I did a customized training from my SQL Master Academy program for DBAs and for Devs, We had some important topics on SQL Server configurations, backups and major maintenance tasks, indexes and statistics, as well as some basics concepts of monitoring and troubleshooting, They learned how to check and configure properly their SQL Server Instances, to build good maintenance tasks and to perform check in case there is a problem with their Server or database. We then had a Dev part, where they were even more curious and passionate about query tuning, execution plans, cardinality errors and different code optimization techniques.
I love those moments in my trainings when I see attendees’ look as if there were a lamp that suddenly has turned on in their heads and they become so happy. I also love the moments when they start asking questions which answers come two slides after that. You feel that you align the training with their experience, expectations and way of thinking. It is just a great feeling!
I hope to come back again soon and do some SQL stuff again with those great people.
Now its time for the third SQL Saturday in BG. Love to present at BG Conferences, that’s my audience and I always prepare something interesting and special for them. Cant wait to meet you all again!
My sessions this year will be:
Let those statistics be with you! – a demo-only session that explores statistics and tries to give you all the understanding you need on that topic
A deep dive into SQL Server Plan Cache Management – yeat another deep dive session for this year 🙂
The sessions summary:
Let those statistics be with you!
There are a lot of questions about statistics that I receive in my trainings, projects and during my sessions: Why I have to rebuild statistics, if my auto-update stats option in ON. Why I still have bad plans or high CPU usage? Should I disable it or use full scan instead? We usually rely on auto-update stats database options and sometimes perform a regular stats updates additionally in order to be sure that the QP has an up to date info about our table data. But there are some specific cases when those thinks just don’t help and even recompiling don’t boost the performance of a query. Let me list and explain for you some statistics updates exceptions cases and you will understand how to proper manage your statistics in order to gain max from them.
A deep dive into SQL Server Plan Cache Management
As an experienced DBA you have probably asked yourself questions like how the memory is consumed, is my system well-tuned, and is my memory configuration well defined. In order to understanding such processes as local and global Memory pressure, caches concurrency, adding and removing plans from cache we will go through the internal organization of the plan cache, the metadata available, how SQL Server finds a plan in cache, plan cache sizing, and the plan eviction policy. We will point out the important cache consumers that affect your workload and how to get metadata about them, what are the thresholds in Cache Size Management. At the end you will understand how to monitor the memory consumers in your SQL Server, what are wait types that we need to look for, how to understand if your system is well-tuned and the memory configuration is well defined
Thanks for taking the time to read my blog! I hope you find the tips and techniques useful in your day-to-day journey as a SQL Server professional.
As you look to get the most from your database environment and career, I wanted to extend a special invitation for you to join me and 5,000 fellow SQL Server professionals from around the world at PASS Summit 2014, Nov. 4-7 in Seattle, WA.
PASS Summit – the world’s largest SQL Server conference – is an amazing opportunity to connect, share, and learn with other SQL Server and BI pros like you and me.
With over 200 sessions across 5 topic tracks and 70+ hours of networking opportunities, PASS Summit is packed with the most intensive SQL Server and BI training available anywhere. Summit’s practical sessions are designed to help you increase your knowledge, keep your skills up-to-date, and gain strategic insights from the world’s leading experts that you can put into action immediately when you get back to the office. Plus, you can bring your pressing questions to the Microsoft SQLCAT team, meet me and other MVPS and community experts in the Community Zone, talk with your local PASS Chapter leader, and more – every day at Summit is a chance to make lifelong friends, like I have.
I hope to see you at Summit – here’s where you can register – and please let me know if you’re attending so that we can connect!
Can I have predictable Online Index Rebuilds (cont.)
The Managed Lock Priority in SQL Server 2014 give us a choice for managing locks of the online index rebuilt operation.
We need to do that because the online index rebuild operation is not performed entirely online. There are Schema locks that the process need to obtain at the beginning and at the end of the index rebuild and those type of locks (especially Sch-M one) could have incompatibility with other locks currently obtained on the object. Because of that some parts of the process need to be done in “offline” mode, and as a result we experience blocking.
In this part II of my blog post I am continuing to describe the Managed Lock Priority OIR with the second new option we have. What happens when we give a priority to a user transaction instead of the online index rebuild process.
I had an interesting case couple of months ago, which started with receiving several questions from a customer about SQL Server replication. Some of them were “Should I use replication at all?”, or “Should I consider using replication on satellite network?!” This cough my attention and I dived into the case, I had to find out why the people where so upset about SQL Server replication (I had some ideas though 🙂 ).
As I already wrote in my post “Be careful with scheduling online index rebuilds” the problem with online index rebuild (except the need of huge amount of resources) is unpredictability and blocking. In my customer’s case the online index rebuild take between 2 and 12 hours. The new option in SQL Server 2014 called Managed Lock Priority seems to provide at least first steps in getting a solution to the problem (or creating additional problems?). The new feature allows a DBA to manage the S-lock/Sch-M lock for OIR.
As this new feature brings more questions than answers, it really grabbed my attention. So I decided to dive into it and to try to define when and how to use it.