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

Blogging in the sky – Emirates Business Class Experience

Hi friends. And yes as the title suggests, I am blogging at an altitude of 10,300 m and at a speed of 910 kmph. And I am writing this under the lights of stars inside the flight. Welcome to the Emirates business class experience. If you have followed my Tweet and posts on LinkedIn and Facebook you would know where I am travelling.

Blogging in the sky Blogging in the sky

If you haven’t already known, I am going to PASS Summit 2014. This is my first time to PASS Summit. For that matter I never attended a PASS event. So what are my plans for the next week? I am not going to stop the One DMV a Day series for sure. No matter where I am and what I am doing, I will make sure to get the daily dose to all the SQL geeks.

Well I am in travel for next 20 hours. Thanks to WordPress, I have scheduled the next DMV blog for 9:30 AM IST. I will land in Seattle at 12:00 noon PST on 2nd Nov. So if you are around for PASS or near Seattle, just drop a word and I will get connected with you.

For the next whole week I will be talking, breathing, learning and living SQL Server. Let’s spread the knowledge of SQL Server. Throughout the week I will be spending at various events of SQL PASS. They range from SQL Run, pre-con sessions, karaoke, networking dinner, table top games all with my fellow SQL folks around the world.

Finally, I want to convey my Thanks to my company who has sent me to such a wonderful event of SQL Server.

Vice President

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

One DMV a Day – 31 Days and it continues

Hello friends. I generally used to start all my blogs with β€œHello Geeks” and it sounds different writing my experiences and starting them with β€œHello friends”. Change is good and the only thing constant in this world. So it is always good to do something different. And there is a popular question on self-realization on living life. β€œWhen is the last time you did something for the first time in your life?” Well for me I have been doing many new things for the first time since last few months.

One of them is to start my One DMV a Day blog series on SQL Server Geeks. I have been an author on SQL Server Geeks since January 2013 and have been very infrequent in writing blogs. In fact I used to blog once in 2 months. Since January 2013 I have blogged only 12 blogs till Sep 2014. And not even single blog since March 2014. We got the SQL Server Geeks site revamped and the change ignited something in me.

The new site is so welcoming for me to start with a series of blogs. And as I started writing it has become a routine now. Today I have reached the milestone very few have achieved by writing a series with daily frequency. 31 DAYS. Yes, I have written more blogs in last month than I have ever written since I started blogging.

I wanted to put up this blog so that I can encourage my friends who are interested to give something back to the SQL Community. All it takes is dedication and time management. As it looks the blogs may take 10-15 min to skim through and a good 30 min – 1 hour to try the demos in them. But to put up such content for any blogger would take at least 2-3 hours at the bare minimum. This includes the content preparation, research, editing, formatting, posting, etc. This is not an easy job when you do it daily.

To write up a deep technical blog the efforts put into the research and time spent will be more than few days in some cases. The fuel which keeps a blogger going is the encouragement from the community. The acknowledgement from the readers who get benefitted one or other way from the blog.

The happiest day for me would be when I receive an advice on my blog. That shows experts are reading my blog. We are working as a community to give back the knowledge we have. A learning curve is built on constructive feedback. Advices like that are always welcome as it increases the scope of my learning. This in turn helps me provide better content for the readers.

Finally I would like to conclude by thanking the core team of SQL Server Geeks and Amit Bansal for encouraging us bloggers to do what we are doing. And a big THANK YOU to the SQL community which has given so much to us and made us what we are today.

P.S: This is not the end to my DMV series. It will still continue…


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