Kenneth,

Nope. The database was created with a sufficient amount of spaces which probably can last us for half a year.

thanks Chris for the link it's really helpful.

And yes I do have multiple files in different filegroups so I guess can just focus...

Chris,

Can you please elaborate more on this:

[External fragmentation means that the logical chain of pages requires unnecessary extent switches.]

if external fragmentation is really high how do I...

Mike,

yes I do. I have setup maintenance job to reindex regularly on all DBs. One question, even after Reindex usually the external fragmentation still remains.. will disk defragmentation solve this?...

sp4 warning:

http://www.microsoft.com/sql/downloads/2000/sp4.mspx

or you can refer the previous topic "sp4 warning" which probably will give you some hints on your issue.

My SQL server performance object missing from the drop down list after the memory upgrade!!!

Any idea how to enable it back???

Please help !

Thanks

Hi Rick,

Yes for all your questions except for the last one.

These databases in both the servers was setup for my testing purpose and no log dumps is being scheduled.

I did...

Seems you guys have a good review for AMD...after testing it for 2 weeks basically it really performs well but my bottleneck now is still stuck with my abnormal log...

I am testing on AMD Opteron64 and a Intel processor running SQL Server 2000 Ent.

I have encountered problem when I was running a reindex script on one of the database...

One question... I looked at the fixlist in sp4 and found that there’s actually a fix for AWE so wondering if the bug exists in sp3a right now.

The following is...