Yes, Thanks for your reply...

I got it and Now clearly understand DTA process work.

when given trace file to DTA, first tuned the all the event and statement whatever stored in...

ok, thanks for reply..

DTA result, these number are tuned process event & statement from trace file, so nothing was done automatically tuned at database level. am i correct?

yes, tuning analysis summary report, I want to know

1. Number of events tuned 3101, - what does event exactly tuned done at Database itself?

Number of statements tuned 30657 -...

By using the /3GB or /USERVA startup switches in the Windows boot.ini file, this default configuration can be overridden to provide 3GB of VAS to the user address space application...

Thanks for your reply..

As you suggested to increase cost threshold for parallelism between 35 & 50? and default value 5 is not Sufficient in OLTP Database.

I would leave it MAXDOP...

Hi thanks Gail for your clarification, Could you please post the correct script?

thanks

ananda

Thanks SQL Kiwi for your reply..

SQL Kiwi (1/28/2012)

---

Overall, my vote would be for you to leave things as they are, but to continue to monitor for allocation contention,...

Thank you so much:-)

One more doubts?

PAE and AWE fully deprecated these advance memory option in 64 bit system.

If I have 32 GB RAM, Can I have add /3GB boot.ini file windows 2008...

ok, please confirm as below configuration

So will decide to change disk configuration for before implementation SQL server 2008 in OLTP environment

Total five HD 300x5 15K RPM SAS, and get total...

Hi, Thanks for yours reply..

This OLTP Project not used advanced data storing

1. What's your physical spindle separation look like?

"D" drive for Data files MDF, NDF..

"E" drive for Tlog

"F"...

GilaMonster (1/25/2012)

---

With that memory config (4GB only), /3GB yes (lets SQL use 3 out of the 4 GB instead of 2), but not PAE. PAE is for AWE memory, that's...

please find the procedure and table text

I am really felt disgrace, not properly understand about that procedure cache hit ratio. It should be high percentage good and there are no issues, Thanks Gail and ChrisM@home for...

Hi,

I have memory issues one of the server. I had checked as below counters all are running good values. Except procedure cache cache Hit ratio..

1. Page life expectancey- 3,745 sec...