Mustafa EL-Masry Administration

How to build , Manage and monitor your SQL Server replication


Hello my friends this my small post in SQL Server replication it is not everything about replication but at least it is the what any DBA should know it 11 Posts in SQL Server replication technology english and arabic posts

  • What is SQL Replication?
  • Types of SQL Replication
  • Replication Overview
  •  How to create Transaction Replication
  • How to Add New Publisher Server to the Distributor Server
  •  Disable Publishing and Distribution Servers
  • Publication Status
  • Subscription Status
  • Replication information for the Complete setup
  • Find publication article
  • How we can Check Distributor agent status
  • How we can Check log reader agent status

downloadreplica

All this previous point you can know it easily from the below Posts :

  1. Replication in SQL Server Part 1
  2. Replication in SQL Server Part 2
  3. Replication in SQL Server Part 3
  4. Replication in SQL Server Part 4
  5. SQL Server DMV Replication Monitoring Part 1
  6. SQL Server DMV Replication Monitoring Part 2
  7. SQL Server DMV Replication Monitoring Part 3
  8. SQL Server DMV Replication Monitoring Part 4
  9. الأكواد الديناميكية لمراقبة ومتابعة حلول تزامن البيانات 1/ 3
  10. الأكواد الديناميكية لمراقبة ومتابعة حلول تزامن البيانات 2/ 3
  11. الأكواد الديناميكية لمراقبة ومتابعة حلول تزامن البيانات 3/ 3

Follow me because i will do one online session in replication and i will enhance all this posts by adding lot of other information in replication .

To check all my posts you can direct to my personal website or you can download this Excel sheet My Technical POSTS

View all my tips , LinkedIn , Website , Slideshare ,Youtube Channel.

Mustafa EL-Masry SQl server Administration

Awesome!! DMV and Stored procedure for any DBA


 Untitled Hello every body today no new post today but i will share some amazing and Awesome!!  DMV and stored i created it to help me in my daily work really it is very helpful for any Database Administrator
  • Create Clustered Index on all HEAP Tables by on Single Click.

this one of the best DMV for me because it fast the process for me and it is very helpful by this Stored procedure i sued the technique of   SQL SERVER DYNAMIC QUERY to loop on all databases exists on my SQL SERVER CLUSTER where this databases is not in system databases and it should be with status online to retrieve from it

  1. list by all heap tables.
  2. Loop in this list to retrieve the best column can be Clustered index Based on the criteria that have been developed from my side (Customized option )
  3. build the T-SQL statment of create clustered index

For more information and for download DMV check the (POST &  VIDEO)

  • Index Statistics for all Databases Exists on your Server

NOW any DBA can return all his index Statistics and save it to decide what he need to do shall i should drop some index (UNUSED INDEX) or shall i should check the index size to take A wise decision we should have the information about the index (last user seek data and percentage , user scan , index size , drop index statement if you need to delete index,..ETC)

For more information and for download DMV check the (POST)

Continue reading “Awesome!! DMV and Stored procedure for any DBA” →