One DMV a Day – The 80 day sprint

Hello friends,

I have been posting about my experiences till 3 weeks back but had took a break for the last three weeks. I had been trying to find my time to write the blog here but have been holding myself till I finish the 80 day blog series of One DMV a Day. I have a story as I have in every other blog post on this site. πŸ™‚

When the SQL Server Geeks site was revamped in late August I had blogged aboutΒ SQL Server Replication Log Reader Why and How latency occurs. Then I had started thinking about writing more frequently for SQL Server Geeks. Then my dear friend and the SQL Server Master, Amit Bansal has suggested to start a one day series. It sounded good and I thought of writing a 31 day series. There were many other 30 and 31 day series out on the net/web. So I said to myself, why to limit myself? So I did not know how many I am going to write and just started the series.

The initial days was hard as I was never used to writing blogs so frequently. 1, 2, 3, 5, 10, 15… Then I had been to Bob Ward’s SQL Talks in Bangalore. Β It was an encouragement to meet people who know me by my blogs. So I decided to write till I am exhausted of time, energy or DMVs. πŸ™‚

The great moment to attend PASS Summit added to my excitement. I pre-blogged and scheduled all the posts for the one week trip of PASS. This definitely took extra time everyday and a toll on my sleep. I hardly slept and wrote almost 4-5 hours every day after and beforeΒ my working hours. When I turn back, now I see what did that turn into, THE LONGEST ONE DAY SERIES EVER on any SQL Server topic. Can’t describe more about how I feel.

Now here is the complete list of One DMV a DayΒ series that you can read, review, share and learn.

Day 1 – sys.dm_db_index_physical_stats
Day 2 – sys.dm_db_index_usage_stats
Day 3 – sys.dm_db_missing_index_details
Day 4 – sys.dm_io_cluster_shared_drives
Day 5 – sys.dm_db_index_operational_stats
Day 6 – sys.dm_io_pending_io_requests
Day 7 – sys.dm_io_virtual_file_stats
Day 8 – sys.dm_db_file_space_usage
Day 9 – sys.dm_db_session_space_usage
Day 10 – sys.dm_db_task_space_usage
Day 11 – sys.dm_os_performance_counters
Day 12 – sys.dm_os_cluster_nodes
Day 13 – sys.dm_os_tasks
Day 14 – sys.dm_os_workers
Day 15 – sys.dm_os_threads
Day 16 – sys.dm_os_schedulers
Day 17 – sys.dm_os_wait_stats
Day 18 – sys.dm_os_waiting_tasks
Day 19 – sys.dm_os_process_memory
Day 20 – sys.dm_os_memory_clerks
Day 21 – sys.dm_os_memory_objects
Day 22 – sys.dm_os_memory_pools
Day 23 – sys.dm_os_memory_cache_counters
Day 24 – sys.dm_os_memory_cache_entries
Day 25 – sys.dm_os_memory_cache_hash_tables
Day 26 – sys.dm_os_memory_brokers
Day 27 – sys.dm_os_memory_cache_clock_hands
Day 28 – sys.dm_os_buffer_descriptors
Day 29 – sys.dm_exec_connections
Day 30 – sys.dm_exec_sessions
Day 31 – sys.dm_exec_requests
Day 32 – sys.dm_exec_sql_text
Day 33 – sys.dm_exec_query_plan
Day 34 – sys.dm_exec_text_query_plan
Day 35 – sys.dm_exec_procedure_stats
Day 36 – sys.dm_exec_query_stats
Day 37 – sys.dm_exec_trigger_stats
Day 38 – sys.dm_exec_cursors
Day 39 – sys.dm_exec_background_job_queue
Day 40 – sys.dm_exec_background_job_queue_stats
Day 41 – sys.dm_exec_cached_plans
Day 42 – sys.dm_exec_plan_attributes
Day 43 – sys.dm_exec_cached_plan_dependent_objects
Day 44 – sys.dm_exec_query_memory_grants
Day 45 – sys.dm_exec_resource_semaphores
Day 46 – sys.dm_exec_describe_first_result_set
Day 47 – sys.dm_tran_locks
Day 48 – sys.dm_tran_database_transactions
Day 49 – sys.dm_tran_session_transactions
Day 50 – sys.dm_tran_active_transactions
Day 51 – sys.dm_tran_current_transactions
Day 52 – sys.dm_tran_version_store
Day 53 – sys.dm_tran_top_version_generators
Day 54 – sys.dm_repl_articles
Day 55 – sys.dm_xe_packages
Day 56 – sys.dm_xe_objects
Day 57 – sys.dm_xe_object_columns
Day 58 – sys.dm_xe_map_values
Day 59 – sys.dm_xe_sessions
Day 60 – sys.dm_xe_session_object_columns
Day 61 – sys.dm_xe_session_tragets
Day 62 – sys.dm_xe_session_events
Day 63 – sys.dm_xe_session_event_actions
Day 64 – sys.dm_db_xtp_memory_consumers
Day 65 – sys.dm_db_xtp_transactions
Day 66 – sys.dm_xtp_transaction_stats
Day 67 – sys.dm_db_xtp_checkpoint_files
Day 68 – sys.dm_db_xtp_checkpoint_stats
Day 69 – sys.dm_db_xtp_object_stats
Day 70 – sys.dm_db_xtp_hash_index_stats
Day 71 – sys.dm_db_xtp_merge_requests
Day 72 – sys.dm_xtp_gc_stats
Day 73 – sys.dm_xtp_gc_queue_stats
Day 74 – sys.dm_db_xtp_gc_cycle_stats
Day 75 – sys.dm_db_xtp_table_memory_stats
Day 76 – sys.dm_db_xtp_nonclustered_index_stats
Day 77 – sys.dm_db_xtp_index_stats
Day 78 – Consolidated DMV Scripts – Part 1
Day 79 – Consolidated DMV Scripts – Part 2
Day 80 – Consolidated DMV series – Final Part

