In this series we discussed how to monitor and keep track of the status of all related SQL Server Services. SQL Server has introduced with its imminent 2012 release, some new DMVs (Dynamic Management Views) that make this even easier.
In this tip we look at other techniques to get the SQL Server services status information for all installed services.
As a production DBA, one of the key things that must proactively be checked on a daily basis is the status of the SQL Server instances, and all of its related SQL Server Services. In editions of SQL Server 2000 and earlier, there were only two main servi
The SQL Plan Cache plays a significant role in the overall performance of your SQL Server. This tip covers how to identify what is in the plan cache.
Recently at a client assessment, the chief complaint that every time a Violation Constraint, Cannot insert duplicate key error.... occurs replication breaks and this causes significant downtime on their production environment. In this tip we cover how t
Every company wants to ensure the database integrity of their database systems. If you are not running a regular database consistency check against your databases, then your databases could have corruption without your knowledge. Therefore, it is importa
Once a SQL Server is initially configured, we would love nothing but to set it, and forget it. However, in the real world, especially with multiple SQL Server environments to manage, we need to keep track of any changes to the configuration, which coul
We have all used the command DBCC CHECKDB from time to time in our DBA careers to verify database integrity and repair corrupt databases. The latest version of this command checks the logical and physical integrity of all objects in the specified databas