Skip to content

对数据库(MySQL,SQL SERVER)进行性能优化时用到的SQL

Notifications You must be signed in to change notification settings

boss-mao/database-profiler

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

28 Commits
 
 
 
 
 
 
 
 

Repository files navigation

SQLServer文件夹:对SQL Server进行性能优化时用到的SQL

  • lock.sql 锁监控
  • index.sql 索引监控
  • environment.sql 数据库环境监控
  • sql-perform-count.sql sql执行次数和性能监控
  • who_is_active_v11_17.sql 开源监控脚本,监控数据库锁定情况,地址:http://whoisactive.com/

MySQL文件夹:对MySQL进行性能优化时用到的SQL和操作

  • 操作系统配优化
  • 执行计划与锁表查看
  • ptquerydigest工具操作命令

Nginx文件夹:对nginx进行优化的配置项

About

对数据库(MySQL,SQL SERVER)进行性能优化时用到的SQL

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published