Monitor, diagnose and receive alerts to problems across your SQL Servers.
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!
- Posts: 5
- Joined: Fri Sep 18, 2009 5:16 pm
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.
- Posts: 549
- Joined: Wed Jan 03, 2007 4:02 pm
Return to SQL Monitor Previous Versions
Who is online
Users browsing this forum: No registered users and 0 guests