SQL Server Monitoring Articles

Manage and Monitor Identity Ranges in SQL Server Transactional Replication

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 […]

Controlling Growth of a Distribution Database

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 […]

Using PowerShell to Manage SQL Server

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 […]

dbWatch Database Monitoring Tool

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 […]

Monitoring Disk Usage in Windows Server

This article demonstrates how to monitor the usage of the various drives attached to a Windows Server installation.

Monitoring CPU Usage in Windows Server

This article demonstrates how to monitor the processor usage on a Windows Server installation.