Koen Verbeeck (11/5/2012)
sanket kokane (11/5/2012)
Also consider this as your very last options.To speed up your DB check,first check if there any scope for Query Tuning.
I wouldn't consider this the last option. Of course, query tuning is important, I won't deny that.
In the session "Building the fastest SQL Servers", Brent Ozar - which we can consider a performance guru - had this piece of advice for OLTP systems: "add enough RAM so that your DB fits into memory".
Original video can be watched here:
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI328
What I was mean to say is consider enabling /PAE as your last option.
and first check if there any scope for Query Tuning.
Of course I have bad experience with /PAE .
-----------------------------------------------------------------------------
संकेत कोकणे