Search Results | SQL Server Performance Forums

Advice request

Post by: rkoros, Oct 31, 2005 in forum: Performance Tuning for Hardware Configurations

Hi Satya, Sorry for the delay in getting back to you. There must be a difference as we are currently using 24GB RAM with W2K3 Advanced server...

Advice request

Post by: rkoros, Oct 21, 2005 in forum: Performance Tuning for Hardware Configurations

Satya, Thank you for the information. I will have to update my maintenance scripts to include the recompilation and the updating of the statistics....

Advice request

Post by: rkoros, Oct 19, 2005 in forum: Performance Tuning for Hardware Configurations

I reindex the tables on a monthly basis and I have never forced a recompilation as it is supposed to be automatically done by the engine. Is it...

Advice request

Post by: rkoros, Oct 18, 2005 in forum: Performance Tuning for Hardware Configurations

Satya, Thanks for the information. I already found that general information and all of my detailed counters are over 94 percent, except Execution...

Advice request

Post by: rkoros, Oct 17, 2005 in forum: Performance Tuning for Hardware Configurations

Derrick, I am trying to find out more information regarding one of the detailed Cache Hit Ratio percentages, Execution Contexts, but other than the...

Advice request

Post by: rkoros, Oct 7, 2005 in forum: Performance Tuning for Hardware Configurations

OK, here goes. Current Disc Queue Length D: Average & Maximum: 0 E: Average: 0 Maximum: 2 F: Average & Maximum: 0 Average Disk Write Queue...

Advice request

Post by: rkoros, Oct 6, 2005 in forum: Performance Tuning for Hardware Configurations

OK, I have some specifications along with the drive configuration Two Perc 4/DC controllers Controller 0 C: Consists of OS RAID 1 D: Consists of...

Advice request

Post by: rkoros, Oct 6, 2005 in forum: Performance Tuning for Hardware Configurations

I would love to get the information, but we don't have the new application yet. I can pull the information for the current system which will help,...

Advice request

Post by: rkoros, Oct 5, 2005 in forum: Performance Tuning for Hardware Configurations

Derrick,<br /><br />I am considering the CX500 from Dell with physical RAID arrays for each production environment, i.e. ERP on one set,...

Advice request

Post by: rkoros, Oct 5, 2005 in forum: Performance Tuning for Hardware Configurations

Joe, Thanks for the information. Though I do have a few points that I would like to expand upon. The SAN that I am looking at using would be...

Advice request

Thread by: rkoros, Sep 29, 2005, 20 replies, in forum: Performance Tuning for Hardware Configurations

I need help trying to figure out the best way to configure my db servers to handle the coming workload. Here is my situation; current load consists...