SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Index wizard - resource hog

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Index wizard - resource hog
Author Message
benj



Joined: 19 Jul 2001
Posts: 1

Post Index wizard - resource hog Reply with quote


After only analyzing 80 indexes, my PC slowed to a halt as it ran out of resources.

then, I set the pagefile for 1GB, and let the wizard run overnight. It reached around 380 indexes (out of 2,000) and halted on "Statistics not found on Column XXX, Continue?"

It's annoying. Is there an option to auto-generate statistics if needed?
(like Quest SQL XPert)

Speed it up, don't consume all the resources.

Thanks

Thu Jul 19, 2001 11:28 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Index wizard - resource hog Reply with quote

You have full control what to include/not include for the analysis.

First of all, you can select only one schema or (several schemas) and not all of them. Secondary, you can select only several indexes in the selected schema() and not all of them. Then you can exclude system objects and then from a bunch of analyzed parameters you pick only the options you really want. For example you can tun off option to analyze data in tables.

Also, note the analysis time is mostly taken by your database while it is running various ANALIZEs and COUNTs

As for the resource usage, I am able to analyze thousands of indexes on my PC (256MB RAM, 268MB page file), so I suspect it is dependent on the machine configuration. One thing that may sound weird, but could help, is to select another printer as a default printer. Also, make sure a default printer is selected. Every index report is generated in the background in the Print Preview mode. If there is no default printer selected, it can cause some side effects.

: After only analyzing 80 indexes, my PC slowed to a halt as it ran out of
: resources.

: then, I set the pagefile for 1GB, and let the wizard run overnight. It
: reached around 380 indexes (out of 2,000) and halted on "Statistics
: not found on Column XXX, Continue?"

: It's annoying. Is there an option to auto-generate statistics if needed?
: (like Quest SQL XPert)

: Speed it up, don't consume all the resources.

: Thanks

Thu Jul 19, 2001 12:05 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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
Design by Freestyle XL / Flowers Online.