Being day 16 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC INDEXDEFRAG. Description: DBCC INDEXDEFRAG was used for to defragment indexes on SQL Server 2000, the same thing can be done with Alter Index on …
Being day 12 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC FREEPROCCACHE. Description: DBCC FREEPROCCACHE is used for purge all of the parsed query plans out of memory. This is commonly used in development environments, …
Being day nine of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC DBREINDEX. Microsoft recommends avoiding the use of DBCC DBREINDEX. DBCC DBReIndex has been deprecated meaning that Microsoft has announced that DBCC DBReIndex will be going …
I am currently working on the next beta of the Database Health Reports. I you haven’t seen the program check it out at http://DatabaseHealth.SteveStedman.com. I am looking for idea of new features to add in the next beta, and I …
Working on the next beta of the Database Health Reports… Any requests? Read more »
This is intended as a brief overview of indexing on SQL Server. Understanding and using indexes can lead to some major performance improvements. Non-Clustered Indexes Non-Clustered indexes are often times considered traditional indexing – contains pointers to the data. This …
As I work on testing the Database Health Reports project, I have configured several test servers running as virtual machines using Hyper-V. Part of setting these up for testing, I usually end up installing the sample databases for SQL Server. …
Installing Sample Databases for SQL Server 2008R2 Read more »
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 …
The Waits Types page has been updated on the T-SQL Wiki. The wait type documentation works will with the Database Health Reports historic wait time monitoring (Free download). Below is a screenshot of the Historic Waits Query Advisor in the …
Today, the Database Health Reports had its 400th download. I would like to say thank you to everyone who is using the product, and an extra thank you to those who have provided me with feedback. Here is a history of the …
Over 400 downloads of the database health reports. Read more »
The Database Health Reports application provided free of charge to the SQL Server community. Enjoy! Today I released Beta 5 of the Database Health Reports. Beta 5 is mostly bug fixes and performance improvements. There was one new feature added, the Big …
Database Health Reports – Beta 5 Released Today. Read more »