Hope you enjoy the series.

Happy Learning

Follow me on Twitter
Follow me on FaceBook
Connect with me on Linked In

My First Timer Experience at PASS

With the 50 days to One DMV a Day series, I have completed my first PASS Summit journey today. Well the series still continues. I had been bragging about a PASS experience blog post since last week. I had been saving all the excitement till I end the Summit before I share anything. So here is a brief journey of my last week.

It all started with the Emirates Business Class experience. The Mercedes Benz pickup, the Business lounge, the actual in-flight business class experience. And to add to all of this a blog that I posted while I was in the flight. That’s just the beginning to the whole week. And yes, we should beΒ afraid of polar ice caps melting.

Polar Icecaps

I landed in Seattle for the first time. The place where the company which created the wonderful Database product called SQL Server, has its strong roots. It was Sunday afternoon and the flight landed a couple of hours late than scheduled time. Again a limo pickup to drop off at the hotel, I loved it. And you know what I loved more? The view from my room. Off course, I never enjoyed it in the next five days.


Day 1 – Monday, 3rd Nov:

I meet one of the SQL Rock stars, Brent Ozar. I attended his class β€œHow to make your Apps Faster” in the Big Picture Theatre. It was completely different experience listening to the whole BrentOzar Unlimited group live. Brent,Β Jeremiah, Kendra and Doug were best at what they do. You will be even more amazed to believe that when you hear them live.

PassExp Brent Ozar

Day 2 – Tuesday, 4th Nov:

I couldn’t not go to the second day of the Brent’s class. I have chosen to get the knowledge out from the guys who does it the best way. Tim Chapman, Senior PFE and Denzil Riberio, Principal PFE from Microsoft. Complete 8 hours of their session reminded me of my ramp-up sessions I had when I joined Microsoft.


After the pre-con session it was time for the first timers’ orientation. A round robin introduction to few more first timers was fun. And now comes the Welcome reception. To know what I did, just see the below pics. Paul Randal, Kimberley Tripp, Kelen Delaney, Sean and Jen McCown, Tim RadneyΒ are few whom I captured. If only my battery did not die.

Day 1

Day 3, 4 and 5 – Wednesday, Thursday and Friday – 5th, 6th and 7th Nov:

Yes, I cannot say what I did different on all the three days. The first day I walk in and guess who I meet in the hallway? Bob Ward and Ajay Jagannath. Bob recognizes me and I can’t say how overwhelmed I was. It all started well and It was more like a single day with few power naps. I don’t know when I slept and when I was in a session. In between it was all about learning the tools and innovation in databases. Meeting people, networking, sharing solutions and ideas. Few more glimpses from what I have been doing.

