MSSQL

Hints

Command Line to run SQL

sqlcmd -S HKHKLDBS126 -i ifi_rop.sql -U <<username>> -P <<password>>

Command Line to run Query

sqlcmd -S HKHKLDBS126 -q "select * from ifidata.dbo.c_rop" -U <<username>> -P <<password>>

Check worst performing CPU queries

-- Worst performing CPU bound queries
SELECT TOP 5
    st.text,
    qp.query_plan,
    qs.*
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) st
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
ORDER BY total_worker_time DESC
GO

Check recent query

SELECT TOP 100
    st.text,
    qp.query_plan,
    qs.*
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) st
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
order by qs.last_execution_time desc
GO

Setup the Schedule Backup

https://support.microsoft.com/en-us/help/930615/how-to-schedule-a-database-backup-operation-by-using-sql-server-manage