FilesExpand file tree

develop

/

Healthy SQL

/

Copy path

Directory actions

More options

More options

Directory actions

More options

More options

Latest commit

 

History

History

History

 

 

develop

/

Healthy SQL

/

Copy path

Top

Folders and files

Name		Name	Last commit message	Last commit date
parent directory ..
ActiveXESessions_SystemHealthInfo_Ch06_ExpandingTheToolset.sql		ActiveXESessions_SystemHealthInfo_Ch06_ExpandingTheToolset.sql
AllDeadLockScripts_Ch08_Deadlocks.sql		AllDeadLockScripts_Ch08_Deadlocks.sql
CDCScripts_Ch10_ChangeDataCapture.sql		CDCScripts_Ch10_ChangeDataCapture.sql
CalculateAllSQLServerPerformanceCounterValues_Ch05_sys.dm_os_performance_countersHowtoReadCalculate .sql		CalculateAllSQLServerPerformanceCounterValues_Ch05_sys.dm_os_performance_countersHowtoReadCalculate .sql
CalculateCumulativeWaitTimesByWaitType_Chap03_SlowPerformance.sql		CalculateCumulativeWaitTimesByWaitType_Chap03_SlowPerformance.sql
CaptureCfgChangesUsingDefaultTrace_Ch10_DefaultTrace.sql		CaptureCfgChangesUsingDefaultTrace_Ch10_DefaultTrace.sql
CompareResourceWaitsVsSignalWaits_Chap03_SignalWaits.sql		CompareResourceWaitsVsSignalWaits_Chap03_SignalWaits.sql
CreateAgentAlerts_Ch08_CreateANewAlert.sql		CreateAgentAlerts_Ch08_CreateANewAlert.sql
CreateCustomDataCollectionScriptForQueryStats_Ch07_DefiningCustomDataCollection.sql		CreateCustomDataCollectionScriptForQueryStats_Ch07_DefiningCustomDataCollection.sql
CreateCustomIndexUsageCollector_Ch07_DefiningCustomDataCollection.sql		CreateCustomIndexUsageCollector_Ch07_DefiningCustomDataCollection.sql
CreateDDLTriggerForServerDatabaseEvent_Ch10_DDLTriggers.sql		CreateDDLTriggerForServerDatabaseEvent_Ch10_DDLTriggers.sql
CreateDECODE_TLOGScripts_Ch10_ReadingTheTransactionLog.sql		CreateDECODE_TLOGScripts_Ch10_ReadingTheTransactionLog.sql
CreateHistoricalWaitStatsTable_Ch07_RollingYourOwn.sql		CreateHistoricalWaitStatsTable_Ch07_RollingYourOwn.sql
CreateMonitoredWaitTypesTable_Ch07_RollingYourOwn.sql		CreateMonitoredWaitTypesTable_Ch07_RollingYourOwn.sql
CreateSQLAuditsAndServerDatabaseSpecifications_Ch10_SQLAudit.sql		CreateSQLAuditsAndServerDatabaseSpecifications_Ch10_SQLAudit.sql
CreateStoredProc_usp_DailyWaitStats_Ch07_RollingYourOwn.sql		CreateStoredProc_usp_DailyWaitStats_Ch07_RollingYourOwn.sql
DataCollectorCounterDataDetailsQuery_Ch05_DataCollector.sql		DataCollectorCounterDataDetailsQuery_Ch05_DataCollector.sql
DefaultTraceQueries&Activity_Ch05_DefaultTrace.sql		DefaultTraceQueries&Activity_Ch05_DefaultTrace.sql
DesignQueryForCustomReportWaitStats_Ch08_CreateTheDataSets.sql		DesignQueryForCustomReportWaitStats_Ch08_CreateTheDataSets.sql
DumpTopWaitsToHistoryWaitsTable_Chap03_SlowPerformance.sql		DumpTopWaitsToHistoryWaitsTable_Chap03_SlowPerformance.sql
FindDupIdx_Ch04_DuplicateIndexes.sql		FindDupIdx_Ch04_DuplicateIndexes.sql
FormatXMLoutput_sp_diagnostics_Ch06_The_sp_diagnostics_procedure_XQuery.sql		FormatXMLoutput_sp_diagnostics_Ch06_The_sp_diagnostics_procedure_XQuery.sql
GetAvgTaskCountsTotal_Chap03_RunnableTaskCount.sql		GetAvgTaskCountsTotal_Chap03_RunnableTaskCount.sql
GetBufferHitCacheRatio_Ch05_sys.dm_os_performance_countersHowtoReadCalculate .sql		GetBufferHitCacheRatio_Ch05_sys.dm_os_performance_countersHowtoReadCalculate .sql
GetFillFactorForAllIndexesOnDatabase_Chap04_FillFactor.sql		GetFillFactorForAllIndexesOnDatabase_Chap04_FillFactor.sql
GetHistoricalCPUUtilizationSQLvsOtherProcesses_Chap03_CPUBlameGame.sql		GetHistoricalCPUUtilizationSQLvsOtherProcesses_Chap03_CPUBlameGame.sql
GetIODiskLatenciesReadWrite_PaulRandal_Chap03_IOMayBeWhyYourServerIsSlow.sql		GetIODiskLatenciesReadWrite_PaulRandal_Chap03_IOMayBeWhyYourServerIsSlow.sql
GetIODiskLatencyPercentageByIOStallsByDatabase_Chap03_IOMayBeWhyYourServerIsSlow.sql		GetIODiskLatencyPercentageByIOStallsByDatabase_Chap03_IOMayBeWhyYourServerIsSlow.sql
GetIODiskUsagePercentageByDatabase_Chap03_IOMayBeWhyYourServerIsSlow.sql		GetIODiskUsagePercentageByDatabase_Chap03_IOMayBeWhyYourServerIsSlow.sql
GetIODiskUsagePercentageByDriveLetter_Chap03_IOMayBeWhyYourServerIsSlow.sql		GetIODiskUsagePercentageByDriveLetter_Chap03_IOMayBeWhyYourServerIsSlow.sql
GetIdealMemUsagePercentTotalAndTargetMemory_Chap03_FindAllCurrentlyBlockedRequests.sql		GetIdealMemUsagePercentTotalAndTargetMemory_Chap03_FindAllCurrentlyBlockedRequests.sql
GetIdealMemUsagePercentTotalAndTargetMemory_Chap03_MemoryPressure.sql		GetIdealMemUsagePercentTotalAndTargetMemory_Chap03_MemoryPressure.sql
GetIndexUsageSimple_Chap04_CommonIndexIssues_IndexUsage.sql		GetIndexUsageSimple_Chap04_CommonIndexIssues_IndexUsage.sql
GetMissingIdxCreate_Chap04_MissingIndexes.sql		GetMissingIdxCreate_Chap04_MissingIndexes.sql
GetPendingIORequests_Chap03_IOMayBeWhyYourServerIsSlow.sql		GetPendingIORequests_Chap03_IOMayBeWhyYourServerIsSlow.sql
GetPendingMemoryGrantsWithQueries_Chap03_MemoryPressure.sql		GetPendingMemoryGrantsWithQueries_Chap03_MemoryPressure.sql
GetRawPerfCounterValuesTotalAndTargetMemory_Chap03_MemoryPressure.sql		GetRawPerfCounterValuesTotalAndTargetMemory_Chap03_MemoryPressure.sql
GetSQLServerEngineProperties_Inventories_Chap02.sql		GetSQLServerEngineProperties_Inventories_Chap02.sql
GetSingletonLookupCount_Chap04_CommonIndexIssues_IndexUsage.sql		GetSingletonLookupCount_Chap04_CommonIndexIssues_IndexUsage.sql
GetTop20TotalQueryResponseTimeForIndividualQueries_Chap03_SlowPerformance.sql		GetTop20TotalQueryResponseTimeForIndividualQueries_Chap03_SlowPerformance.sql
GetTopSQLServerWaits_Chap03_ObservingWaitStatistics.sql		GetTopSQLServerWaits_Chap03_ObservingWaitStatistics.sql
GetTotalServerQueryResponseTime_Chap03_SlowPerformance.sql		GetTotalServerQueryResponseTime_Chap03_SlowPerformance.sql
GetTtlPlanCacheReUse_Chap03_AnatomyCPUMetadataQuery .sql		GetTtlPlanCacheReUse_Chap03_AnatomyCPUMetadataQuery .sql
GetWhatSQLServerIsWtgOnNow_Chap03_AnatomyCPUMetadataQuery.sql		GetWhatSQLServerIsWtgOnNow_Chap03_AnatomyCPUMetadataQuery.sql
Get_sys.dm_os_performance_counters_DMV_Chap03_IntroWaits&Queues.sql		Get_sys.dm_os_performance_counters_DMV_Chap03_IntroWaits&Queues.sql
IdentifyQueriesCausingCPUPressure_Chap03_AnatomyCPUMetadataQuery .sql		IdentifyQueriesCausingCPUPressure_Chap03_AnatomyCPUMetadataQuery .sql
Index_Usage_Stats_Ch07_DefiningCustomDataCollection.sql		Index_Usage_Stats_Ch07_DefiningCustomDataCollection.sql
ListAvailableDMOs_Ch05_PowerOfDynamicManagementViews&Functions.sql		ListAvailableDMOs_Ch05_PowerOfDynamicManagementViews&Functions.sql
MonitorBlockingScript_Ch08_BlockingAndLocking.sql		MonitorBlockingScript_Ch08_BlockingAndLocking.sql
PBMViewEnabledPoliciesScript_Ch10_PolicyBasedManagement.sql		PBMViewEnabledPoliciesScript_Ch10_PolicyBasedManagement.sql
PITWaitTypeScript_Ch07_RollingYourOwn.sql		PITWaitTypeScript_Ch07_RollingYourOwn.sql
PageSplitTrackingRelatedQueries_Ch04_PageSplitTracking.sql		PageSplitTrackingRelatedQueries_Ch04_PageSplitTracking.sql
QuerySystemHeathSessionForErrors_Ch08_MonitoringErrorsWithExtendedEvents.sql		QuerySystemHeathSessionForErrors_Ch08_MonitoringErrorsWithExtendedEvents.sql
QuickIdxFrag_Chap04_IndexFragmentation.sql		QuickIdxFrag_Chap04_IndexFragmentation.sql
RingBufferXEevents_Ch08_MonitoringWithExtendedEvents.sql		RingBufferXEevents_Ch08_MonitoringWithExtendedEvents.sql
SQLLoginSecurityScript_Ch10_ LoginAndPasswordPolicyEnforcement.sql		SQLLoginSecurityScript_Ch10_ LoginAndPasswordPolicyEnforcement.sql
SQLServerBackupReport_Ch09_DatabaseBackupsAndRecoveryModels.sql		SQLServerBackupReport_Ch09_DatabaseBackupsAndRecoveryModels.sql
UpdateMonitoredWaitTypes_SetWaitsToIgnore_Ch07_RollingYourOwn.sql		UpdateMonitoredWaitTypes_SetWaitsToIgnore_Ch07_RollingYourOwn.sql
ViewSuspectPages_BadChecksum_TornPageErrors_Ch09_ Database CorruptionDetectionRecoveryRepair .sql		ViewSuspectPages_BadChecksum_TornPageErrors_Ch09_ Database CorruptionDetectionRecoveryRepair .sql
View all files