Summit days

One famous thought which few of my friends used to discuss. What if we are all single threaded programs with lot of context switching of emotions running in a zillion core processor system? Awesome thought right? I was doing a lot of context switching since the last 3 three days and it’s time for me to go into sleep mode for the weekend.


Follow me on Twitter
Follow me on FaceBook
Connect with me on Linked In

A day with SQL Gurus and a Legend

Welcome to This is my first post on MYΒ site. I will start with a timeline blog related to my passion, SQL Server. On October 4th, 2014 in Bangalore there was session planned on SQL Server, SQL Talks. The event was hosted by the SQL Bangalore user group at Microsoft, Signature building, Embassy Golf Links, Domlur. The most exciting factor which got my interest was the show stopper of this show. None other than the legend, known for his deep SQL sessions, Bob Ward.

It was exciting to know that Bob Ward is in India and delivering a session. To add to the excitement there were sessions from Arvind Shyamsunder (the first MCM in India), Tejas Shas and Pradeep.M.M on Performance troubleshooting, Kane Conway on Power BI and predictive analysis and Balmukund and Vinod on SSMS Tips and Tricks. I would not miss that for anything in the world. It is a long weekend. The buses are jam packed. Luckily I got the tickets and booked the hotel. I was afraid of anything that may go wrong for me to attend this event.

As I thought the first hurdle started the day before the event. I cannot make an early checkin without paying an additional days charges. So I called up few of my friends and everyone is on vacation on the long weekend. Finally I called up Amit Bansal for any suggestions and he asked me to come over. I will write a separate blog on the time I spent with Amit and his great host role. πŸ™‚

So we (I and my wife, a weekend getaway for her πŸ™‚ ) arrive in Bangalore. I and Amit make it on time to the event. The first thing we do entering the conference room is walk straight to Bob and greet him. And the next person I meet is Tejas Shah welcoming with his ever smiling face. We got the best view seats and got ready got the cruise of SQL knowledge from the legend. The first session starts as Bob takes us through the memory lane of SQL Server with all his expertise. Its amazing that a person with that much knowledge can just amaze you with his memory on SQL Memory Architecture. πŸ˜‰

Bob Ward

The second session was drive through the case scenarios by Tejas Shas and Pradeep.M.M. I go back with these gurus when I worked for Microsoft IGTSC. Pradeep was my Technical Lead and I have taken Tejas’ help on couple of cases when working at Microsoft. It is always good to meet people from past. I revisited my old days with Microsoft and the troubleshooting techniques used there. They talked about few cases that were dealt by Microsoft and the depth of troubleshooting involved. It was a pure learning experience.

PradeepMM Tejas Shah

After lunch we had Arving Shyamsunder to talk about development and few cool features in Visual Studio online. How you can control issues before deploying into production. Working on data model to identify certain code bust and build bust before pushing them to any environments. A lot of takeaways from this sessions and only a man with his experience can deliver such great session and make it look so easy.

Arvind Shyamsunder

It was Bob Ward again and you would never get a thought of post lunch sleep when there is so much excitement. This time Bob tells you what you can do before reaching to Microsoft for help. Yes, he explains the best steps that you can do before you call the support. The demos involve solving issues for high case volume that come to Microsoft. The top ones on the list are Backup Restores, data corruption, Performance issues, Assertion dumps to name few. So the tips are always valuable from the expert and the legend himself.

Bob Ward

We had the next session from Balmukund and Vinod on the simple and efficient tips and tricks with SSMS and few very useful tools like tablediff. And towards the end of the day the energyΒ these experts bring to the attendees is awesome. You will experience only when you listen from them. Fun and learning. πŸ™‚


Kane has his way with Power BI and predictive analysis. A good way to prove our point in many cases as a DBA is to use effective reports with the data we have. Kane’s session is all about that.

Kane Conway

Over all the event was a wonderful time spent with the experts and their knowledge flow. Its our bandwidth to accept the flow of knowledge and use it efficiently. Last but not the least the group which has made this happen… THANK YOU.



Follow me on Twitter
Follow me on FaceBook
Connect with me on Linked In