if you have more than one instance then you must set the max memory for each instance, the total assigned memory cannot exceed the total available memory less whatever for...

I know it's much later - but I was searching for the error - you mention 16 procs on a 4 way dual core , you should really disable HT...

even with 4 disks you will get so much better performance with raid 10 then raid 5. It's really well documented about raid and databases, been in sql books since...

if you're running 64bit you must set the max memory in sql server, otherwise you'll have real problems. I can't imagine why anyone would suggest you disable lock pages in...

you might want to try dropping your query into a proc and passing parameters to the proc and see if there's a difference.

Generally when awe is enabled sql server will grab all the memory, I assume you've set max and min memory ?  I've never been able to run a small database...

Just making changes without understanding the cause can be dangerous :- consider:-

Your car braking has degraded, someone suggests new pads - you do this but sadly this isn't the...

you illustrate my point, just adding indexes without knowing why or understanding is dangerous.

Use a test system, compare performance, io etc. etc.

the views return data regardless of the method or source. You should not blindly add recommendations but research carefully.

I don't know how you're measuring memory but you can't use task manager. If you're enabled lock pages in memory you MUST set the max memory on the sql server...

Hmmm .. I'm not sure I agree, the biggest advantage of sql2005 is 64bit and I'd hope we were all heading this way very quickly - I accept I tend...

I think you're starting from the wrong assumption, it's highly unlikely you can mess with fill factors to eliminate fragmentation - and none of your hard work will offset the...

Hmmm .. think you might benefit from a good read of BOL or a suitable training course!

I suggest you buy more disks, raid 5 is absolutely no use except for a read only database, even for the budget user raid 5 is a waste of time....

If this is for a bank and I had an account with it I'd probably want to move to another bank!! Hope this isn't a UK bank - although I'm...