Index Fragmentation

SqlInstance	Database	Schema	TableName	IndexName	IndexType	PageCount	FragPercent	RecommendedAction
DEV01	ArchiveTestDB	dbo	Events	IX_Events_EventDate	CLUSTERED	2	50	REBUILD
DEV01	ArchiveTestDB	dbo	Events	IX_Events_EventDate	CLUSTERED	2	50	REBUILD
DEV01	ArchiveTestDB	dbo	Events	IX_Events_EventDate	CLUSTERED	2	50	REBUILD
DEV01	ArchiveTestDB	dbo	Events	IX_Events_EventDate	CLUSTERED	2	50	REBUILD
DEV01	ArchiveTestDB	dbo	Events	IX_Events_EventDate	CLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	HumanResources	Employee	AK_Employee_NationalIDNumber	NONCLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	HumanResources	EmployeeDepartmentHistory	PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID	CLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	HumanResources	EmployeePayHistory	PK_EmployeePayHistory_BusinessEntityID_RateChangeDate	CLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Sales	SalesPersonQuotaHistory	PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate	CLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Production	Product	AK_Product_ProductNumber	NONCLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Production	Product	AK_Product_rowguid	NONCLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Person	vStateProvinceCountryRegion	IX_vStateProvinceCountryRegion	CLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Sales	SpecialOfferProduct	AK_SpecialOfferProduct_rowguid	NONCLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Person	StateProvince	PK_StateProvince_StateProvinceID	CLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Sales	Store	IX_Store_SalesPersonID	NONCLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Production	ProductProductPhoto	PK_ProductProductPhoto_ProductID_ProductPhotoID	NONCLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Production	ProductReview	PK_ProductReview_ProductReviewID	CLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Purchasing	ProductVendor	IX_ProductVendor_UnitMeasureCode	NONCLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Purchasing	Vendor	PK_Vendor_BusinessEntityID	CLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Person	CountryRegion	PK_CountryRegion_CountryRegionCode	CLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Person	CountryRegion	AK_CountryRegion_Name	NONCLUSTERED	2	50	REBUILD
DEV01	AdventureWorks	Person	BusinessEntityContact	IX_BusinessEntityContact_PersonID	NONCLUSTERED	3	33,33	REBUILD
DEV01	AdventureWorks	Person	BusinessEntityContact	IX_BusinessEntityContact_ContactTypeID	NONCLUSTERED	3	33,33	REBUILD
DEV01	AdventureWorks	HumanResources	Employee	AK_Employee_LoginID	NONCLUSTERED	3	33,33	REBUILD
DEV01	AdventureWorks	Sales	Store	AK_Store_rowguid	NONCLUSTERED	3	33,33	REBUILD
DEV01	AdventureWorks	Production	ProductReview	IX_ProductReview_ProductID_Name	NONCLUSTERED	3	33,33	REBUILD
DEV01	AdventureWorks	Production	ProductListPriceHistory	PK_ProductListPriceHistory_ProductID_StartDate	CLUSTERED	3	33,33	REBUILD
DEV01	AdventureWorks	Sales	SpecialOfferProduct	PK_SpecialOfferProduct_SpecialOfferID_ProductID	CLUSTERED	3	33,33	REBUILD
DEV01	AdventureWorks	Production	ProductCostHistory	PK_ProductCostHistory_ProductID_StartDate	CLUSTERED	3	33,33	REBUILD
DEV01	AdventureWorks	Production	ProductDescription	AK_ProductDescription_rowguid	NONCLUSTERED	3	33,33	REBUILD
DEV01	AdventureWorks	dbo	DatabaseLog	PK_DatabaseLog_DatabaseLogID	NONCLUSTERED	4	25	REORGANIZE
DEV01	AdventureWorks	Production	ProductModelProductDescriptionCulture	PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID	CLUSTERED	4	25	REORGANIZE
DEV01	AdventureWorks	Production	Product	AK_Product_Name	NONCLUSTERED	4	25	REORGANIZE
DEV01	AdventureWorks	Person	BusinessEntityContact	AK_BusinessEntityContact_rowguid	NONCLUSTERED	4	25	REORGANIZE
DEV01	AdventureWorks	Purchasing	ProductVendor	PK_ProductVendor_ProductID_BusinessEntityID	CLUSTERED	5	20	REORGANIZE
DEV01	AdventureWorks	Production	WorkOrder	IX_WorkOrder_ProductID	NONCLUSTERED	131	17,56	REORGANIZE
DEV01	AdventureWorks	Production	WorkOrderRouting	IX_WorkOrderRouting_ProductID	NONCLUSTERED	138	16,67	REORGANIZE
DEV01	AdventureWorks	Person	BusinessEntityContact	PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID	CLUSTERED	6	16,67	REORGANIZE
DEV01	AdventureWorks	Production	TransactionHistory	IX_TransactionHistory_ProductID	NONCLUSTERED	207	15,94	REORGANIZE
DEV01	AdventureWorks	Production	TransactionHistoryArchive	IX_TransactionHistoryArchive_ProductID	NONCLUSTERED	159	14,47	REORGANIZE
DEV01	AdventureWorks	Production	ProductInventory	PK_ProductInventory_ProductID_LocationID	CLUSTERED	7	14,29	REORGANIZE
DEV01	AdventureWorks	Purchasing	PurchaseOrderHeader	IX_PurchaseOrderHeader_VendorID	NONCLUSTERED	7	14,29	REORGANIZE
DEV01	AdventureWorks	Purchasing	PurchaseOrderHeader	IX_PurchaseOrderHeader_EmployeeID	NONCLUSTERED	7	14,29	REORGANIZE
DEV01	AdventureWorks	Production	TransactionHistoryArchive	IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID	NONCLUSTERED	205	11,22	REORGANIZE
DEV01	AdventureWorks	Production	BillOfMaterials	PK_BillOfMaterials_BillOfMaterialsID	NONCLUSTERED	9	11,11	REORGANIZE
DEV01	AdventureWorks	Person	Person	IX_Person_LastName_FirstName_MiddleName	NONCLUSTERED	108	11,11	REORGANIZE
DEV01	AdventureWorks	Production	BillOfMaterials	IX_BillOfMaterials_UnitMeasureCode	NONCLUSTERED	10	10	REORGANIZE
DEV01	AdventureWorks	Production	TransactionHistory	IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID	NONCLUSTERED	261	9,58	REORGANIZE
DEV01	AdventureWorks	HumanResources	JobCandidate	PK_JobCandidate_JobCandidateID	CLUSTERED	11	9,09	REORGANIZE
DEV01	AdventureWorks	Sales	SalesOrderDetail	IX_SalesOrderDetail_ProductID	NONCLUSTERED	277	8,3	REORGANIZE
DEV01	AdventureWorks	Production	Product	PK_Product_ProductID	CLUSTERED	13	7,69	REORGANIZE
DEV01	AdventureWorks	Production	BillOfMaterials	AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate	CLUSTERED	20	5	REORGANIZE
DEV01	AdventureWorks	Purchasing	PurchaseOrderDetail	IX_PurchaseOrderDetail_ProductID	NONCLUSTERED	20	5	REORGANIZE
DEV01	SQLLiveDiagnose	dbo	QueryStoreTopQuery	PK_QueryStoreTopQuery	CLUSTERED	7	14,29	REORGANIZE

Index Fragmentation - DEV01