Wait Stats MS SQL

Run the following query to see the PAGEIOLATCH wait stats for your database server

select *
from sys.dm_os_wait_stats 
where wait_type like 'PAGEIOLATCH%'
order by wait_type asc

Index Fragmentation on MS SQL

Run the following SQL query to see the fragmentation of table indexes. In this example I am checking my SolarWindsOrion database

SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level,
avg_fragmentation_in_percent,avg_page_space_used_in_percent,page_count
FROM sys.dm_db_index_physical_stats
(DB_ID(N'SolarWindsOrion'), NULL, NULL, NULL , 'SAMPLED')
ORDER BY avg_fragmentation_in_percent DESC

Allow SSH to Cisco ASA

Three commands you need to run

aaa authentication ssh console LOCAL

This first sets it to allow SSH authentication

crypto key generate rsa mod 2048 

This generates the SSH key to be used.

ssh 192.168.0.0 255.255.255.0 outside

This allows access in from the outside interface range 192.168.1.0/16