【自主研发-贡献给SQL Server人员】索引诊断与优化软件使用说明（1）-总体预览
索引设计是数据库设计中比较重要的一个环节，对数据库的性能其中至关重要的作用，但是索引的设计却又不是那么容易的事情，性能也不是那么轻易就获取到的，很多的
索引设计是数据库设计中比较重要的一个环节，对数据库的性能其中至关重要的作用，但是索引的设计却又不是那么容易的事情，性能也不是那么轻易就获取到的，很多的技术人员因为不恰当的创建索引，最后使得其效果适得其反，可以说“成也索引，败也索引”。
一直以来，我们总是在寻求好的性能优化软件，我们一直以来也是在用脚本加上复杂的操作来分析问题。和大家一样，我们也经过很多的类似的困境，后来我们就开发了索引诊断与优化软件。
完全的自主研发，已经在企业中使用。
先上图，给大家看看，我之后整理说明文档，然后发布软件的免费版本给大家！
软件启动，登陆数据库如图：
2012-11-28 13:00 上传
下载附件 (38.15 KB)
登陆之后，主界面如下：
2012-11-28 13:02 上传
下载附件 (136.17 KB)
在这里可以看到，软件包含了三个部分功能：
对于常见的索引问题的快速诊断：Common Issue
基于基准线分析的高级诊断：Advance.
辅助的分析：Assistant
例如，我们要分析某个数据库上面是否存在缺失索引的问题，虚拟主机，我们只要选中数据库，然后点击上面的“Missing Index”按钮就行了，如下，结果：
2012-11-28 13:05 上传
下载附件 (173.46 KB)
软件会分析每个缺失索引带来的成本，或者说，给出：如果建立了索引，带来的性能的提升指数。
不仅如此，还可以选中分析中的一行，然后点击上面的索引操作，如创建索引，软件会默认的分析索引，并且会自动生成脚本，而且索引中的列也是根据数据的选择率进行了排序的，更为强大的是，我们还可以自己在软件建议的语句上面，修改，使得创建索引更为合理：
2012-11-28 13:09 上传
下载附件 (168.61 KB)
自定义写语句也是相当的省心，因为软件给出了写TSQL语句必要的参考文档，香港服务器租用，代码结构，自动的代码高亮显示，而且还可验证脚本的正确性：如图：
我们可以自己决定是否需要自定义脚本，还是采用软件自动生成的，然后添加自己的索引，我们可以选择很多个一起执行，如图：
下载附件 (131.11 KB)
执行之后，如图：
当然，上面只是简单的演示了一下软件的功能而已，之后，大家可以下载下来把玩一下！
我们下面就说说高级功能
高级功能就需要建立基准线，然后利用软件进行分析，过程也不复杂，软件已经内置了很多的分析算法，大家只要掌握索引的必须的知识，然后学会如何看软件里面的图示和数据就行了
2012-11-28 13:21 上传
下载附件 (77.26 KB)
如图，如果我们没有建立基准线数据库，那么高级功能都是无法使用的。
我们可以运行向导，一步步的建立基准数据库以及相关的其他对象，如图：
下载附件 (51.38 KB)
第一步，建立数据库，如图：
下载附件 (64.76 KB)
第二步，建立相关的数据表，如图：
下载附件 (49.61 KB)
第三步，网站空间，建立相关的Job去收集数据，如图：
下载附件 (56.85 KB)
之后，高级功能就可以使用了，但是此时，基准数据库中可能的数据还不够多，分析的准确度不太高，随着收集到的数据的变多，准确度会提高！
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
BYD's self-developed 'God's Eye' system is the first of its kind in the world
Jul 11, 2023 pm 04:25 PM
According to news on July 4, BYD unveiled its advanced intelligent driving assistance system "God's Eye" for the first time at a press conference today, and announced that the system will be applied to the Denza N7 model. According to BYD, "Eye of the God" is an advanced intelligent assisted driving system. It is an on-board computing platform completely independently designed and produced by BYD. It is the world's first system independently developed by an automobile manufacturer. In order to achieve the goal of intelligent driving, BYD has invested in a research and development team of more than 2,000 people and established a vehicle intelligent driving experiment center. Denza N7 will become the first model equipped with the "Eye of God" system. This smart hunting SUV is listed in the sales data of Dynasty and Haiyang.com owned by BYD.
How does Hibernate optimize database query performance?
Apr 17, 2024 pm 03:00 PM
Tips for optimizing Hibernate query performance include: using lazy loading to defer loading of collections and associated objects; using batch processing to combine update, delete, or insert operations; using second-level cache to store frequently queried objects in memory; using HQL outer connections , retrieve entities and their related entities; optimize query parameters to avoid SELECTN+1 query mode; use cursors to retrieve massive data in blocks; use indexes to improve the performance of specific queries.
How to optimize the performance of MySQL database?
Sep 11, 2023 pm 06:10 PM
How to optimize the performance of MySQL database? In the modern information age, data has become an important asset for businesses and organizations. As one of the most commonly used relational database management systems, MySQL is widely used in all walks of life. However, as the amount of data increases and the load increases, the performance problems of the MySQL database gradually become apparent. In order to improve the stability and response speed of the system, it is crucial to optimize the performance of the MySQL database. This article will introduce some common MySQL database performance optimization methods to help readers
How to improve the access speed of Python website through database optimization?
Aug 07, 2023 am 11:29 AM
How to improve the access speed of Python website through database optimization? Summary When building a Python website, a database is a critical component. If the database access speed is slow, it will directly affect the performance and user experience of the website. This article will discuss some ways to optimize your database to improve the access speed of your Python website, along with some sample code. Introduction For most Python websites, the database is a key part of storing and retrieving data. If not optimized, the database can become a performance bottleneck. Book
Spring Boot performance optimization tips: create applications as fast as the wind
Feb 25, 2024 pm 01:01 PM
SpringBoot is a popular Java framework known for its ease of use and rapid development. However, as the complexity of the application increases, performance issues can become a bottleneck. In order to help you create a springBoot application as fast as the wind, this article will share some practical performance optimization tips. Optimize startup time Application startup time is one of the key factors of user experience. SpringBoot provides several ways to optimize startup time, such as using caching, reducing log output, and optimizing classpath scanning. You can do this by setting spring.main.lazy-initialization in the application.properties file
Java Spring Boot Security performance optimization: make your system fly
Feb 19, 2024 pm 05:27 PM
1. Code optimization to avoid using too many security annotations: In Controller and Service, try to reduce the use of @PreAuthorize and @PostAuthorize and other annotations. These annotations will increase the execution time of the code. Optimize query statements: When using springDataJPA, optimizing query statements can reduce database query time, thereby improving system performance. Caching security information: Caching some commonly used security information can reduce the number of database accesses and improve the system's response speed. 2. Use indexes for database optimization: Creating indexes on tables that are frequently queried can significantly improve the query speed of the database. Clean logs and temporary tables regularly: Clean logs and temporary tables regularly
How to improve the cache hit rate and database query efficiency of PHP and MySQL through indexes?
Oct 15, 2023 pm 01:15 PM
How to improve the cache hit rate and database query efficiency of PHP and MySQL through indexes? Introduction: PHP and MySQL are a commonly used combination when developing websites and applications. However, in order to optimize performance and improve user experience, we need to focus on the efficiency of database queries and cache hit rates. Among them, indexing is the key to improving query speed and cache efficiency. This article will introduce how to improve the cache hit rate and database query efficiency of PHP and MySQL through indexing, and give specific code examples. 1. Why use
How to optimize cross-table queries and cross-database queries in PHP and MySQL through indexes?
Oct 15, 2023 am 09:57 AM
How to optimize cross-table queries and cross-database queries in PHP and MySQL through indexes? Introduction: In the development of applications that need to process large amounts of data, cross-table queries and cross-database queries are inevitable requirements. However, these operations are very resource intensive for database performance and can cause applications to slow down or even crash. This article will introduce how to optimize cross-table queries and cross-database queries in PHP and MySQL through indexes, thereby improving application performance. 1. Using indexes Index is a data structure in the database
