Category
主题
副主题
SQL Index Fragmentation and Maintenance (4295446)
One of the most critical variables for database performance is SQL Index Fragmentation. ... We may face blocking, deadlocks, IO issues, Disk spill issues if the fragmentation level is not appropriately managed.
How to activate ApexSQL software manually (4216052)
To activate an ApexSQL product online, a Hardware ID and a product activation key are needed. ... To manually activate an ApexSQL product online: ... Navigate to ‘ Product activation’ web page ... Select the ApexSQL product to be activated from the ‘Product’ pick list and the appropriate product version from the ‘Version’ pick list
Why, when and how to rebuild and reorganize SQL Server indexes (4281054)
Why, when and how to rebuild and reorganize SQL Server indexes "<p> The purpose of SQL Server index is pretty much the same as in its distant relative – the book index – it allows you to get to the information quickly, but instead of navigating through the book, it indexes a SQL Server database.
Licensing and activation of centralized system products (4318747)
This article describes what you need to know about the licensing and activation of centralized ApexSQL products. ... Definitions ... Central instance – this is a computer where the main application and SQL Server instance that hosts the central repository database is installed.
Monitor SQL Server index size (4216039)
This article provides information about reviewing and monitoring SQL Server index size with ApexSQL Defrag and ApexSQL Monitor. ... This article provides information about reviewing and monitoring SQL Server index size with ApexSQL Defrag and ApexSQL Monitor.
ApexSQL Defrag installation and troubleshooting guide (4289258)
ApexSQL Defrag is a powerful application used for scheduled analyzing and defragmenting SQL Server database indexes. ... It consists of three main components: ... User interface – It’s the main part of the application, where user can interact with the application, analyze indexes, create and modify jobs on a schedule, look at reports, monitor the scheduled jobs.
SQL index fragmentation reports (4298762)
The purpose behind creating SQL indexes on database tables is to enhance the performance of the queries that read data from the base table by speeding up the data retrieval processes. ... But these transactional tables are not static and changing very frequently over time.
How to automate SQL Server defragmentation using policies (4291159)
Apart from numerous factors, poor index maintenance can be a reason for decreased SQL Server performance. ... If a database contains tables with numerous entries, that get updated frequently, it is most likely that high index fragmentation will occur.
How to automate and schedule SQL Server index defragmentation (4291744)
SQL Server maintenance is not a one-time event, but rather a part of a continuous process. ... Apart from regular backups and integrity checks, performance improvements can be achieved with index maintenance.
Licensing and activation of centralized system products (4214761)
This article describes what you need to know about the licensing and activation of centralized ApexSQL products. ... Those currently includes ApexSQL Monitor, ApexSQL BI Monitor, ApexSQL VM Monitor, ApexSQL Defrag, ApexSQL Backup, ApexSQL Job and ApexSQL Audit.
How to customize policies for automatically defragmenting SQL Server indexes (4299166)
When creating indexes, database administrators should look for the best settings to ensure minimal performance impact and degradation. ... However, over time, indexes will get fragmented, which can severely impact server performance.
Send logs feature in ApexSQL tools (4288785)
In this article, it will be explained how to use the Send logs feature for sending application log files through ApexSQL tools to the support team. ... Every ApexSQL tool collects all important information regarding work processes and stores them in the log files.
How to monitor the status of index defragmentation jobs with ApexSQL Defrag (4262113)
SQL Server Index is one of the most important factors in the SQL Server performance tuning field that is used to enhance the queries’ performance by speeding up the data retrieval process. ... It is a double-edged sword that can enhance the database performance when designing it properly and performing the index defragmentation maintenance periodically, and degrade the database performance when it is not designed or maintained well.
What is the difference between Fast and Deep analyzing (4310684)
What is the difference between Fast and Deep analyzing. ... N/A Fast: Will scan register only, gathering results from the last fragmentation analysis.<br><br>Deep: Will pull fragmentation statistics directly from the SQL server.
Is my ApexSQL application version vulnerable to Log4j - CVE-2021-44228? (4309395)
Determine if the installed ApexSQL application version is vulnerable to <a href="https://nvd.nist.gov/vuln/detail/CVE-2021-44228" target="_blank">Log4j - CVE-2021-44228</a>. The discovery of critical vulnerability <a href="https://nvd.nist.gov/vuln/detail/CVE-2021-44228" target="_blank">CVE-2021-44228</a> in the Apache Log4j library (CVSS severity level 10 out of 10). <p><strong>Unaffected products:</strong></p><p>ApexSQL Analyze<br>ApexSQL Audit<br>ApexSQL Backup<br>ApexSQL Build<br>ApexSQL Compare<br>ApexSQL Complete<br>ApexSQL Data Diff<br>ApexSQL Data Diff for MySQL<br>ApexSQL Database Power Tools for VS Code<br>ApexSQL Decrypt<br>ApexSQL Defrag<br>ApexSQL DevOps Toolkit<br>ApexSQL Diff<br>ApexSQL Diff for MySQL<br>ApexSQL Discover<br>ApexSQL Doc<br>ApexSQL Doc for MySQL<br>ApexSQL Enforce<br>ApexSQL Generate<br>ApexSQL Job<br>ApexSQL Log<br>ApexSQL Manage<br>ApexSQL Mask<br>ApexSQL Model<br>ApexSQL Monitor<br>ApexSQL Plan<br>ApexSQL Propagate<br>ApexSQL Pump<br>ApexSQL Recover<br>ApexSQL Refactor<br>ApexSQL Script<br>ApexSQL Search<br>ApexSQL Source Control<br>ApexSQL Trigger<br>ApexSQL Unit Test</p><p></p>
Schedule and automate SQL Server instance index policies (4262860)
The following article provides an in-depth look into the process of scheduling and automating SQL Server instance index defragmentation policies. ... Due to the constant load and heavy traffic that a SQL Server may be exposed to, its indexes are becoming more fragmented by the minute.
Create and run SQL Server instance index policy templates (4255150)
This article explains the perks of having SQL Server instance index defragmentation policy templates, the easiness of setting them up, and the convenience of its later usage. ... SQL index software is already packed with plenty of predefined index defragmentation policy templates but it still offers some tweaks and customizations in this department.
Microsoft SQL Server 2022 Support for ApexSQL Log? - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Source Control Action Center: how can one ignore user changes and not default select - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Understand the true significance of "perpetual." - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Unable to download free trail ApexSql doc. - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Unable to download free trail ApexSQL Devops Plus toolkit for ApexSQL doc - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
When will SourceControl work with MSSMS 2019? - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
ApexSQL Diff - Object filter - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Auto-deploy schema changes? Affordable tool options? - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
新产品关联性