Radjammin2
Active Member
Well I would not be suprised if there is a thread on this though I didn't see one?
Re-Indexing, Index Defrag, and Index Tuning.
Right now the company I work for is starting to ramp up on JDE utilization and I wanted to see what the forum concenses is on this area of DB performance tuning. My situation is on MS SQL so I guess I can only relate to that.
Now I know you can do single table re-indexes in OMW but which tool should I be using to batch it. Report name? And how aggressivlly should I be re-indexing? I have to say I have enough work, I don't need to break anything to keep busy...heh.
And what about index tuning, I have done some trace files and run them though the profiler but I don't feel like I get the best results on recommendations.
And what about Index Defrag in MS SQL? I was doing some test defrag and the Page Scan Density does get much better, but is this change effective? With SQL Caching will I notice a responce in performance?
I guess for me I like to read and I don't follow the "just because" mentaility. If my ways not working, I wanta find the better way.
Re-Indexing, Index Defrag, and Index Tuning.
Right now the company I work for is starting to ramp up on JDE utilization and I wanted to see what the forum concenses is on this area of DB performance tuning. My situation is on MS SQL so I guess I can only relate to that.
Now I know you can do single table re-indexes in OMW but which tool should I be using to batch it. Report name? And how aggressivlly should I be re-indexing? I have to say I have enough work, I don't need to break anything to keep busy...heh.
And what about index tuning, I have done some trace files and run them though the profiler but I don't feel like I get the best results on recommendations.
And what about Index Defrag in MS SQL? I was doing some test defrag and the Page Scan Density does get much better, but is this change effective? With SQL Caching will I notice a responce in performance?
I guess for me I like to read and I don't follow the "just because" mentaility. If my ways not working, I wanta find the better way.