Visualizing SQLIO: Disk benchmark results using a PivotChart
This is a quick video of what I was working on for a little today. I created a batch script that will benchmark a disk(s) using SQLIO and record the output to a single file (or multiple, if necessary). After benchmarking completes, I run SQLIOResults and choose the output file that was created by my [...]
SQL Performance Monitoring
I have read numerous articles all over the ‘net regarding performance counters to monitor, etc. This is a snapshot of a typical performance monitoring session I use to track down performance issues or review the system at any given point.
SQLIO Scripts and Graphs
One of probably hundreds of SQL scripts out there. This is what I made and use… and I like it. There are a lot of other scripts out there that are available and even an SQLIO GUI. Here are a few I looked at myself. SQLIOToolSet SQLIO GUI (screenshot) SQLIO.Scripts My script is a basic DOS [...]
SQL Show Jobs that Will Run
This will show jobs that will run. I lost the link I found this at. Eventually, I need to add a few columns to report scheduling information, etc. This is a nice start though. USE msdb ;WITH CTE AS (SELECT schedule_id, job_id, RIGHT(’0′+CAST(next_run_time AS VARCHAR(6)),6) AS next_run_time, next_run_date FROM sysjobschedules) SELECT A.name Job_Name, ‘Will be [...]
Check Fragmentation on Objects in SQL Database
tsql so I can remember in the future. declare @db_id int declare @object_id int set @db_id = DB_ID(‘EMR’) set @object_id = 0 select db_name(@db_id) as [database], object_id, object_name(object_id, @db_id) as object_name, index_id, avg_fragmentation_in_percent, page_count from sys.dm_db_index_physical_stats(@db_id, null, null, null, ‘LIMITED’) where page_count > 1000 and avg_fragmentation_in_percent > 35 order by avg_fragmentation_in_percent desc database object_id object_name [...]