Thanks for the helpful reco.

So, I will increase the Max Mem to 12GB (why should I not keep it at 16GB, is it because OS needs some?)

and also Page Fize...

465789psw

Thanks for your input.

The DB is 210GB; Ram 16GB; SQL server Memory min and max (0 and 8GB); TempDB is 24GB right now; Page life expectancy is 600.

Brent has...

Gail

Thanks for your input:

avg sec/read is 29ms (log is 8 ms) and avg sec/write is 8 ms (log is 6ms)

Dan

The second link suggests "re-run sql setup and choose Advanced / registry rebuild". Is this from the CD or command prompt? (http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/a8cc09a9-7500-4fc3-90f4-fd5fff94509b)

I changed the command as in first link, but...

Thanks for your input.

Registry.. oh no!

named instance; ping does not work(times out)

here is the background.. (I first thought this may not have anything to do with it.. but the more...

Gail

recovery interval seems to be around a minute. Thanks for clarifying that.

I just wished it would have given some kind of warning that we are not using the right options...

Guru

All your points are well taken. Yes, the DB is heavily hit for I/O bottleneck (we use perfmon-Avg. Disk Queue Length is 27; % disk time 2100; Current Disk Queue...

Gail,

Yes, I see what you are saying. Better to have clustered in one and NC in another; but even better yet, to just move the heavily used NC to another...

Steve

Thanks for looking at the code.

I was able to relate to your recommendation on separating heavy indexes vs scanned tables. So we need to do some good profiling on this...

Steve

Thanks for the nice comparison of the different technologies that can help.

Does the SAN enabled for Snap feature, or does it take extra hardware/software to make it work?

Thanks again

Dan

What kind of activity can cause GB's of paging?

Glenn

i did not know Instant initialisation was also called "Zero-out". You gave a good explanation of the difference Full and Simple in terms of log handling.

thx

Dan

Gail

Thanks for the help.

We had been trying to do this way, hoping to save space.

Do you know what is the default recovery interval, in minutes, for FULL...

Jeff

Does the DB folks setup the SAN Snapshots (if you have access to the drives where the mdf database is stored) or is it part of the network team's job?

This...

Steve, it is an OLAP. So 200MB of bulk data a day, spread throughout, in chunks.

Jim, yes, it is growing!, and yes, 100s of users need reports everyday. The data...