I released Database Health Monitor Beta version 9.2 today. No new features, just lots of bug fixing. I don’t want to make it sound like database health reports is unstable, it is very stable, however with any software there are occasionally unexpected things that cause a crash. My goal is to get Database Health monitor as close to zero crash …
The Database Health Reports project is going strong. Database Health Reports is a free application for monitoring the key metrics on your SQL Server. Created by Steve Stedman. Database Health Reports Includes Wait time monitoring. Once installed, keeps a historic record the database, query, program, user, and wait type. Real time reporting. Backup Status, Current Connections, Disk Space by Table, Identity Column …
Although clustered indexes are not required, and there are many cases where you should not use a clustered index, quite often clustered indexes can be overlooked when creating a table. This is actually more likely if you are inheriting a database from someone else who didn’t know enough about indexes. In these cases adding the right clustered index can dramatically …
Finding tables that don’t have a clustered index. Read more »