...

One day suddenly replication went to high delay with number of commands pending and i was clicked it during monitoring. I opened replication monitor and during analysis one message found which was raised for delay from publisher to distributor, The mess...

...

Recently when i was working in replication task. It was to just add new subscribers to an existing publication. Some of there added successfully but some of failed due to replication component is missing. Before you go ahead in details i would like to r...

Replication was stopped for one subscriber database due to memory issue with following error, [CODE] Error messages: There is insufficient system memory to run this query. (Source: MSSQL_REPL, Error number: MSSQL_REPL27453) [/CODE] It got resol...

...

Recently we have seen the post for database size information and script used for the same too. Hope you liked that post. Sometime we need to have details like database size for growth and disk planning as we viewed in earlier post, same way i am repeati...

...

This is common information which DBA required on daily basis for monitoring or reporting purpose. This is basic details which help us to get the database growth statistics on daily, weekly and monthly basis so we can have idea for the disk space managem...

...