Red Gate forums :: View topic - Index Fragmentation Operations
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

Index Fragmentation Operations

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Eric Nolen



Joined: 18 Sep 2009
Posts: 5

PostPosted: Fri Sep 18, 2009 6:26 pm    Post subject: Index Fragmentation Operations Reply with quote

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
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Mon Sep 21, 2009 9:45 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group