From Sunil's blog to identify the top 10 queries generating most IO. SELECT TOP 10 (total_logical_reads/execution_count) AS avg_logical_reads, (total_logical_writes/execution_count) AS avg_logical_writes, (total_physical_reads/execution_count) AS avg_phys_reads, execution_count, statement_start_offset as…
Here's a TSQL script to get cumulative IO by database since last restart. WITH Agg_IO_Stats AS ( SELECT DB_NAME(database_id) AS database_name, CAST(SUM(num_of_bytes_read + num_of_bytes_written) / 1048576 / 1024.…
I was looking for a quick and easy way to get directory and file size for a given directory and its sub-directories. I came across a nice post by…
Rob van der Woude has a nice batch script to get disk usage of folders & subfolders in Windows since there isn't a built-in function. This could be…
Here's a query I found that helps show database IO consumption. SELECT DB_NAME(DB_ID('DATABASENAME')) AS [Database Name] , mf.physical_name , io_stall_read_ms , num_of_reads , CAST(io_stall_read_ms / (1.0 + num_of_reads)…
TAPEDRIVE NOTES (LINUX 2.4) -Rich (01/08/2004) Rewind tape drive: # mt -f /dev/st0 rewind Backup directory /www and /home with tar command (z - compressed): # tar -czf…
What is it? I created a small tool to help facilitate setting the default user to automatically logon to a system. Requirements Administrator Privileges .NET 2.0 or greater…
I have ImageMagick installed on a Linux system I use to host a few websites. From time to time, I need to quickly resize a photo, add a…
I come across systems all the time that are loaded down with toolbar after toolbar after toolbar. Not only is this slowing the browsing experience down, but there…
This is how I feel about Oracle. (Sorry in advance at the ugly photoshop.)
Problems installing Adobe Reader or Acrobat? Could be because an unsuccessful uninstall attempt, and interrupted installation/uninstallation, etc. Who knows! I came across a tool that worked in cleaning…
Simple little tip here to delete all files in a directory that contain a given string using findstr, for and del. for /f "delims=" %f in ('findstr /m…
Google has a Flu Trends project where you can see influenza trends across the world estimated by search queries. Here's an example from my state, Pennsylvania: Flu Information Get more…
I don't know how many times a day/week I do this to troubleshoot various issues with email systems. Good command in general to remember and use. It's really…
This is a quick howto on adding an email address to the whitelist or Safe Senders list in Hotmail at http://www.hotmail.com/. 1) On the right side of the…