SQL Server Monitoring Articles
Problem When using transactional replication to replicate data in a one way topology from a publisher to a read-only subscriber(s) there is no need to manage identity ranges. However, when using transactional replication to replicate data in a two way replication topology – between two or more servers there is a need to manage identity [...]
The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs. I will call this framework comprised of a library of modules and functions specialized to manage [...]
Introduction In an ideal world companies would have only one operating system for all servers, all of them always on the same patch level. There would be only one strategic database platform and every database administrator knows that system and the management tools that ship with it from the inside out. While this vision may [...]
This article demonstrates how to monitor the usage of the various drives attached to a Windows Server installation.
I was recently asked to set up Transactional Replication comprising of 29 publishers as well as same number of subscribers. One interesting challenge was that the size of the distribution database suddenly increased from few MB’s to around 62 GB and as a result the disk on which the production database was hosted quickly filled [...]
This article demonstrates how to monitor the processor usage on a Windows Server installation.