| CARVIEW |
Select Language
HTTP/2 301
content-length: 0
cache-control: no-cache, no-store, must-revalidate
location: /sql-tools-defrag/
set-cookie: ASP.NET_SessionId=adikzwqw5rmpvafgelftcvfp; path=/; secure; HttpOnly; SameSite=Lax
set-cookie: QSTLB=33373962.1.4271802240.3569048065; path=/; httponly;secure ;
x-aspnet-version: 4.0.30319
x-ua-compatible: IE=edge,chrome=1
x-frame-options: SAMEORIGIN
strict-transport-security: max-age=31536000; includeSubDomains; preload
x-content-type-options: nosniff
referrer-policy: strict-origin-when-cross-origin
content-security-policy: upgrade-insecure-requests;
x-permitted-cross-domain-policies: None
permissions-policy: camera=(), microphone=(), payment=()
date: Sat, 02 Aug 2025 00:29:09 GMT
x-cache: Miss from cloudfront
via: 1.1 1e3b45fb00f0cc03b69786cf1a92d5e4.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM54-P2
x-amz-cf-id: 9OTtDINun8pgKzMiFaxXPo23W3hUKIUJuGk_Rm0kK-iINKuU440nXw==
HTTP/2 200
content-type: text/html; charset=utf-8
cache-control: max-age=14400, s-maxage=86400
server:
x-aspnet-version: 4.0.30319
x-ua-compatible: IE=edge,chrome=1
x-frame-options: SAMEORIGIN
strict-transport-security: max-age=31536000; includeSubDomains; preload
x-content-type-options: nosniff
referrer-policy: strict-origin-when-cross-origin
content-security-policy: upgrade-insecure-requests;
x-permitted-cross-domain-policies: None
permissions-policy: camera=(), microphone=(), payment=()
date: Sat, 02 Aug 2025 00:29:10 GMT
content-encoding: gzip
vary: accept-encoding
x-cache: Miss from cloudfront
via: 1.1 1e3b45fb00f0cc03b69786cf1a92d5e4.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM54-P2
x-amz-cf-id: Fle1VuyCPUd9rRnIkGb88372o6wJvHbkhOgI1wQpC62Ill7-72C8xw==
SQL index monitoring and analysis | ApexSQL
SQL index monitoring and analysis
11:33
![How to automate SQL Server defragmentation using policies]()
This is the end
SQL index monitoring and analysis
ApexSQL Defrag is a powerful application used for scheduled analyzing and defragmenting of SQL Server database indexes. Its wide range of features allows users to create and manage custom policies, monitor index fragmentation on multiple servers as well as to create index fragmentation reports.
11:33
Benefits
-
Analyze index fragmentation
-
Rebuild and reorganize fragmented indexes
-
Create and manage custom policies
-
Set schedules for defragmentation jobs
-
Set Email notifications
-
Monitor index fragmentation on multiple servers
-
Export all activities to CSV or XML
-
Create index fragmentation reports
Features
Index fragmentation analysis
Search and analyze indexes by server, database, table, or index. Get detailed information on index type, size, fragmentation percentage, and fill factor with advanced grouping and filtering options Learn more
Index defragmentation
Reorganize or rebuild fragmented indexes Learn more
Custom policies
Use custom policies to automate database index maintenance. Enable, run or disable a policy with a single click. Learn more
Fragmentation thresholds
Set thresholds for reorganizing and rebuilding jobs Learn more
Job scheduling
Set daily or weekly schedules for rebuild and reorganize jobs, or execute them in real time
Email notifications
Set the Email notification for successful or failed jobs
Monitoring
Monitor all defragmentation jobs and policies from a central location Learn more
Activities export
Export the activities to CSV or XML
Index fragmentation reports
Create reports on index fragmentation and index memory usage for a database, table or a single index
Policy templates
Use custom or pre-made policy templates to define and deploy new policies in a few clicks
Alerts
Manage alerts for all defragmentation jobs and policies
Statistical reports
Generate statistical reports for most fragmented indexes on the selected server, database or table
Fill factor management
Set and monitor index fill factor
Proactive resource check
Actively run resource checks for CPU, memory and hard disk usage before creating a policy
Custom maintenance scripts
Run custom scripts before or after executing defragmentation policies
Resources and support
Gallery
Related Topics
How to automate SQL Server defragmentation using policies
This article explains solutions for creating fully functional SQL Server defragmentation policy
Testimonials
Medisked
Really loving the ApexSQL offerings. You are now our first choice for SQL tools.
Michael Wolfe Engineering SupervisorHigh ROI CRM Consultant
ApexSQL is my formidable work instrument. I'm a high ROI CRM consultant, and I use this kind of product every day for my projects. ApexSQL is a perfect instrument for my work and a great aid to my productivity.
Angelo Paglialonga High ROI CRM ConsultantSchneider Mills Inc.
I’ve been using ApexSQL tools since around 2006. ApexSQL Trigger, ApexSQL Diff and ApexSQL Data Diff are my favorites… though ApexSQL Log, and its ability to roll back any change, has been a life saver more than once. I’ve had the pleasure of purchasing ApexSQL Universal with 4 different employers and hope to continue using it until I retire.
Joshua Walker Database AnalystWiginton Corporation
I greatly appreciate your assistance. I have to say all of my experiences with ApexSQL have been great. Thank you for the wonderful customer service.
Bryan Benton Director of Information TechnologyPlease wait...