Actually, in SQL2000, if you don't set max memory to the same value of what you want the instance to take, when using AWE, my understanding is that SQL Server...

Ahhhh, ok Colin, I think I see where you're coming from now. I was going on pure spindle-count comparison, i.e 4 spindles in RAID 5 array and 4 spindles in RAID...

Ok, thought about my previous response and I'm more thinking about outright performance based on time - there is still 2 write io's for RAID 10.

That said though Colin, I'm...

Sorry Brian, but in my humble experience (:satisfied  I have not found the SAN vendors ot their 3rd Parties to be the best option in...

Sam,

Not sure if you've resolved this, and not sure of your service pack level is, but there are a number of issues for AWE. Might want to look at this...

Hi Andy,

You mention your system is clustered, so you will not be able to put anything on a local 'node' drive that the SQL Server virtual instance relies on, these...

Hi Malcolm,

Guess mine might be a dumb question, but have you considered the Normalisation of your schema (and any de-normalisation as appropriate)?  For instance, are you saying that if you...

You might also find Randy Dyess' article on Bookmark Lookups useful:

http://www.sqlservercentral.com/columnists/RDyess/bookmarklookups.asp

rgds  iwg

Fair point. Here you go

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=341596#bm342761

... you may be already aware of this, but just want to mention that INDEXDEFRAG is not the same thing as DBREINDEX. Also, it may cause more problems than not...

No problem Colin. I should have said that I was refering to Writes really, ie RAID 10, 2 times IO for every Write, and for RAID 5, 4 times IO (from SQL Server...

Will,

I think the cost question is one you need to ask your supplier(s) - depends on what discounts you get, etc.

Purely from what I've read, if you're needing 1TB of...

RAID 5 has a number of issues with it. One is performance when writes are involved - twice as many IOs as RAID 10. Second is its redundancy. It has the...

Hi Asela,

From just what you've said above, processors are not your problem. We've had boxes regularly running at 80 - 90% absolutely fine. Unless you're seeing your cpu's maxing for...

Hi Justing,

Sorry I haven't got back sooner, but I've been away.

Ok, slight confusion here. Your initial question was concerning what 'Server' permissions your DBA(s) may need. You didn't ask about...