This repo provides some sql statement and ps script to handle sql server ,such as performance tunning,maintains and troubleshooting.

top10highIO.sql - Get Top 10 high I/O statements.
top10highCPU.sql - Get Top 10 high CPU statements.
top10highFrequency.sql - Get Top 10 high Frequency query statements.
top10WorstSP.sql - Get Top 10 worst stored procedure.
top10highDuration.sql - Get Top 10 high duration statements.
getIndexesInfo.sql - Get index usage statistics.
getnumberOfObject.sql - Get Number of specific objects.
getOpenTransacton.sql - Get current open transaction.
getExecutionPlans.sql - Find execution plans
getWaitTask.sql - Get current wait tasks inclued blocking session id.
getDeadlockBlockedReport.sql - Get deadlock and blocked report from xel file.
getWaitstats.sql - Get Wait statistics
getDatabaseFileSize.sql - Get database file size.
getParallelPlan.sql - Get parallel plan.
getConnection.sql - Get Connectoins.
getOldStat.sql - Get Old Statistics.
getDiskUsageOfTable.sql - Get Disk Usage Of Table
getServerInfo.sql - Get SQL Server information.
getSynonyms.sql - Get each database synonyms.
getReplicationInfo.sql - Get replicaton information.
freePROCCACHE.sql - delete specific proc cache.
generateIndexReoganize.sql - Generate alter Index with reoganize sql statements for indexes with fragmentation greater than 40%.
exportbojectofsqlserver.ps1 - Export sql script of object, such as table,trigger,view...

Provide feedback

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
ReadMe.md		ReadMe.md
exportbojectofsqlserver.ps1		exportbojectofsqlserver.ps1
freePROCCACHE.sql		freePROCCACHE.sql
generateIndexReoganize.sql		generateIndexReoganize.sql
getConnection.sql		getConnection.sql
getDatabaseFileSize.sql		getDatabaseFileSize.sql
getDeadlockBlockedReport.sql		getDeadlockBlockedReport.sql
getDiskUsageOfTable.sql		getDiskUsageOfTable.sql
getExecutionPlans.sql		getExecutionPlans.sql
getIndexesInfo.sql		getIndexesInfo.sql
getOldStat.sql		getOldStat.sql
getOpenTransacton.sql		getOpenTransacton.sql
getParallelPlan.sql		getParallelPlan.sql
getReplicationInfo.sql		getReplicationInfo.sql
getServerInfo.sql		getServerInfo.sql
getSynonyms.sql		getSynonyms.sql
getWaitTask.sql		getWaitTask.sql
getWaitstats.sql		getWaitstats.sql
getnumberOfObject.sql		getnumberOfObject.sql
top10WorstSP.sql		top10WorstSP.sql
top10highCPU.sql		top10highCPU.sql
top10highDuration.sql		top10highDuration.sql
top10highFrequency.sql		top10highFrequency.sql
top10highIO.sql		top10highIO.sql
updateStat.sql		updateStat.sql