Thanks for keep reading and motivating me to share as much as solution.
Today I will be discussing solution that we have setup infrastructure as per available device in infrastructure but suddenly we start seeing that database size is rapid increase as normal. What we do if such scenarios and how to bring in to solutions.
By seeing reported error, below are the action taken to bring in to the solutions.
We have validated current environment and run sql query to validate table disk space utilization and found that one of the table (TableChangeNotifications) was using huge size of disk space in available disk space. In client environment sql has 200 gb disk space but particulate table was using 160GB. Find the below snap shoot for reference.
After the finding of the table details, we have tried to find which key is using more space in this table.
Found that one of the able was holding more than 6.5 Milion of the table rows. By seeing details package id we have deleted from the console but due to replication issue table space not clear from the database. Find the screen shoot for reference.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAZ8AAABTCAYAAABAvwrvAAAgAElEQVR4Ae29B7weVbX3/53y9NNPkpPeGwkpEEgggtKbNKUoiAWvgu3a8Pp6fe//ekW9tstfsV9RwUITFMTQa0INLQ1Cek9OTm9Pf6a8n7XnTM5zkpNwAkGj7B2ezMyePbv8JuzfrLXXXsvwfd/vaGnhheefpz2dpqetnQlTxrDwhJPZtHEdFDwswyBMvpzIX4b6D9+HaGWURfc/xIP3P8TX/usrzJv3DratX0d3voc40fBRfdQIaAQ0AhoBjYBCwC7HwRBWiUbIFxwefeRRGht343re69KHFbXoaO9EKtuxvZGWlvtp3L4DzzSJlDegzzUCGgGNgEZAIwCKLxQQIsxEoga+X+Kxx55k/fr1iMBjGIqSDgyWD7ZtkXdd/rroQdLpHjLZLLFoVAlJB35Y39UIaAQ0AhqBtxsCvZKPqNU8DA8qk1VUViWZNm0KkUhUkc9gQbENk5LrgDGy9zmlpBvs47qcRkAjoBHQCLxNEAjIR7jHddVvwoSxjJs4As+VpZ2+tZ7B4GEpCguWhAZTXpfRCGgENAIagbcnAn1rPp7IPpBIRUhGavC8Qq9lweCB6bVDGPwDh2tJXwjUxjhI8j1ch6P7pRHQCGgEDjcE+sgnMGDD830c36GUE9Hnbag2U4tfPlErgoOHryj5cHttuj8aAY2ARuAfG4F+5KPMp0sGjuFQWVWFbfa//Y891EH23hbto0s+n8dxSoE9+SAffTsW85Vy9uDUs29HnPSYNQIagf4I9GcXUTdZPsmKJNU1Q7Et2aOzr/Szb07/Sge6+keYnnzfJ1VZQeOuXaxeuYzJkydhmoYio4HG9HbPM7HUnxKltzsUevwaAY3AQSKgyEeIwQFKvkUyVcHQoSPZvXUT3fmc2Fr3q9IEYuWU1P92v7LhhawlFfzDX4iwfZ9EKsnqV9by+OLnmTVrDhUV1RQKxXAo+hgiYPg4pSyZdObwf7Fhn/VRI6AROGwQ2CP5yFe/ZVs0NIymo6OVrFPEjuy5rTosC/Ai9ZR8oZMg+X7vPqByEtpLNDJNn6iQmFrID5/sfyxf3BdVzt8l+T6+YVDXUMfk8WPZurmRE0+aSD6Xx/P6+iRYqfUwNSZh1WDwsifqbZFk75fjsGV9I1ubtjF5/GQs06LkawnobfH+9SA1AocAgTJ2kYnTwfe9YH+PKTJOXxJyiPhRmrt7aNzdhiNSQjxCa7aK7kJC7REKTbM7uzrxPR+ZpE0KzBqbY86Mifiui8gQ5VO0aZiYpknMjPVal/nk3DyO6xzUHqO+nvadSb1CCJ7nqb703Rn4TNGLaRAhwpr1a3jq+WcZ2lCF5RRxHVvV0ZbN4hQdDOmfZeIXi0STSRwhZt+jvrIC2e/UR1UDt/WPnGuYsi5YYvmKV8gU8syaNgvP9Cjl9BrZP/J71X3XCPwtESgjn9drVqbTHJkcrGgZzg43RlVFkoht0tHdTWtjFIsktmXQ2F7ENMRWLEJXWw+uZzB7OsikRZkEYYqk4BjkcgXa/U4lV3muT2W8koraBOlsDlXm9bo2wH0hHcdx1HpNPBYnErHIFwepPvN9ItEI1TXVJMw4pZiJYTvYnk+6OcfI8TOoS4BXKipJSQh0y47tNDU1MmRIJUbExHf7pMMBurcna38L9qH0Vy4R7nnoMDhJ+RU0DG9g+apVrF61mqlTphKxIhT9ojZRPwzej+6CRuBwR+AgyAcMS4o7GF6e0ZURErECOeLkXBurtJtIJEW6ZJAyexhRl6bNmUCmLUO2oxWsqWC44AWyj0hFNak6XlyxgptvvYWdO3dSWZkgnS6w4Jhj+NQn/4VoNIpTClQ5nu+pSS1Ubcnz4cRdnhdKOvX19Sxe/ATLV6zkjJPPZlh9JdGKJI6SggJJSCb28NmBXpRSr4U3RNUUieJ7RaaPryGZqqKzuRkR+fLYZNdllXpONHLlkl34+EBHqT+ZTCqCLJYRo6iwhPxcz6VYKB6wjwPV+7fIMyzxOZvntdWvYRoeE6dOImpHKJYGSfB/i07qNjQCGoHDFoHBk4+or2QC9l2OnVrN8XNGErfg989nOGPGEGaPHkFLG9y+vJMzJo1h+PAE927yWXTLi/hYgQcFv29aFuKIxWLs3LmZTKaDU055JzNnzsYwSjyzZCnXfvs6fvSj77FlyxaqKquoTFVQyBdJp9PkcjmSlUlqq2rJFrJ0tHWQqkwSi0Ro7+rCtmyGDh1Gd3eGluZOHn9yMc3NjXzrW9+iraWFSCRGdXU1PeKDLpcZ1OQuRGG4LhHTprHFJ79lC93tu0m7caUi3LllN5glbJHuFC2KErJvvHv/CzAxsUyT5qZW7IhFIhFXRSzLwst6tLS3kEgmiCfjSoLb+/nD4toAMxrBjCbBFzXt4KS9w6LvuhMaAY3A3xWB/gs7B+qKSBqFEomox/DqAp5v4qUqGTeqiopEnGwhQSKVYEp9ilQqQiwaoZZuUm4PhtMOpotwUHkSAirmS4wYMZwzzjibSy65iEsuuYzxkyfy6iurqKqoIhVPsWXzFu68/S5efnE5btFl7KgJioj+cve9vPbaesaMnMDuxt1s3rCFykQlhUKeTZu30d2ZIxFPgeGzatVrLFnyHHUVtRTzRR6492HaWtqoqa7BVBNnec/2PVeU4kN3oZLNm1tpa0+TdqEja5HvSVMqpim6JQrpIqYZoypZpSqRMe6dJE+km5rKGn7x81+xfPkKIpGIIkGR9krFErffegfPPPkUQ2pr96xZ9ZPEhOLkney1EXjvvPB6f+XC+2Ef976W/IHywvLB8GSMYi/p7rWit6eUPtEIaAQ0Av0QGLzkI9OKCbZhkC+4tLV3YDsO9XTidRVZ3xRBNEctO3tYVxACsMntaiFa3EbKiuPL4r9QncxRZQJBKpGkvb2bhx9+kK1bt1Iq+fT05DjvvHPo6elR3rWfeOwJdu1qIl6R4JRT3kVbuounn3qap556inHjxuG4Lps3reeJx5/hD7/7Na8+/hrPPPkXmht3UVVdTTxawdat21i8+GGmTJzArXf8nm1bm3hu2VLef+nFNAxpwPEcXDV59sOn34XIMkXfZ9xokwljJuCbNh3t7WRydTQ0VGJbHpVVtXiOx9KXVnDMvBlKBsoWc/tIV4qUotDV08mLL77I7NlHUlNTo1Rtr21cwytr1zJ20ki1jpKIJqioriBiRkhn0qSzaUWYFdUp4lacrmy3kgZFUhI8fRe6Ml2USiWqkikqqirxXZN0JpD0hOCqUynMaBBrSVR+7e3tVKQqqExV4uKQzebIZDLK4rGmogYTj65MmkLpQGs6ZS+2H3L6QiOgEdAI9EfgIMjHANcGx6Gqvoqxo4cRj8bo3LqBISNGcPTY0TQ3t5BL72TqhDpqqmIYE+JsH1lLPJVQlmCBaqavA/JFbccTtLa18dBDj/PqqyvI5w1mzJjMxRe9h7bdrSz6632s27Ceyy+/lL8ueph7772fiRMnsnnzDs4//3zGjRvJonvvZdrUI2lubcaMGjglj67OLgpOERODUqGHI2YcwVVXXc2atWtYtXIVl11+Jdu3beKV1WsYfvJwbM8+IPnIt30Ej+ENNazvrKSyogcXi63bW8j3dDBk6BDGjhtNrrubV1ev5eWXV5JOZzjp5HcQjRoUi9n+BCTei1yLYcOG89vf/pYTT1zIO49/lwLnxt/cyMpVq/nIFZdhRWN0tHax+OlnSXd2cvS8eYwcM4IEEZa+sIzmxhbmzJnBuEnj2LVrF08tfo6KWJw5x84hEU+wZf1GXl23jlg8yqwZRzJx4lhaWzpZ8tJidre2YVtxJowZzYy5M2lpauPeRQ8RjUeZPn0KkydPpLu9m8ceWULJKXDCSQuJFqPKA0bfW9RnGgGNgEbg4BEYPPnINp2ISbFUwunqpru7B6PKxIzG8EslOtrStHa5WJEhZIuQay+Rc2xKhYJSuRklI9idWtZHWezPZNNMGDWWM889m6OOmoPvx1i06G5++tNf8tOfXE9PJs3adZt48uln6OloY0jdeM488xw2b97K4sVLGDpkGP/6ic9w6513EItESURTKraQFTUxLAsiltqTkoonGDFiDJbrcfH5F/H0Y4/xvssuYdiI4XglD0eJZGWdG+DUF1ffTpqGujyZrFi6maQSEWxiah+QrEm1trcTj5gsnD+HH/zs57R0NnPO2WcptZpY3/VL4kfPKTFx4hReeGEV8+ctYM2qNUpCHDFiBLg+Le2t3P/QQyx95hmKnsOaDZv56JUfYNuWHfzlr/fR0tpCZ1srC4vH8/Iry3n4oSXU11STy2U5/4ILWLxrO3+6625llXfyO3dxxmkns2btev6y6H4cJ8fu3V0Mq6vjZz/9EXf86W6WvfyyUvMdffTRnHnqqWzftJW7H3iAaDxOW1cL57/7/EB67TcQfaER0AhoBA4OgYMiHzGVdh2Xro4OmpqaKBQLxKwYO3c1sb2xCawInpsnnY1jmCadjVvY1rSdhoahGPbAKhkvXwLTpzZVxfC6GkwriuOW2LmziYhhE7WjnH3OOfyf//NFNq1fQynn0LhrN0OGDGXevFnceOMNfOIjV1EZT2EaFh3NrSxfsZydO5tJJiM4Xh7HqKbouKTbOsgUsyLCMG3mTG6+7Y986EPvY9iQEViehXeABXNlFW7FaGzPc9SRESqrhilV1/Ch9XT1VNHd1UNFRQpz1CimTpvGHTf/kenTJvOLX/yCGdOncuzcGbR0dfVJPzYYtk9zczNf+coX+Z//uZ4zzjyJm269iaPnH082k6Otq4dXl7/KI489zqwjp3PUvKP5xS9+zbHHzGbL1p3U19dx5pknkW7pZumLS8mlc5x4wnxGDh3F2o0SxryL+vohnH3KaTS2NbFsxcus27CJisoq3nXSCbznwktYvPgxrv/hT1i/aQP33/8gn7j6X9i8eROrV6/FKeWpSCVZcNxRTJs2lT//+a+cd/55mnwO7v8xXVojoBEYAIFBGxyI5ZZMzq7l0jCsgSlTpjB27Fiy+QyYBkfPO5ppY0dSkXAwLYOahEE8GaW2bjiJZDW+sffCu9RYwrcsfAsyxQyZ7gLZ7i5s16QiFcfGZ8YR0zG9Iovuupt77lvE2rXr2L5tO/fffzdtbc2MmzCFB594nNkzp1FdW8vPfvUrtR4kai6xpstlfSZMHMf4CcN54NFFtO1u44F7HqCYFbcwLlu2blP+2w5kmRbi5psWBTeGZdmIVVpXVxftHR20tbZRKhXJ53Ps2rmTQqnEpIlTOe+SjzJ+3DhM08JVVnC9NQkUwsWy7cnzyOUynHnm6SxZ/BwNdQ1MGD+KQrEbOyq8bCq15Gtr16i1IVmviUSjXP2Rj1BdVcUrr6xlxlEzuOySy5i/cD6dzR30ZDJcdeWH2fzaeu75y30se/VVJT22t2fxvJLag1WXrGHS6AZq66qVzUDJLbFt6zaee+5FNm3aRiqVZOH8hZx51rl0dWVZs2YT11zzOcziwB8RIUb6qBHQCGgEBoPAoCUfZaGFiemZtLW3sXmzTNoWjbtlUb+G1cuWsbOpSckORtdq2kzI5wt4Hmqi3rszMoWJ77gJk8YQiRvUDakjT4mo4zF64miOKh5FptDDmeeegXcf/Onue5k9ZzZHHj2befOO4tlnn+XXP/81s2bO5otf/Xd27drI6ae/i0ceWcx73/s+aioq6O5uoyef4bR3nszUyZO4Z9E9nHf++byv9D5uvOlW3v/+C1l4/EKKmSIlY3CuYcSZkHCHkE9lZaWamHM5sXCzSKUqqa2tpbOzk2ENVcQKBqlUSrktKttb2w8KwzDZvn0H1157LaeffiZf/tJnmTh6Ig89+CBM9XEslzlz5vChD1/OCQvmc9vtdzFq6CgefOQBZs+ZzsqVK1l01yIWzF+AFYkw5YgjWPrMs1TWVrBp0wY8w+Tn//tT1q59ldtuu53mHU0YxGjLZNjR3ERPS48YA+LmHOYeNZfvfve/aWvbzZYNW+lq7aSxcTtHHX0UDz30CH/4w+184uorUW4q+o1CX2gENAIagYNDYNDkI6xiepZaV1mx8lX+es8DpNPtpKIpTNukO9ut9teISxtJYkElEkJLczMVFXP71E29/QvWe7JMnTaVWdNnKfPiXD5H3jBYcOw8Tph/DFsbm7Btm4svfg/vv+xS3LyLky+ye9duJk2axA9++gO1B2b79g3KoOHU007i7DNOxyv4OLKh1faVm598Ic/I0SP5zGc+Q3dPtyKxn/9sPqVsSe3zKbe+ez341He/LxKLr6SdXEn25PSQiLjKmizd1kNHyabYvp1sNsP27dspFkuh+7egeqlEuE6szy1xLxSntbWRs88+i9r6WjpyXWDElMuaGVOmMX7CKG668SZuufkmclmHT37qanJFl8f+/Gdl1j1+3ATyvs+2jRtYufIFYrEk6a4sC+cv4Lbtf+YLn/48bZ0dtDW3cMbZpzB63BQef+IJXn3lJRobdxOLRZk2dSyTJo3lmmuuoVjMM2bMRObPPYptW7ewbOVrRFwfr6Kin6Xi62Gl72sENAIagf0hMGjyke/9olWgamg1M6dNYWhFgnwhp7waWPGYcptTzBXwI+JENEaJovIFV3KKjBjXILM1/gD+2sQcuNwlv1jAZfN51V8hKImtIybX+6RiQHDl+dlMlmx5hgRj7U1ChvKTFMbrCe8N9mibLnF/F48/l2LMkG3kSoHBhFPoIlU7HKdYZEfLToySqLYM1ry2ieHDhysJSXzdhUmp+AzIdee44vJLqa6tprOzgw++71IKfoHOjiyXX3QxlUPqSVXFufCMM3jq+RdUqIfT33+6skI7YsY0KiJRdjS3cPLJ72DylMns2LCDmGkSTSU44/STlNl0CYennlzKiPFjGV5Tx3EnzieWiKnNurLeJAYenR2vMXLUBD78oQ/w17/eR3WqhmPnH8WsubPobu0mZsTJOGkuOf9SnMJeRhPhoPRRI6AR0AgcBAKDJh+pU/YzRm2bKZPHMWXGOAzlsaBvUu37LA4XNcT7s6EkloJbOOCO/4Po89+tqO9bdDsj2LxuJffeuYhsLq/CT4wePVqtL1XG40rSi8ZiNO7eTdERiUeMNBzodRMUdl6s63pKPcydNxfLsci7ebrz3ep2Mmkze84sxKVQa0cH1cOHctEl7w3WiAoe2XQW13c54bQTsQwLN+fS2tJKVU0VF15yvpKoZCNtc7GZKZOmMPOImWptqTpZzep1q/nlr37Jc8+9TEVFJUPqhnDNF79AU3szQ4cO5dOf+oSSIt2CR2dbp9oMe86F58hrJCPrZGqpKlz3CdwTBetlYV44Qn3UCGgENAL7R+CgyEeqEaODvJM/aIunwSzo77+bf/s7QhqG7yspyTUc5UIn4jnMH++THzeUedPfh0GBWDRBR2eaJ554gl2NjeQzGVzfJ9PTo9ZgxCpQJETHEiluX0/dIq2J2m/vqVsMACRJfsF1lcQh3rZlbUo2w0p+uidNlChFQzZ+iiavhNkdhHiTcpJXzBUVOUldzflm5Zbooosu4swzz1AqyYpYBdOnTFeWcp74qSuIGUgJ1wjaEFnR7XFRtRmB1GNgBn7n8gUllebyWVw38KDkulJSWtZJI6AR0AjsH4EByMfHj0fxk4mBgpjuv6Z/gjui8jMSCdxEmrTvkfc8bHG/Y3tYQhzAENnvZMAwy8BSYSYkvpHL+COnU8p7mJ4DEVv5gfMjdiBxVCZxI1Hi9RKG780kn4i02a8Kn/g+k7140wsJoEwy9VHh0etHjVWm8FKNSLNuwcEi1vtMWRtiX57LKVYJep5SLQu5xIwI1RW1iNQ3bOgQUhVJTMvEFdKW53TSCGgENAIHQGBf8olEiDy0mOSa12Q1/ACP/vPdkmk6GYlQ093F3NfWIvRS/9gTROyIIhEZsQJMJJVeBggVjKPFlFo20kqBsrlXWZIVPeWW53CQCKR70URiTwA8tcaWyw4srZRK2GecijF0iFqzC9+4DM/GYNjo0cxfuEBtoE0lUmoP2D4bacOH9FEjoBHQCJQhsA/5+Ik48RtvpeaBhzDigaflsvL/9KcyGQ83DD4cC771s89e809nWSxjLE/7k1TMXIZ1P/w+2VkzlRFF+TNSg2mBkTCULzkv72F4A+gPyx/S5xoBjYBGoBeBfchH6WGSCWVWa8RjxAtFLNtWcXVcz+tvMvwWwCjzom1bat+MWKf9vTQ44vZGUjTaX8n1Fgz58KpS1rkiUbxohFgyyYOLF7P5lZXYsmFr7yQikAjHcmuA23sX19caAY2ARiBEYF/yCe+I9sj3ueeUE1izdStHzpxJXV3dHnPlsmKH7FS+wGVfj8TwaW5p5vjjjiefz6s1hL2/1g9Zo7qi/gjE44xfvpIRy1epvUzDR46kMHwY5t5+6cKnQiGqTNUY3tJHjYBGQCOwPwRel3xemziOlZbPe798DaNHi9uXLJFIUpaq91fnG86XNREJj/DcDTeoUAqf//Y36eruUNKPZYkarLfNsGmZ8ORciUdhZpj3hrsx8IOqnYFvHfa5g+27RGGtqcb8+n/jPveCCjBx4YUX4s+fBwUdofSwf8+6gxqBfyAEDkg+Mo6I41JpRRiSSuKl28m3t1M03xryiUVjbNu+jTXLlzFyxEiqIhEKTomO5iZMK7GHfCQMjfCN7BmNRFChpjGC2DRiIyFOFvbaVvOmX4ksAYmD7n/EJBiJKfRAmrPy8Qh2bk87Vls7KdPCcxwV8TVSVV1eTJ9rBDQCGoE3jcDrko+04PseTsnBLPlk0wViscH5QTvY3llGnIKY9hb7zHWdbJFcNkc0Gn55R3BLEjFTonhGcUtFXMuGgnhBiOAaUs4mcChwqHbjR/FKJTxfwogLZGFfDnaEf4/yNvmsj7g9MgxZoBEGLZMSy7rkGBZFzyCp9iOV3dCnGgGNgEbgECMwKPIJ2zQN8UNmYlkyCYe5EdmSiIUlWw9fZ+XZQnbLGMi+kn2TaRrK0MBSIU+D+2qzp2GoNsUDdENDA3fc8WeaOzuprk3y0osv8OPrfkzjrm0qAurDDz9EdVU1p59zBq5bUMHv+loS6UiIc0/n+26psxCOctKKQszkppt+z7iR4znh5Hdge2IFKC6ApLzo/srL71Ul0qaQlfi8k1EPTNxSIkJUYqXuXcFe1yHeNuYBxhLQs00ykuDnv/kNw4cO5eIL30Ox5CEbQfuSeCuPINtIZcOqvAPBfH8I9T2nzzQCGgGNwBtHYNAhFfqakEdCCzAbBx/ZUy9BqD01Gcv9QAUWTLhyLlOZlAma85GooVLHQBTU15KcybQu07sQT33dCO64+688+vQzHDdvHrWJGm659S4+88UvMX7CFByvwOpNG9nRtAPxFi3xhyK2jYQhEEMG8ZsmWyglvmnYR9uOYkUrkA2hhjgjFXo0oniRGHYkop6L4fPq6o1s272bVCSiJAhfiMLw1FYoIWRZB4tG48pRqGUl8ZRuME7BL2HbSaUKtG1f7YlRk3sve0t/XDtK1Ijj2T7RaIXqu9w2jLhqPxpNgBXHEYnONIhHE5hREwllIeOKqD6ZiFGGYdhYkSS29EVUZ3aJ0991As+/+BJ3/PlPynpPnJkGyVR4iKsfExvxA9dvk1L/V6GvNAIaAY3AIUMgnIUOokKxqZUv54A45NtfXO7YCBEJFUlO+GUt5/IlbyiXMEEwgqApecZTdQi1yG/gJDWEX+GxeIy2pibloLRhTIOSwmTybW1tpadQAs8kJlToR4gY4owmQslxyOY9iiWL6mQF+EUk9qhhlBRZlDyDbCGL71gYkQTRSAIrbqkhpIsOhjgTTSQRc4e4aZH3PUxbRiokZeO4EQwzguf7FEpS3lZt+vki0UiEilgEDId4PIXr2RRFfSnEFLGVCs81pUu+8hZuuRGyuR5MM4FhJigUSsrBQEbGZqK8TwupZot5irkMtipnkcl6ygu2JeMjgkRULeTFbY+BbcYYOWY0lufQ1tKC5wnph69dtooKpQUhxOXYh/bA70PnagQ0AhqBQ4FAOAu9gboCKUEkHvH1JUc1qSvVWyj59KmjRCknCjchEvmZ6o8QmVzJhDgwAZV/i0sJcd/iGw5+wSdXyDH7yCP56BVXcM45ZzFtxmQVWsAzoaq2iudeWMYHr/wkp551Dl//xjfIFkWtl6AonsqsBK0d3fzntV/jvPdczNWf/BQvP7+cRCrJhjUbufKqq3n3uRfx1a9+nUzRwI/FlAT1wQ9dzTNLlzO0eggbN2/li//+b9x0681c+YlP8q4z3s0Pf34j3/nB9Zx/yRU89sRiIhWVXPWvX+LGm27hm9/+Hld85BOsWvkayYoqPAzGNozmo1d/gseffJKvfeubnHX+xSxevJjahgY2btrAV/7z/+PcC97L9677AbYNP//fX/Cuk0/n5NPP44477uT71/+Y93/kIzyx+ElSqTqeee5ZLv3QB7nwog/w6xt/SzQi0WAjEDX6OGfP2y6pjwV5d6I2FULd33vY84g+0QhoBDQChwAB+dR9U8lWk5ZIPkIuIvFIlaFZmEhHwe5DkXMCygmasxRJCfcJpUj5gcmn/Fu8j6YCqUvUROIOp76+Xu1JWbtxA7XJBMPqqlnyxKPcdc+f+OQnPs7ZZ57DfY88whc//zl+c8MNmBmTTLGHX/zyF4wbNZ7vfOfbvLxsBUufep6uTDsPP7GEa7/5TcYMq+e22/7If/3HfxCPByqwQj6HJeM0XCwzSrorTbojy6Sx47nmC9fw8KOPkkoluOeee7jk0kuYOH4C7a1t/O722/if732Xc9Jp/njrH5UftWOPnY9s3JWgdF/+96/y6//9Gf/+hc/xla/+Bz3FAh9633uVKq0n3cNd9y3iVzfezNr1G/nsZ67iyg98iKuv/jQnnXYaX/+vM3nogYd4+vnnlUR06UUXcty8+fz2ttu47sc/4Yuf/lelgtv3RfvqnclHg4NHFJviHjlz38PZvBIAABxaSURBVNI6RyOgEdAIHCoE3oTkE3ahpJxdiuwTSDHlC+Z95yLpRBCHl6JsEyISyUnISijlYDlQ6hUlXoySYTB//gI+esXlfOvb36WpvZVYXGINFcgVCowYMYzh48ZRW1HB1l27lENNMdOOeB49HRmSVVUMrx3CO+bP5/Of+QwVldW0NDUzpK6esWNHk6ypoa2nC1O8O0iECHyiyRixZCKIaWpZao0mlYgxaewoEhGbRMRkwriRdLa3k8mnqUpFVaiCM085Rakh8774jS6o9SKRBru7u/ncZz7J3PlzGdZQg+N5NDe38PSzL3LzHbfxp7vu4eWXV+EVXeE8aqtqGDu6gazrUJlIMLJhiDL2yBUzbNm5iwcffIzf33wLa9atZVhtFb4v1CI4D5SEgBxl6uCr9zHwR8BAT+o8jYBGQCPwRhE42Fl/gHZElSYkEk5a4VGKlp/L9CcTYJgXHsNy5dcDNNObJZN1WIfvF1XMnERNkpPetZAXlq3iz/f8hZNPPoWoHVdrLu3tbbQ37aa7q4tUNIZlCukZioSSiQSFTIbmpt3sbm4hVyjhOxC3bXLpdnbuiJDr7qGqqkLF5JGYOxLDyM37tLd389SSJ2ltbiIatejoypLJdVIqFlQcnkJ3t1pzEQ/YRTzGjh+JFzVpkXwrgimeSXvhkLAK9SPq8UvQ2t4lPn3YsX07T2WyTJk8jfdechHX//AnWBELCXvQlcvS3tmlXFKXiiVyXTkct6Q0axPGj+GE49/B3DlH8vKylxk6pJ5MKY/fGyKhz0qxHGN5M6HUWp6vzzUCGgGNwFuDwCEgH+mYrNmINBOo2AbuaqhiC7/Ay8uWk9fAT0uuWIkVSyWliorHLOKWhW1ZFLM9ytrsmGPm8Ojjj5NPZxk5ey7TJk/jhRdXsnnDDjra2zjp5BMoFkp4nviMizJn7lzWrt/Azbfeya7WRupq6jn+6GOYPG0qf7nnr6SiSdo6Oliw4DiWLn0Jy7I495yzWLZyGRvWb2TF2tVEogbRaAxDDAg88UknWJRwPZNURYWiypgZJ9+TwStkiRrKoFk543Q9oVJDGRLk0wUoFVVYbNv3qauuYuS4kWzbsp2Vy5bRsns3Y0Y1qKB1Qo7iw1OC1vmWRPgD0zEZ3TCa+mH1NDfuZJnlsm3TTqpSFaRiUfAsCq5Y2w202VQIvVzBuf93oO9oBDQCGoFDgcDBkY+onQb8dA6JJySWgbomZcqlm73LyvXeeeVZcq+kFtBdx6SxtYkRw0Zy0jtOoLO1C88rcey8Y/nyFz5PfW0to0aM4JzTz2LR/ffx8qqVzJp+BJd/8GK6C1lMr4Bl2px22jspGS4rX15BZV0N71hwPDOmTyeeTPGHO2+lOd/EnDlHc8E5pyliHd8whiNmTufGW37LzuZmLr/kEnbv2kVNTT2jx4whEY8zZ+4MvKJPJpPhveeeS3VVDae+850MrRlGujPL+NHjOPH446mvraFYTCuru7POOZsJYydSKrnKc8MpJ76T6TOmM3zkcHbvupuHH3mEmrpqph0xlbrqWsaPGkM2XeT0d53EuMnjqEhUMOuY2UycMIGqVBW3/vFWXlmzjqOPPooTjj+e9vZOikUXO27ji8GGeod7Yx18DAz4egd6nTpPI6AR0Ai8CQQM3/f9ztZWnnryKfJenlMuuBD7Ax8n+9CjWNEIP/nAxaxt3MW3vvkNElGDrpZWTCu0ZgtblomsnFjC/L2PBy4ni/qbN2/jhl/9juHjhnPdddfRsm0zLa3NSqKQhfnN27dw6x13U1tXy2UXvpdEwsRxZI+LS8SOqXWUQjGPaViYMZN8Lkc+55KI21RVJOjOljDVHhpxzRMlV8jjFPMYZpyUBNDrtcnrzqTVYryo5mSfTcHJ4pUiJBIxujMdeK5NdWUlrltEYtjI3hmZ1H3TxROzbUx8z1OShuOaap+SYYulXmB9bpiyJ0fWW8D1ZeOuo+oUxCxLVIMxdb9UypEvlojGLMxoBMs3lPcG35VVNAcZjCd7e8Tq0Igp4TOXz+A6RZLVFVRX1nH7Hbez4pU1nHf+WRx1xAwKeWeAjwhfjcGJx4n84BdU/uFWvJJD/ZKHiBwzb+8Xqa81AhoBjcCbQuCgJB/Tk02JNpYin/DLWQwNxPpMJkyp7kAkJGUkBdZqvRe9hyK2Zasd9qLFC9aHZG9lED1TwizkcmmmTprMReeey87WXUSjntqUKWo0saRTk78vqiULxzHwHYPKVIqaiiiu65HLdxMxxTtB0EfX8ZEgaJGqSjzXpVAs4XsuhhmjvrYSU+3jyVEoOMSiNq7hUSwWqElVgBGnWMwFm0yjQdwjaSNiRvEjgYPUaDyG42SIx5OKoGSjrJCOFXfwPAvPD+w9khEfz4vhqD1RUaKRKI4r7oN8KpJVVFVKfwsUSwbiIUd8tDmibZPQB66HK0YQlpCwhW941FZXY1o+pZJBLpOnYXgDF0yewOxps/DcHKY50HuScBmyX0gMKCRca/+3o680AhoBjcChRGBQ5BOLxcnnfVZvWMHWDRtJVFarjZHBJB5M/AH5BOsdfft25J5ISaLSEeKRyTac1eRc8oSIgnwjblIoFDDtYE+QDHTrtq0seWQJFTW1+Jan3O9IbBnPtVj83Ev4BTPwKSrLRnsEsj4JK1AxBfKMMlcbgBz3lNnjHVtUU9Jn8YfWW5dcq/tCBEIMwRpUMJ4DEG5RWGLv+6EKsje/4IF4LCgNVDZUdYqkJGWKQRS3faLMBv0N/nEE/cMVQpHnoqTTXTzW/FRvRNay/sjwlK2Bq7yPliqrmNXcxAxZS9tfGIVD+S9Q16UR0Ai8LRF4XfKJGTF27tzBZz/7SbLZTKA+6vdlHE70ex8FzzCv/FzyJMkEWH4/yBIiyOVynHfeeTzzzDN87nOfo0JJGgYS4E1c5biui++JK5ooxVJRuZhxHRfLtlS8IfF6EPonE9WXGArIT4LTyb2ShIeORCgVZYHfxLQsNS7TMCiVHOWCRqQUuec4LhHlesfY87y0H9Ynrm3UKAxDSU9yLxYTiUdUcRZiyZaqSClSlWupU8Yo/ZN+qPH09l2elfqEgOV+eB6OR1ArForYkeC1hWOR+hQWEnzPNJURhvRf6pMUSJQmJVckLo+Y4KYC9YnPPEvVmUwl1TqVk0xw5c5m5kQjFP9R3XirUeu/NAIagcMZgdclH/GHlkol+ddPfYxRQ0dTkDgGb2ESSopEI3hRg9//7naqkkmOWzCfZatWccT0ubzyyisceeSRtEtoh2KRs846S60Nffazn+UnP/kJF1xwAS+99BLjxo2jpaWFmpoaFRZg/fr1XH755Xz961/ny1/+MjfddBMLFy5UZcQ4YOTIkTQ2NjJ//nyWLl3KggUL+Mtf/sKpp57KqlWrFGlMmzaNBx98kCuvvJJFixaptoQgR40aRVNTk9qIWl1dzbJly7jiiiu49tpruf7661W/Tj75ZBWjSEhJnKNu27aNmTNncv/99/PpT3+a733ve3znO9/hhhtuYO7cuYqAd+3apcps2LCBqVOnsmLFCs6/4HzlAeGUU05Rx1QqRV3dCLZsWcuMGTPYvXu36uvQoUMVuSWTSTo6OhSRSR8njZ7Iuq3rGTVypNrcunzFCq666uP89sYbueJ97+OGP/+JI444AueJp97Ct6yr1ghoBN7uCAzK4GDF5o189+tfZdrs+cHXtNI5BdCF8kuvlqpXqfW6nDYg7qYB+UKJW26+maefWcK1136dnTuaGVpbh1eS/TPiS1MW3H3xqakkDt+OKPWQfMHLV70cS0oaEhWgJHG+KVJPQansRBoIpYRAtRZIKCKRyPMibYhEItdSVqQLIQyRLuSenId5Uo9cSxJIxGjAdQ21JhO2IWXDekLJK5R61IOiLeyV5qTvUl8o8SjprVdKknthkr6EZeVcfuVlpe/heOSZ8NxSG2UFu8DNkeDomSZJGauEzxYlaG0Nldf/DO+nv8R3XW1wEIKujxoBjcAhRWBwLKFMrGVJwGXz+vUU8j0YMUvN/rInxRVS8CywfFy1nLBxwD0/0pi6XbYKVD6auBlj844WFj9yD8naGEue+DWvvPwqX/63T9Pa2aP2toQ7imR7S8kAyysQj0cpFIpItFPLEpIIKVGIwFeB1GzbUCEWpKws2AdzubjMmYFpeoo8HEdUVYEKK1B7Bb2TdRPPy6lJXib9kAhC4pHJXcp7nkz6gcGD5CUSCSWdiRVfSCryrNwLSSkkD8kTdZsQUUiC5diE50KMUkdIQGH+QEepR9apJAS2JRH2bFsRttCYyK+CUlw5RBXP27Za8zE9X5G5Hb6ogSrWeRoBjYBG4E0iMCjykTUNpf6Xr+xSAackUkQ0+NxXHsFsDFO8A7h4vuwl+Sggwd36kpgUhA54JFe+svee39x4b8RNG2Rf5KTJd+KUIJ2+E6cQrPcrpZ8PjvTch7wJEj8ukQgim4ogIlJI+JO2ZIlK5laZi2Ucym5AdW0EpdKP8MTCzXAxzbwq43lx/F5LtGAEsjF1gZJqYjHxRh1EShWLNbGskyTkIhZ2QkJiHWfbwXqL1FMqCblFFWFILB0xC7ftCK4rUlVQLmgnfoBoqYKWjN5V5BSUH9zfgnvMdff4sg4Vp/Jew3MhNUlqXW1w1epSGgGNgEbgDSMwKPLpX7vsL4kREw9toraRj+sIPProEubMmcuQhuHKTUz/Z4KrcvOCUClWXk7CFshPJR+62qG5JQiLHWbLUXghkhJLOHj44YBYZs2Co4+GZ56BFSsgHkeFI5g0CU46Cdrb4b77AlKaOROOPx66uxt5/vlLWLcO6uvhrLMC8nvkkaC8eAOQJHXPmfN9hNgcJ8rixY3Mnl3JkCEJHCfBtm0ZduxoY/bsaurrEzz99E7WretQJCWkCAlOOmmU8oTw+ONbaG7uZvr0YRx11BASCZ+CWLu9bhJyOAqY2Wue9roPvIEC8oYqe80G5VwnjYBGQCPw1iDwBshHJnBHqY4sM8Lip5awccNm7vzTn/n+dd9jxLgRFMpFnL36faApTe71ux/ES+tfgw/xSti0GRYtgqamQJLp7BQJCV5+GZYtg9mzoasL6upg2zZ48knYvj0gl5aW4CgS0NKlkM9DYyNUVAQkJIQ2bhykUtDTAzU1Ut+/UVUFt90Gt9wC3/pWUPef/gTLlwcBU6dPl5g7AXFt2RKQphDYK6/A2LFBXS+9FKj8pN8iQR13XHDda5jWf6z7XJ0EvLPMa/g+BQ5BhuxZejn4DDBEDXknFkvV+s/+KxdJ+CQM45j9F9F3NAIaAY1AGQJviHyC50XFBLlikUwuR0t7hwqiFgaC7kciZQ0O9lS216RiUFmJMjQInxOjg/ohcPsd8OqrAQmI9LVjR3At0smcOXDppYEabvz4QDp64QX4ylcC9dyDD8Jdd8Fll8HChYHE9NRTAUEJaUk6/fSAMDKZgJRkyUTqvueegKiEOGTdSIiroyNQw4nmSowBjzkmkJaSSbj1VjjySKiuDsjmootASOr3v4cnnoAjjoDa2oAMwzHu//gEIL+3OtUC8pN+/UB54FY60wM0a9vfwrI0+RwAIn1LI6ARKEPgDZFPsLju4HiwcMGJnHHyGTz02GO4BVd9zZfV/4ZPxQ1NOh9IC2LZVp4kCrRIOUI6w4cHajdRm40ZA9dfb7JunewJctW9iRPFjU4w8UtZkWLkWqSiY48NyEMmf3leCEbUdc3NcMcdMGIETJkCF1wQPP+73wkhmWzdGiGfFxN0eP/7YcgQEEIT6UUISKQtIR6RpNavh099KiAZkaLkGVl/CtRxQb3lY9PnGgGNgEbg7YDAGyKfABiRbRyqK5PU1w8lYstmyzcr7/RBLjUNGwESDbp8TV54qOQEZCHqtSs+2AB+gVNP7eRjH5PJ3FcTv5DGhg3w858HaznveAf8y79EMM0KmptLzJqVVuQgUsv3v2+zbp3Nxz6WV5KWEMPkyQFRiHQl0s9HPgKLF8MHPmCxbFkdhtGoiFYkMyEbSUJe8hOSERXdf/5nQDqiwhMpUepdvRpuuEE2ecKHP1xUz4pEpZNGQCOgEXg7IfAmyEcm1MDXmWzSlIicB0pi0yWEEgoxfbtW+p6S+2EMVMldsTzGCy9EOe64HrLZvnJSh6i7Ro6Ej32wi7a0y9YtIvXA5z/v09XlM28e/OEPgURy9tlw4YUiobi4boalSz1kjSi0fDvvPJeXXvJ59NFAXXfttTBhQiDFiAT04ouBOk0I7NhjHYYObQ98upkBMUk9ooYLk5yLNHXPPfVce22bknREUhM1nUhYl1/u8OyzAREJyYmU9DrwhVW/5cfAqEIHWHjLgdYNaATe5gi8QfIR6uj1x2YErmxCUtkfnvJEaIcQztPlBCQmv2LpJu7ZFEkZcM67i8w8wqG7vdw8OmCwdAZGj4Z3n5+nvQVuudNmyZIK/vu/O5WBgUggYZKJXVRy553nkcsVlcpuyZJg0pe1mBNOEKs9V1nOyTMLFgRGA6JGi/ZalG/cCA88EOXXvy7S3FxQ0tB11wXrN0I2ItmIyk3aEknokktG8PGPtyoLPLkvP6lLVHmjRnmsWQNSp7QhpHRYSD8+2DGw5EWELykEUR81AhoBjcAhRKBsit5/rQGxeJRK6V7ZReQYFwdX/Xk94pGaQ8lHzqW8yEnlslJoei0kpLwX+HDbrT4//JFLdf0Ak6EvptKQLUAhL5O+SVdXkm98A371qz4VWEODmIHDVVcFBBBalYkq7Wtfgx//OJj4hRxkTWjlSrj6ahCLOFmbCSWu//t/xSChyM03R5gwYTif/WxgEScSlBCPPC/l5VzWddat86ivd9S1kItY3H3604Hxg6w7ieQmBCmkc7hIPfJinCK48hIG81L3/09G39EIaAQ0AgdEYNCST/D1Xv45LMEVgmu5F4lGlfm1qM3KS4Wth1JOeE9Yr5z5wvlOST69ksR55wUm00IyYRLHzo1b4JOfCKQI2YMjoQVOP6PI/fc3qjWV666L0dBgMn9+ji9+EURdJnt3TjxRDBWinHJKUZlM79oF3/mOzZQpMaZPzyAEI/t/xCz7yivFjLuSc8/N8N3vBjQphgpDh5YYM6ZJmVTLuEPpSNZ45FqIRIhl0iSJQRTsg5J8MXz4+Mfhpz+FL32pgtNP9/nc5zIMHRqUD8f3dz0KgUa15PN3fQe6cY3A2wSBQfl2W75pI1/99y8wZ9YcdmzaRj7fhYRZkMV9SWL91pHJUBGLYSudjexH6e/h4PXwFNKKxWHz5sAMub4WTjoBlq2GT34M2trodd0T1CQqLFFzyeK+JFk3EYkilwt+IrHIAr9IISJhhGWFHORZIYuQKEQKkjyxTgtVYFKvSCVh2XB9KJSGJL93+HtUbrLHR/KkTFhnWEb6IOQl+eV9O6wkH/HtVgNVP64l/staPBcqH96JvVDEywDn/f0dmFp/dX+3db5GQCOgEeiHwOtKPq5lUhL/YLEYZjyOXRHBMJKY0fge6zahoOFV1crFjKi/3kgSX2J2PPBcUDLBNWHoKBiehrS4s4kGKq2w7oIPsRSMrA8mfJE2OrMBeVQNgfpIYBWXy4IrJBKHhpqgDiGSXD44T9ZCbUNgUSfEVSiJFBe0LUQkZaVuX8im17dARX2fWbX0x7KhojIoK/uQxNddSrbJGEGelJE8eb5yr76JSzwVgy8c2N/xKP0Tr0kqxJJc6KQR0AhoBN4iBA5MPobBqKZmcj1p6l5bj5czyGx+jUx3lqL41ClLafnElwUPNXPJjCqz2OAXDgyZ3KMQbYep7VDtQGwl1G6FSB3Ec2WN9Z7K/JgLJ0kDgniiQWw0icsmzUsv5SeX+bKyoRsfWYvK9uZbQoC9ZYXcVDLKYtT1ZokSTkYW1iFFpZ5yRMLHwzK9jyqjC4lCGvYtzD9cjmaFh7k7cBKrPLkeLh3T/dAIaAT+qRA4IPl4hsFl9z6ivCjnr7qGTtdlmBWEWQ4n14HRkM/+3s0vAxcYONeHYSbM7lVple6FyaIy+xkEwbQHfkznHkIEZN0q5uMnxbne4D8eDmEPdFUaAY3A2wCBfclHpJdcHiOTwehd9BCiUWRjgCsLAa+bul63xH4LeP3Njl1D3PiYyompEjdCCauX/QJvC+KRWsIM9Ia6lnsyb+4pKxkVGIaUCQQ0OaqkyoXl+46hBVtQT/+y+9zbuw6pxgjWlGStZzBtyfrT65UN+y4vI2yy3xh6u3nAQ/mDveeqrypWUu97Loq+0ICs6D+lkE4aAY2ARuDQIrAP+RiFAsULzyY9cRR2PM7zK1erqKES0bOmtnaPkcGh7cbAtQmxZLNZ9QtDU0u8G3H/L/fkl8/nqa+vV32UqJ1hwDaJPSRxbySmje/HiMV+TDq9VRkgyIZP8UwgXgZkQhcDAbFak8lf+FYMB8QoQFztiKGCrP1ICi3bcjmbRKKSfF5i/wR1yLOhGbfkSRtiACGm2GLIIG1JCg0apE2pW8rKWpMYQIhVnxhOSD3SDykr52KosHe/ZC1K7ku7Uo+UkRQSo5BZmMJ6wvHJtZTr/bZQ61oyVumztB+2bZYMjFHiyjusSR81AhoBjcChQWAf8iFfpPCed9PzzmNJJBM8+ZtbWfPaGo771FUqXPShaXbwtdieRxSfqGnhIubdBg4+hvoDCadEhW3juS4Jy6aIj4WB13sUlz9SOsJEbKeRhG0RcSApk39vN4RbwnWccO0mJhtMhYyMPpNwKWP7NlFvPbb5/2PJpC8I9kpTrgheYtUm0k4eEjEoFSAphhQeiGAmfunEJ56Qj0zyEg7IlHhEUXALkJCYRr0m3EIWQiKqrAsxA4wCxCIg4YLMSLAnSgwqxOhBkiIfN2grEFd7SUyeFcm1rKwIsbYFdgkkNqAhR+mHSEEmyBqYKSANRtjtxVIfNAIaAY3AYBDYl3xEolBqtyyG5xErFkm4Ll5o0zyYWg9hmZgp0YPCFKqAwqOQSPDJX9M7+8aUQkrKh2XC46VEe0cb6z2KScT+kkzGAyYxbLDa8LxjSEUigRqvV7Vm9D4jJCPEI1LVEDnKtXRDgr8KUUk5Ufv1Xqd6paf63rJCEspuQzoQlu1tQ8hJUkq1JSG/Pwx04fdKVsHdgGjCcyEPaVeSIqfesiFRRWWTrAM19olYxlfBkM3EvQQm7ai2VNZ+/hJJVGIN6aQR0AhoBAaHwL7kM7jn3ual6jHNyxQGiih6J/UQlL3zwmu5X35efh3mh8ewrvLjQPds+76yoNjlpQ/2XKK5jsQwpu95cKD29tzUJxoBjYBG4E0goMnnTYB3ODxqmgsPh27oPmgENAIagYNC4I3tCD2oJnRhjYBGQCOgEdAI9EdAk09/PPSVRkAjoBHQCPwNENDk8zcAWTehEdAIaAQ0Av0R0OTTHw99pRHQCGgENAJ/AwQ0+fwNQNZNaAQ0AhoBjUB/BDT59MdDX2kENAIaAY3A3wABTT5/A5B1ExoBjYBGQCPQHwG1z8f3JER2kZJXVM45xR+a6zqIf7RcLk8mk1Hn/R/VVxoBjYBGQCOgEXhjCCjySVZWMufoebi+QypViTjxjMUS2LbFe97zHjo7OxkxYsQba0E/pRHQCGgENAIagb0QUGG098rTlxoBjYBGQCOgEXhLEdBrPm8pvLpyjYBGQCOgERgIAU0+A6Gi8zQCGgGNgEbgLUVAk89bCq+uXCOgEdAIaAQGQuD/AZpDcaXcWDvIAAAAAElFTkSuQmCC)
Based on finding we have decided to delete data if you are aware SQL then execute query as below or Consult SQL DB team and do clean up .
Ran below statement to delete the entries for package: CS10000E
delete from TableChangeNotifications where Key1 = 'CS10000E'
-
But this action was taking long time to complete. Also post re-initialization none of the incoming messages were processed by the PS1 server, hence I decided to truncate the table.
-
Ran truncate to delete all the entries after stopping SMS services. truncate able TableChangeNotifications.
Based on above activity. All the space got release and environment start working as Normal.
Hope you Like this......
Happy Learning:-)
Thanks & Regards,
Haresh Hirani
Email: [email protected]
Follow me: Twitter @hirravi1
linkedin: https://www.linkedin.com/in/hiraniconfigmgr
X
0 Comments
No Comments