Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Optimizing SQL Server Performance with Business...
Unanswered

1. Run this query to check the status of the indexes:SELECT OBJECT_SCHEMA_NAME(ips.object_id) AS sch

(0) ShareShare
ReportReport
Posted on by
1. Run this query to check the status of the indexes:

SELECT OBJECT_SCHEMA_NAME(ips.object_id) AS schema_name,
OBJECT_NAME(ips.object_id) AS object_name,
i.name AS index_name,
i.type_desc AS index_type,
ips.avg_fragmentation_in_percent,
ips.avg_page_space_used_in_percent,
ips.page_count,
ips.alloc_unit_type_desc
FROM sys.dm_db_index_physical_stats(DB_ID(), default, default, default, 'SAMPLED') AS ips
INNER JOIN sys.indexes AS i
ON ips.object_id = i.object_id
AND
ips.index_id = i.index_id
ORDER BY avg_fragmentation_in_percent DESC;

2. Follow the steps in the previous post

3. Rerun the query to see the difference.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Leaderboard > Optimizing SQL Server Performance with Business Central or Navision

Featured topics

Product updates

Dynamics 365 release plans