Search Results for: performance

Disk usage monitoring with Data Collector

Today, I am jumping into Adam Machanic T-SQL Tuesday challenge with the following post. Recently, I created a build request to have a new server to move SQL Server databases.  I put together an estimate for the space needed for … Continue reading

Get index fragmentation statistics

I recently attended a Pittsburgh SQL Server user group meeting where Brent Ozar gave a presentation on the silent performance killer.  This motivated me to create a stored procedure that could leverage the DMVs in SQL 2005/2008 to gather index … Continue reading

About John

John Sterrett is the founder of a SQL Server Consulting and Remote DBA Services company in Austin, TX. We focus on stabilizing, proactive monitoring, performance tuning, and high availability with SQL Server instances.  Procure SQL was founded in 2014 and has grown from … Continue reading