Index Fragmentation Operations

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Index Fragmentation Operations

Postby Eric Nolen » Fri Sep 18, 2009 6:26 pm

I am trying out SQL Response and was curious if anyone knew what options SQL Response uses when it runs DBCC SHOWCONTIG(specifically with or without the FAST option) to get index fragmentation levels. In production we have some very large tables and I am concerned about performance when scanning the indexes for fragmentation levels.

Also does anyone know how frequently SQL Response is going out and polling the Servers?

Thanks in advance for any answers!
-Eric Nolen
Eric Nolen
 
Posts: 5
Joined: Fri Sep 18, 2009 6:16 pm

Postby priyasinha » Mon Sep 21, 2009 9:45 am

Hi Eric,

SQL Response runs DBCC SHOWCONTIG with FAST option to get index fragmentation.

SQL Response polls servers at different rates for different checks.

SQL Response 1.3 supports scheduling index fragmentation scan. So if you are concerned about the performance when SQL Response is scanning the index then please use this feature. I am sending you a PM to tell the steps you have to do to schedule this.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests